uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

sys_role

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	rol_unit_id	Integer				Unidade
	rol_id	SmallInt			nextval('"URX_PUBLIC".sys_role_id_seq'::regclass)	Identificador
	rol_scope	SmallInt			0	Escopo
	rol_delete_bit	SmallInt			0	Bit de Exclusão
	rol_label	VarChar(50)				Rótulo

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_sys_role_unit	URX_PUBLIC.adm_unit	URX_PUBLIC.sys_role	uni_person_id	rol_unit_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_sys_privilege_sys_role	URX_PUBLIC.sys_role	URX_PUBLIC.sys_function_privilege	rol_id	pri_role_id
fk_sys_module_privilege_sys_role	URX_PUBLIC.sys_role	URX_PUBLIC.sys_module_privilege	rol_id	pri_role_id
fk_sys_user_sys_role	URX_PUBLIC.sys_role	URX_PUBLIC.sys_user	rol_id	use_role_id

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

Used in Diagrams

Diagram Name

diagramA