Table frontend.public.intervention_category
Kategoria interwencji - sekcja A.4

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('intervention_category_id_seq'::regclass)
operation_intervention_category.id_intervention_category operation_intervention_category_intervention_category
project.id_intervention_category project_intervention_category
suboperation_intervention_category.id_intervention_category suboperation_intervention_category_intervention_category
Identyfikator
number varchar 8  √  null Numer
name varchar 256  √  null Nazwa kategorii interwencji
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 intervention_category_pkey  
name Must be unique Asc unq_intervention_category_name This unique column is also nullable
number Must be unique Asc unq_intervention_category_number This unique column is also nullable

Close relationships  within of separation: