Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table backend_dev.public.beneficiary_data Dane 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('beneficiary_data_id_seq'::regclass) |
contract_note.beneficiary_data_id | fke17332ff372529ef
|  | Identyfikator
applicantname | varchar | 500 |  |  |  |  |  | Nazwa wnioskodawcy
applicant_nip | varchar | 30 |  |  |  |  |  | NIP
postal_code | varchar | 10 |  |  |  |  |  | Kod pocztowy
city | varchar | 100 |  |  |  |  |  | Miasto
street | varchar | 64 | √ |  | null |  |  | Ulica
house_number | varchar | 8 |  |  |  |  |  | Numer domu
flat_number | varchar | 8 | √ |  | null |  |  | Numer mieszkania
phone | varchar | 30 |  |  |  |  |  | Telefon
fax_no | varchar | 30 |  |  |  |  |  | Numer faksu
legal_form_name | varchar | 100 |  |  |  |  |  | Nazwa formy prawnej
regon | varchar | 14 |  |  |  |  |  | REGON
type_of_applicant_name | varchar | 384 |  |  |  |  |  | Typ wnioskodawcy
description | varchar | 500 | √ |  | null |  |  | Opis
Analyzed at Wed Nov 26 19:06 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: