uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

abi_function

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	fun_unit_id	Integer				Unidade
	fun_id	SmallInt			nextval('"URX_PUBLIC".abi_function_id_seq'::regclass)	Identificador
	fun_delete_bit	SmallInt			0	Bit de Exclusão
	fun_is_field	SmallInt			0	Trabalha em campo
	fun_department_id	SmallInt				Departamento
	fun_description	VarChar(100)				Nome Completo
	fun_label	VarChar(50)				Nome Abreviado
	fun_is_unique	SmallInt			0	Exclusivo
	fun_is_signature_required	SmallInt			0	Requer Assinatura
	fun_is_council_required	SmallInt			0	Requer Registro no Conselho de Classe
	fun_is_manager	SmallInt			0	Gerente
	fun_is_biologist	SmallInt			0	Biólogo
	fun_is_engineer	SmallInt			0	Engenheiro

Indexes
Name	Table	Columns	Unique	Clustered
ix_abi_function_label	URX_PUBLIC.abi_function	fun_label

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_abi_function_department	URX_PUBLIC.adm_department	URX_PUBLIC.abi_function	dep_id	fun_department_id
fk_abi_function_unit	URX_PUBLIC.adm_unit	URX_PUBLIC.abi_function	uni_person_id	fun_unit_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_abi_employee_abi_function	URX_PUBLIC.abi_function	URX_PUBLIC.abi_employee	fun_id	emp_function_id
fk_abi_rule_abi_function	URX_PUBLIC.abi_function	URX_PUBLIC.abi_rule	fun_id	rul_function_id
fk_pro_activity_type_abi_function	URX_PUBLIC.abi_function	URX_PUBLIC.pro_activity_type	fun_id	act_type_function_id

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

Used in Diagrams

Diagram Name

diagramA