Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table backend_dev.public.official_registration Pracownicy | 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 | bigserial | 19 |  | √ | nextval('official_registration_id_seq'::regclass) |
applicant_person_agreement.official_registration_id | fk5579693d727865eb
|  | Identyfikator
operator_id | int8 | 19 | √ |  | null |  |  | Identyfikator użytkownika
login | varchar | 255 | √ |  | null |  |  | Nazwa użytkownika
first_name | varchar | 100 |  |  |  |  |  | Imię
last_name | varchar | 100 |  |  |  |  |  | Nazwisko
department | varchar | 200 | √ |  | null |  |  | Wydział
phone | varchar | 50 |  |  |  |  |  | Telefon
email | varchar | 200 |  |  |  |  |  | E-mail
street | varchar | 200 | √ |  | null |  |  | Ulica
house_number | varchar | 50 | √ |  | null |  |  | Nr budynku
flat_number | varchar | 50 | √ |  | null |  |  | Nr lokalu
room_number | varchar | 50 |  |  |  |  |  | Numer pokoju
official_localization_id | int4 | 10 |  |  |  |  |
official_localization.id | fk90e30d8d633519eb
| Lokalizacja
Analyzed at Wed Nov 26 19:06 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: