Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.expense_year Rok (w którym wystąpił 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_year_id_seq'::regclass) |  |  | Identyfikator
year | int4 | 10 | √ |  | null |  |  | Rok
id_expense | int4 | 10 | √ |  | null |  |
expense.id | expense_value_expense
| Identyfikator wydatku
qualified_vat | numeric | 15,2 | √ |  | null |  |  | Vat kwalifikowany
qualified_part | numeric | 15,2 | √ |  | null |  |  | Część kwalifikowana
unqualified_vat | numeric | 15,2 | √ |  | null |  |  | Vat niekwalifikowany
unqualified_part | numeric | 15,2 | √ |  | null |  |  | Część niekwalifikowana
sum | numeric | 15,2 | √ |  | null |  |  | Suma
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: