Table clean.public.permission 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('permission_id_seq'::regclass)
role_permission.permission_id role_permission_fk_permission_id R
study_module_status.id Implied Constraint R
access_url varchar 1000  √  null
version int4 10  √  0
access_parameters varchar 1000  √  null
is_admin bool 1  √  false
name_in_navbar varchar 200  √  null

Table contained 241 rows at Wed Feb 01 09:18 EST 2012

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc pk_permission  
access_url + access_parameters Must be unique Asc/Asc comp_access_url_parameter These unique columns are also nullable

Close relationships  within of separation: