Table frontend.public.suboperation
Poddziałania - sekcja A.3

 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('suboperation_id_seq'::regclass)
indicator_description.id_suboperation fka3b201cc2698a538
project.id_suboperation project_suboperation
suboperation_area_type.id_suboperation suboperation_area_type_suboperation
suboperation_field_configuration.id_suboperation suboperation_field_configuration_suboperation
suboperation_funding_form.id_suboperation suboperation_funding_form_id_suboperation_fkey
suboperation_intervention_category.id_suboperation suboperation_intervention_category_suboperation
suboperation_legal_base.id_suboperation suboperation_legal_base_suboperation
suboperation_type_of_applicant.id_suboperation suboperation_type_of_applicant_suboperation
suboperation_type_of_project.id_suboperation suboperation_type_of_project_suboperation
Identyfikator
number varchar 8  √  null Numer poddziałania
name varchar 256  √  null Nazwa poddziałania
active bool 1  √  true Aktywny - nieaktywny
id_operation int4 10  √  null
operation.id suboperation_operation
Identyfikator
max_requested_level numeric 19,2  √  null

Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc suboperation_pkey  
name Must be unique Asc unq_suboperation_name This unique column is also nullable

Close relationships  within of separation: