Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.pay_beneficiary_information Wniosek o Płatność - Dane beneficjenta (A.3) | 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('pay_beneficiary_information_id_seq'::regclass) |
pay_payment_form.beneficiary_information_id | fke2c2f194266da59f
|  | Identyfikator
street | varchar | 64 | √ |  | null |  |  | Ulica (A.3)
house_number | varchar | 8 | √ |  | null |  |  | Numer domu (A.3)
flat_number | varchar | 8 | √ |  | null |  |  | Numer lokalu (A.3)
city | varchar | 100 | √ |  | null |  |  | Miasto (A.3)
postal_code | varchar | 6 | √ |  | null |  |  | Kod pocztowy (A.3)
bank_account_owner | varchar | 200 | √ |  | null |  |  | Nazwa właściciela konta bankowego (A.3)
bank_name | varchar | 100 | √ |  | null |  |  | Nazwa banku (A.3)
bank_account_number | varchar | 28 | √ |  | null |  |  | Numer konta bankowego (A.3)
beneficiary_person_id | int8 | 19 | √ |  | null |  |
pay_person_info.id | fk1e0183b1c5e1a66
| Identyfikator danych beneficjenta (A.3)
realization_person_id | int8 | 19 | √ |  | null |  |
pay_person_info.id | fk1e0183bb8f16b47
| Identyfikator osoby w części dot. przebiegu realizacji projketu (A.3)
financial_person_id | int8 | 19 | √ |  | null |  |
pay_person_info.id | fk1e0183bf795030a
| Identyfikator osoby w części dot. postępu finansowego (A.3)
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: