Table frontend.public.user_registration
Dane z rejestracji beneficjenta

 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('user_registration_id_seq'::regclass)
application_form.id_user application_form_owner
folder.id_user folder_user
user_application_form.id_user user_version_user
user_registration_message.id_user_registration user_registration
Identyfikator
name varchar 64  √  null Imię
nip varchar 16  √  null NIP
pesel varchar 16  √  null PESEL
regon varchar 16  √  null REGON
phone varchar 16  √  null Telefon
phone_mobile varchar 16  √  null Numer tel. kom.
id_doc_number varchar 16  √  null Nieużywane
id_operator int4 10  √  null Identyfikator użytkownika
id_resident_address int4 10  √  null
address.id user_resident_address
Identyfikator adresu zamieszkania
id_correspondence_address int4 10  √  null
address.id user_correspondence_address
Identyfikator adresu do korespondecji
surname varchar 64  √  null Nazwisko
email varchar 64  √  null E-mail
account_name varchar 200  √  null Nazwa

Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc user_pkey

Close relationships  within of separation: