uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

ope_document

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	doc_dt	TimeStampWithTimeZone				Data
	doc_service_id	Integer				Serviço
	doc_file_id	Integer				Arquivo
	doc_analysis_id	Integer				Laudo de Análise Laboratorial
	doc_id	Integer			nextval('"URX_PUBLIC".ope_document_id_seq'::regclass)	Identificador
	doc_pre_doc_id	SmallInt				Documento Pré-Formatado
	doc_delete_bit	SmallInt			0	Bit de Exclusão
	doc_label	VarChar(255)				Rótulo
	doc_remarks	VarChar(255)				Comentário

Indexes
Name	Table	Columns	Unique	Clustered
ix_ope_document_ope_analysis	URX_PUBLIC.ope_document	doc_analysis_id
ix_ope_document_ope_pre_doc	URX_PUBLIC.ope_document	doc_pre_doc_id
ix_ope_document_ope_service	URX_PUBLIC.ope_document	doc_service_id
ix_ope_document_sys_file	URX_PUBLIC.ope_document	doc_file_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ope_document_ope_analysis	URX_PUBLIC.ope_analysis	URX_PUBLIC.ope_document	ana_id	doc_analysis_id
fk_ope_document_ope_pre_doc	URX_PUBLIC.ope_pre_doc	URX_PUBLIC.ope_document	pre_doc_id	doc_pre_doc_id
fk_ope_document_ope_service	URX_PUBLIC.ope_service	URX_PUBLIC.ope_document	ser_id	doc_service_id
fk_ope_document_sys_file	URX_PUBLIC.sys_file	URX_PUBLIC.ope_document	fil_id	doc_file_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ope_document_status_ope_document	URX_PUBLIC.ope_document	URX_PUBLIC.ope_document_status	doc_id	doc_status_id
fk_ope_ruled_report_document	URX_PUBLIC.ope_document	URX_PUBLIC.ope_ruled_report	doc_id	rul_report_document_id
fk_ope_work_order_ope_document	URX_PUBLIC.ope_document	URX_PUBLIC.ope_work_order	doc_id	wor_order_document_id

Triggers
Name	Table	On Delete	On Insert	On Update	Execute	For Each	SQL
tg_doc_dt	URX_PUBLIC.ope_document				BEFORE	FOR EACH ROW	"URX_PUBLIC"."_u ...
tg_ope_document_create	URX_PUBLIC.ope_document				AFTER	FOR EACH ROW	"URX_PUBLIC"."_u ...

Used in Diagrams

Diagram Name

diagramA