Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.pay_financing_entry Wniosek o Płatność - Informacja finansowa - dokumenty | 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_financing_entry_id_seq'::regclass) |  |  | Identyfikator
document_number | varchar | 20 | √ |  | null |  |  | Nr. dokumentu (B.1)
record_number | varchar | 30 | √ |  | null |  |  | Numer księgowy lub ewidencyjny (B.1)
document_creation_date | timestamp | 29,6 | √ |  | null |  |  | Data wystawienia dokumentu (B.1)
payment_date | timestamp | 29,6 | √ |  | null |  |  | Data zapłaty (B.1)
payment_evidence | varchar | 200 | √ |  | null |  |  | Dowody wpłaty (B.1)
product_name | varchar | 100 | √ |  | null |  |  | Nazwa towaru lub usługi (B.1)
nip | varchar | 10 | √ |  | null |  |  | NIP podmiotu, na który został wystawiony dokument (B.1)
brutto_amount | numeric | 17,2 | √ |  | null |  |  | kwota dokumnetu brutto (B.1)
netto_amount | numeric | 17,2 | √ |  | null |  |  | Kwota dokumentu netto (B.1)
qualified_expense_amount | numeric | 17,2 | √ |  | null |  |  | Kwota wydatków kwalifikowalnych (B.1)
vat_amount | numeric | 17,2 | √ |  | null |  |  | W tym VAT (B.1)
financing_information_id | int8 | 19 |  |  |  |  |
pay_financing_information.id | fkf93cd2b3a478705a
| Identyfikator informacji finansowej
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: