uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

fin_supplier

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	sup_id	Integer				Identificador
	sup_type_id	SmallInt				Tipo de Fornecedor
	sup_delete_bit	SmallInt			0	Bit de Exclusão
	sup_contact_name	VarChar(100)				Pessoa da Contato
	sup_remarks	VarChar(100)				Observação
	sup_cod	VarChar(6)				Código do Sistema Legado

Indexes
Name	Table	Columns	Unique	Clustered
ix_fin_supplier_fin_supplier_type	URX_PUBLIC.fin_supplier	sup_type_id
ix_fin_supplier_sys_person	URX_PUBLIC.fin_supplier	sup_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_fin_supplier_fin_supplier_type	URX_PUBLIC.fin_supplier_type	URX_PUBLIC.fin_supplier	sup_type_id	sup_type_id
fk_fin_supplier_sys_person	URX_PUBLIC.sys_person	URX_PUBLIC.fin_supplier	per_id	sup_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_fin_debt_supplier	URX_PUBLIC.fin_supplier	URX_PUBLIC.fin_debt	sup_id	deb_supplier_id
fk_ope_analysis_request_fin_supplier	URX_PUBLIC.fin_supplier	URX_PUBLIC.ope_analysis_request	sup_id	ana_request_supplier_id
fk_sto_request_payment_option	URX_PUBLIC.fin_supplier	URX_PUBLIC.sto_request	sup_id	req_supplier_id

Triggers (none)

Used in Diagrams

Diagram Name

diagramA