Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.suboperation Poddziałania - sekcja A.3 | 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('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 one two degrees of separation: