Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table backend_dev.public.control_year Kontrola roczna | 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('control_year_id_seq'::regclass) |
ctrl_control_plan_control.id_control | fkf8c35b3de9a95381
|  | Identyfikator
since | timestamp | 29,6 | √ |  | null |  |  | Termin kontroli od
date | timestamp | 29,6 | √ |  | null |  |  | Data
period | varchar | 32 | √ |  | null |  |  | Czas trwania
control_domain | varchar | 1000 | √ |  | null |  |  | Zakres kontrolny
rudiments | varchar | 2000 | √ |  | null |  |  | Podstawy prawne
control_subject_domain | varchar | 2000 | √ |  | null |  |  | Zakres tematyczny
control_methods | varchar | 2000 | √ |  | null |  |  | Metody kontroli
control_team | varchar | 500 | √ |  | null |  |  | Zespół kontrolny
organization_structure | varchar | 1000 | √ |  | null |  |  | Struktura organizacyjna jednostki
id_control | int4 | 10 |  |  |  |  |
ctrl_control.id | fk9f45addfe0e684a4
| Identyfikator kontroli
Analyzed at Wed Nov 26 19:06 CET 2008

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | control_year_pkey

Close relationships within one two degrees of separation: