Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.expense Wydatek - sekcja E.1 | 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('expense_id_seq'::regclass) |
expense_year.id_expense | expense_value_expense
|  | Identyfikator
name | varchar | 250 | √ |  | null |  |  | Nazwa wydatku
id_task | int4 | 10 | √ |  | null |  |
task.id | expense_task
| Identyfikator zadania
qualified_vat_rate | numeric | 15,2 | √ |  | null |  |  | Suma VAT kwalifikowanych
unqualified_vat_rate | numeric | 15,2 | √ |  | null |  |  | Współczynnik VAT niekwalifikowanych
qualified_vat_sum | numeric | 15,2 | √ |  | null |  |  | Suma vatu kwalifikowanego
unqualified_vat_sum | numeric | 15,2 | √ |  | null |  |  | Suma VAT niekwalifikowanych
qualified_part_sum | numeric | 15,2 | √ |  | null |  |  | Suma części kwalifikowanej
unqualified_part_sum | numeric | 15,2 | √ |  | null |  |  | Suma części niekwalifikowanej
overall_sum | numeric | 15,2 | √ |  | null |  |  | Suma całkowita
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: