uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

fin_transaction_type

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	tra_type_id	SmallInt			nextval('"URX_PUBLIC".fin_transaction_type_id_seq'::regclass)	Identificador
	tra_type_delete_bit	SmallInt			0	Bit de Exclusão
	tra_type_label	VarChar(50)				Rótulo
	tra_type_is_credit	SmallInt			0	Aplicável a Crédito
	tra_type_is_debit	SmallInt			0	Aplicável a Débito
	tra_type_is_transference	SmallInt			0	Aplicável a Transferência
	tra_type_legacy	VarChar(3)				Rótulo do Legado

Indexes (none)

Foreign Keys (none)

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_fin_debt_transaction_type	URX_PUBLIC.fin_transaction_type	URX_PUBLIC.fin_debt	tra_type_id	deb_transaction_type_id
fk_fin_invoice_transaction_type	URX_PUBLIC.fin_transaction_type	URX_PUBLIC.fin_invoice	tra_type_id	inv_type_id
fk_fin_transference_type	URX_PUBLIC.fin_transaction_type	URX_PUBLIC.fin_transference	tra_type_id	tra_type_id
fk_ope_service_payment_way	URX_PUBLIC.fin_transaction_type	URX_PUBLIC.ope_service	tra_type_id	ser_payment_way

Triggers
Name	Table	On Delete	On Insert	On Update	Execute	For Each	SQL
tg_fin_transaction_type_create	URX_PUBLIC.fin_transaction_type				AFTER	FOR EACH ROW	"URX_PUBLIC"."_u ...

Used in Diagrams

Diagram Name

diagramA