uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

abi_rule

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	rul_unit_id	Integer				Unidade
	rul_id	SmallInt			nextval('"URX_PUBLIC".abi_rule_id_seq'::regclass)	Identificador
	rul_function_id	SmallInt				Função Associada com a Norma
	rul_team_type_id	SmallInt				Tipo de Equipe Associado com a Norma
	rul_delete_bit	SmallInt			0	Bit de Exclusão

Indexes
Name	Table	Columns	Unique	Clustered
ix_abi_rule_abi_function	URX_PUBLIC.abi_rule	rul_function_id
ix_abi_rule_ope_team_type	URX_PUBLIC.abi_rule	rul_team_type_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_abi_rule_abi_function	URX_PUBLIC.abi_function	URX_PUBLIC.abi_rule	fun_id	rul_function_id
fk_abi_rule_ope_team_type	URX_PUBLIC.ope_team_type	URX_PUBLIC.abi_rule	tea_type_id	rul_team_type_id
fk_abi_rule_unit	URX_PUBLIC.adm_unit	URX_PUBLIC.abi_rule	uni_person_id	rul_unit_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_abi_rule_certificate_abi_rule	URX_PUBLIC.abi_rule	URX_PUBLIC.abi_rule_certificate	rul_id	rul_certificate_rule_id

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

Used in Diagrams

Diagram Name

diagramA