Table backend_dev.public.control_year
Kontrola roczna

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('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 of separation: