Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.address Adres - sekcja B.4, B.6, B.9 | 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('address_id_seq'::regclass) |
applicant.id_correspondence_address | id_correspondence_address_fk
applicant.id_registration_address | id_registration_address_fk
person.id_correspondence_address | person_correspondence_address
person.id_registration_address | person_registration_address
user_registration.id_correspondence_address | user_correspondence_address
user_registration.id_resident_address | user_resident_address
|  | Identyfikator
street | varchar | 64 | √ |  | null |  |  | Adres - ulica
house_number | varchar | 8 | √ |  | null |  |  | Numer domu
flat_number | varchar | 8 | √ |  | null |  |  | Numer mieszkania
postal_code | varchar | 10 | √ |  | null |  |  | Kod pocztowy
id_city | int4 | 10 | √ |  | null |  |
city.id | address_city
| Identyfikator miejscowości
id_commune | int4 | 10 | √ |  | null |  |
commune.id | address_commune
| Identyfikator gminy
id_district | int4 | 10 | √ |  | null |  |
district.id | address_district
| Identyfikator powiatu
id_province | int4 | 10 | √ |  | null |  |
province.id | address_province
| Identyfikator województwa
city | varchar | 100 | √ |  | null |  |  | Adres - miejscowość
province | varchar | 200 | √ |  | null |  |  | Adres - województwo
district | varchar | 200 | √ |  | null |  |  | Adres - powiat
commune | varchar | 200 | √ |  | null |  |  | Adres - gmina
has_location_info | bool | 1 |  |  | true |  |  |
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: