uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

fin_bank

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	ban_legal_number	BigInt				CNPJ
	ban_status	SmallInt			1	Situação
	ban_bill_txt	VarChar(255)				Texto do Local de Pagamento do Boleto
	ban_name	VarChar(100)				Nome
	ban_url	VarChar(100)				URL
	ban_label	VarChar(50)				Rótulo
	ban_file_prefix_txt	VarChar(20)				Prefixo do nome do arquivo de remessa
	ban_label_namespace	VarChar(10)				Namespace
	ban_id	VarChar(3)				Código

Indexes (none)

Foreign Keys (none)

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_fin_account_fin_bank	URX_PUBLIC.fin_bank	URX_PUBLIC.fin_account	ban_id	acc_bank_id
fk_fin_bank_event_fin_bank	URX_PUBLIC.fin_bank	URX_PUBLIC.fin_bank_event	ban_id	ban_event_bank_id
fk_fin_bank_order_bank	URX_PUBLIC.fin_bank	URX_PUBLIC.fin_bank_order	ban_id	ban_order_bank_id
fk_fin_bank_order_feedback_bank	URX_PUBLIC.fin_bank	URX_PUBLIC.fin_bank_order_feedback	ban_id	ban_order_feedback_bank_id
fk_fin_debt_bank	URX_PUBLIC.fin_bank	URX_PUBLIC.fin_debt_check	ban_id	deb_check_bank_id
fk_fin_invoice_fin_bank	URX_PUBLIC.fin_bank	URX_PUBLIC.fin_invoice	ban_id	inv_bank
fk_fin_invoice_feedback_bank	URX_PUBLIC.fin_bank	URX_PUBLIC.fin_invoice_feedback	ban_id	inv_feedback_bank_id
fk_fin_invoice_request_bank	URX_PUBLIC.fin_bank	URX_PUBLIC.fin_invoice_request	ban_id	inv_request_bank_id
fk_fin_transference_bank	URX_PUBLIC.fin_bank	URX_PUBLIC.fin_transference_account	ban_id	tra_account_bank_id

Triggers (none)

Used in Diagrams

Diagram Name

diagramA