Table backend_dev.public.sec_role
Autoryzacja - role

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id serial 10  √  nextval('sec_role_id_seq'::regclass)
sec_operator_role.id_role sec_operator_role_sec_role
sec_permission_def.id_role sec_permission_def_sec_role
sec_role.id_role_parent sec_role_sec_role
Identyfikator
name varchar 32  √  null Nazwa
description varchar 2147483647  √  null Opis
changed_by varchar 256  √  null Zmieniono przez
change_date date 13  √  null Data zmiany
registered_by varchar 256  √  null Dodano przez
registration_date date 13  √  null Data dodania
status numeric 1  √  1 Status
id_system int4 10  √  null
sec_system.id sec_role_sec_system
System
id_role_parent int4 10  √  null
sec_role.id sec_role_sec_role
Identyfikator - rodzic

Analyzed at Wed Nov 26 19:06 CET 2008

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc role_pkey  
registration_date Must be unique Asc unq_role_name This unique column is also nullable

Close relationships  within of separation: