Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table backend_dev.public.advance_payment_data Dane dotyczące zaliczki | 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('advance_payment_data_id_seq'::regclass) |
contract_note.advanced_payment_data_id | fke17332ff5117fde
|  | identyfikator
bank_account_number | varchar | 40 | √ |  | null |  |  | numer rachunku bankowego dla rachunku
has_advance | bool | 1 | √ |  | null |  |  | zaliczka
advance_amount | numeric | 19,2 | √ |  | null |  |  | kwota zaliczki
calculate_type | int4 | 10 | √ |  | null |  |  | wybór jednej z dwóch poniżej wynienionych metod obliczania % zaliczki: (0) - nieznana, (1) - procent od wydatków kwalifikowanych, (2) - procent od wydatków kwalifikowanych - wkład własny
qualified_percent | numeric | 19,2 | √ |  | null |  |  | procent zaliczki od wydatków kwalifikowanych
qualified_percent_self_investment | numeric | 19,2 | √ |  | null |  |  | procent zaliczki od różnicy wydatków kwalifikowanych i wkładu własnego
Analyzed at Wed Nov 26 19:06 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: