Table frontend.public.person
Osoba - sekcje B.4, B.5

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