Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.person Osoba - sekcje B.4, B.5 | 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('person_id_seq'::regclass) |
applicant_person_agreement.id_person | applicant_person_agreement_person
applicant_person_contact.id_person | applicant_person_contact_person
subject_partner.id_person | subject_partner_person
|  | Identyfikator
name | varchar | 64 | √ |  | null |  |  | Nazwa
occupation | varchar | 200 | √ |  | null |  |  | Stanowisko
nip | varchar | 16 | √ |  | null |  |  | Nip
pesel | varchar | 16 | √ |  | null |  |  | Pesel
regon | varchar | 16 | √ |  | null |  |  | Regon
number_krs | varchar | 32 | √ |  | null |  |  | Numer krs
number_edg | varchar | 32 | √ |  | null |  |  | Numer edg
phone | varchar | 30 | √ |  | null |  |  | Telefon
phone_mobile | varchar | 30 | √ |  | null |  |  | Telefon komórkowy
fax_no | varchar | 30 | √ |  | null |  |  | Numer faksu
email | varchar | 64 | √ |  | null |  |  | Email
id_registration_address | int4 | 10 | √ |  | null |  |
address.id | person_registration_address
| Identyfikator adresu zameldowania
id_correspondence_address | int4 | 10 | √ |  | null |  |
address.id | person_correspondence_address
| Identyfikator adresu korespondencyjnego
www | varchar | 100 | √ |  | null |  |  | Adres www
role_in_project | varchar | 1000 | √ |  | null |  |  | Rola w projekcie
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: