Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.public_assistance Pomoc publiczna - sekcja A.8 | 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('public_assistance_id_seq'::regclass) |
prerequisite_of_public_assistance.id_public_assistance | prerequisite_of_public_assistance_public_assistance
|  | Identyfikator
id_project | int4 | 10 | √ |  | null |  |
project.id | public_assistance_project
| Identyfikator projektu
id_legal_base | int4 | 10 | √ |  | null |  |
legal_base.id | public_assistance_legal_base
| Identyfikator podstawy prawnej
id_legal_base_auto | int4 | 10 | √ |  | null |  |
legal_base.id | public_assistance_legal_base_auto
| Identyfikator
id_legal_base_cross_finance | int4 | 10 | √ |  | null |  |
legal_base.id | public_assistance_legal_base_cross_finance
| Identyfikator podstawy prawnej - cross finansing
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

Column(s) | Type | Sort | Constraint Name | Anomalies
--- | --- | --- | --- | ---
id | Primary key | Asc | public_assistance_pkey |
id_project | Must be unique | Asc | id_project_unique | This unique column is also nullable

Close relationships within one two degrees of separation: