uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

ope_pre_doc

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	pre_doc_id	SmallInt			nextval('"URX_PUBLIC".ope_pre_doc_id_seq'::regclass)	Identificador
	pre_doc_entity	SmallInt				Entidade Associada
	pre_doc_scope	SmallInt			1	Escopo
	pre_doc_orientation	SmallInt			1	Orientação
	pre_doc_delete_bit	SmallInt			0	Bit de Exclusão
	pre_doc_data	Text				Conteúdo
	pre_doc_label	VarChar(255)				Rótulo
	pre_doc_label_abbrev	VarChar(100)				Rótulo Abreviado
	pre_doc_footer	VarChar(50)				Rodapé
	pre_doc_reference	VarChar(50)				Documento de Referência

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ope_pre_doc_sys_object	URX_PUBLIC.sys_object	URX_PUBLIC.ope_pre_doc	obj_id	pre_doc_entity

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ope_document_ope_pre_doc	URX_PUBLIC.ope_pre_doc	URX_PUBLIC.ope_document	pre_doc_id	doc_pre_doc_id
fk_ope_pre_doc_attrib_ope_pre_doc	URX_PUBLIC.ope_pre_doc	URX_PUBLIC.ope_pre_doc_attrib	pre_doc_id	pre_doc_attrib_pre_doc_id
fk_ope_pre_doc_unit_doc	URX_PUBLIC.ope_pre_doc	URX_PUBLIC.ope_pre_doc_unit	pre_doc_id	pre_doc_unit_pre_doc_id
fk_ope_ruled_report_ope_pre_doc	URX_PUBLIC.ope_pre_doc	URX_PUBLIC.ope_ruled_report	pre_doc_id	rul_report_pre_doc_id
fk_ope_service_type_group_pre_doc_document	URX_PUBLIC.ope_pre_doc	URX_PUBLIC.ope_service_type_group_pre_doc	pre_doc_id	ser_type_group_pre_doc_pre_doc_id
fk_ope_service_type_pre_doc_document	URX_PUBLIC.ope_pre_doc	URX_PUBLIC.ope_service_type_pre_doc	pre_doc_id	ser_type_pre_doc_pre_doc_id

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

Used in Diagrams

Diagram Name

diagramA