Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.project_location Lokalizacja projektu - sekcja C.1 | 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('project_location_id_seq'::regclass) |  |  | Identyfikator
id_district | int4 | 10 |  |  |  |  |
district.id | district_id_fk
| Identyfikator powiatu
id_commune | int4 | 10 |  |  |  |  |
commune.id | commune_id_fk
| Identyfikator gminy
id_city | int4 | 10 | √ |  | null |  |
city.id | id_city_fk
| Identyfikator miejscowości
id_project_description | int4 | 10 |  |  |  |  |
project_description.id | project_description_id_fk
| Identyfikator opis wskaźnika
city_code | varchar | 256 | √ |  | null |  |  | Miejscowość, kod pocztowy
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | project_location_pk

Close relationships within one two degrees of separation: