Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.folder Teczka - teczka projektu, lista wniosków, zekcja zero WOP | 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('folder_id_seq'::regclass) |
application_form.id_folder | application_folder
message.id_folder | message_folder
note.id_folder | note_folder
|  | Identyfikator
name | varchar | 64 | √ |  | null |  |  | Nazwa teczki
id_user | int4 | 10 | √ |  | null |  |
user_registration.id | folder_user
| Identyfikator użytkownika
active | bool | 1 | √ |  | true |  |  | Aktywny - nieaktywny
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

Column(s) | Type | Sort | Constraint Name | Anomalies
--- | --- | --- | --- | ---
id | Primary key | Asc | folder_pkey |
name + id_user | Must be unique | Asc/Asc | unq_folder_name_id_user | These unique columns are also nullable

Close relationships within one two degrees of separation: