Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.sec_role Autoryzacja - role | Generated by SchemaSpy

Related columns Constraint names Comments Legend |
Legend: |
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:04 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 one two degrees of separation: