uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

sys_file

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	fil_id	Integer			nextval('"URX_PUBLIC".sys_file_id_seq'::regclass)	Identificador
	fil_unit_id	Integer				Unidade
	fil_size	Integer				Tamanho
	fil_delete_bit	SmallInt			0	Bit de Exclusão
	fil_name	VarChar(255)				Nome
	fil_type	VarChar(100)				Tipo
	fil_data	Bytea				Conteúdo

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_sys_file_unit	URX_PUBLIC.adm_unit	URX_PUBLIC.sys_file	uni_person_id	fil_unit_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_abi_employee_image	URX_PUBLIC.sys_file	URX_PUBLIC.abi_employee	fil_id	emp_image_id
fk_abi_employee_signature	URX_PUBLIC.sys_file	URX_PUBLIC.abi_employee	fil_id	emp_signature_id
fk_abi_employee_certificate_sys_file	URX_PUBLIC.sys_file	URX_PUBLIC.abi_employee_certificate	fil_id	emc_image_id
fk_adm_unit_sys_file_logo_big	URX_PUBLIC.sys_file	URX_PUBLIC.adm_unit	fil_id	uni_logo_big_id
fk_adm_unit_sys_file_logo_small	URX_PUBLIC.sys_file	URX_PUBLIC.adm_unit	fil_id	uni_logo_small_id
fk_fin_bank_order_sys_file	URX_PUBLIC.sys_file	URX_PUBLIC.fin_bank_order	fil_id	ban_order_file_id
fk_fin_bank_order_feedback_sys_file	URX_PUBLIC.sys_file	URX_PUBLIC.fin_bank_order_feedback	fil_id	ban_order_feedback_file_id
fk_fin_billing_sys_file	URX_PUBLIC.sys_file	URX_PUBLIC.fin_billing	fil_id	bil_file_id
fk_fin_invoice_sys_file	URX_PUBLIC.sys_file	URX_PUBLIC.fin_invoice	fil_id	inv_file_id
fk_fin_invoice_feedback_sys_file	URX_PUBLIC.sys_file	URX_PUBLIC.fin_invoice_feedback	fil_id	inv_feedback_file_id
fk_fin_invoice_request_sys_file	URX_PUBLIC.sys_file	URX_PUBLIC.fin_invoice_request	fil_id	inv_request_file_id
fk_kno_notice_sys_file	URX_PUBLIC.sys_file	URX_PUBLIC.kno_notice	fil_id	not_file_id
fk_ope_document_sys_file	URX_PUBLIC.sys_file	URX_PUBLIC.ope_document	fil_id	doc_file_id
fk_sto_chemical_product_file	URX_PUBLIC.sys_file	URX_PUBLIC.sto_chemical_product	fil_id	che_product_file_id

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

Used in Diagrams

Diagram Name

diagramA