Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.pay_period Wniosek o Płatność - suma wydatków | 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_period_id_seq'::regclass) |
pay_invoice.period_id | fkc9a072966c100ac8
|  | Identyfikator
qualified_amount_sum | numeric | 17,2 |  |  |  |  |  | Część kwalifikowalna / suma z wniosku
qualified_vat_amount_sum | numeric | 17,2 |  |  |  |  |  | VAT kwalifikowalny / suma z wniosku
expense_id | int8 | 19 |  |  |  |  |
pay_expense.id | fk8dd13538ce0d0bcc
| Identyfikator wydatków
period_definition_id | int8 | 19 | √ |  | null |  |
pay_period_definition.id | fk8dd13538a5e9feab
| Identyfikator definicji okresu
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: