Table frontend.public.address
Adres - sekcja B.4, B.6, B.9

 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('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 of separation: