Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.user_registration Dane z rejestracji beneficjenta | 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('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 one two degrees of separation: