uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

fin_account

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	acc_id	Integer			nextval('"URX_PUBLIC".fin_account_id_seq'::regclass)	Identificador
	acc_person_id	Integer				Pessoa
	acc_agency	Integer				Agência
	acc_number	Integer				Número da Conta
	acc_status_id	SmallInt			1	Situação
	acc_type_id	SmallInt			1	Tipo
	acc_delete_bit	SmallInt			0	Bit de Exclusão
	acc_bank_id	VarChar(3)				Banco
	acc_number_dv	VarChar(1)				Dígito Verificador da Conta
	acc_agency_dv	VarChar(1)				Dígito Verificador da Agência

Indexes
Name	Table	Columns	Unique	Clustered
ix_fin_account_fin_account_status	URX_PUBLIC.fin_account	acc_status_id
ix_fin_account_fin_account_type	URX_PUBLIC.fin_account	acc_type_id
ix_fin_account_fin_bank	URX_PUBLIC.fin_account	acc_bank_id
ix_fin_account_sys_person	URX_PUBLIC.fin_account	acc_person_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_fin_account_fin_account_status	URX_PUBLIC.fin_account_status	URX_PUBLIC.fin_account	acc_status_id	acc_status_id
fk_fin_account_fin_account_type	URX_PUBLIC.fin_account_type	URX_PUBLIC.fin_account	acc_type_id	acc_type_id
fk_fin_account_fin_bank	URX_PUBLIC.fin_bank	URX_PUBLIC.fin_account	ban_id	acc_bank_id
fk_fin_account_sys_person	URX_PUBLIC.sys_person	URX_PUBLIC.fin_account	per_id	acc_person_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_adm_unit_fin_account_cobranca	URX_PUBLIC.fin_account	URX_PUBLIC.adm_unit	acc_id	uni_cobranca_default_account
fk_adm_unit_fin_account_pagamento	URX_PUBLIC.fin_account	URX_PUBLIC.adm_unit	acc_id	uni_pagamento_default_account
fk_fin_account_parameter_adm_unit	URX_PUBLIC.fin_account	URX_PUBLIC.fin_account_parameter	acc_id	acc_parameter_account_id
fk_fin_bank_order_account	URX_PUBLIC.fin_account	URX_PUBLIC.fin_bank_order	acc_id	ban_order_account_id
fk_fin_bank_order_feedback_account	URX_PUBLIC.fin_account	URX_PUBLIC.fin_bank_order_feedback	acc_id	ban_order_feedback_account_id
fk_fin_credit_cell_account	URX_PUBLIC.fin_account	URX_PUBLIC.fin_credit_cell	acc_id	cre_account_id
fk_fin_invoice_account	URX_PUBLIC.fin_account	URX_PUBLIC.fin_invoice	acc_id	inv_account_id
fk_fin_invoice_feedback_account	URX_PUBLIC.fin_account	URX_PUBLIC.fin_invoice_feedback	acc_id	inv_feedback_account_id
fk_fin_invoice_request_account	URX_PUBLIC.fin_account	URX_PUBLIC.fin_invoice_request	acc_id	inv_request_account_id

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

Used in Diagrams

Diagram Name

diagramA