Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| iddannakl | serial | 10 | √ | nextval('seq_mdannakl'::regclass) |
|
|
||||
| lastupdate | timestamp | 29,6 | '2008-01-01 00:00:00'::timestamp without time zone |
|
|
|||||
| datucto | date | 13 | √ | null |
|
|
||||
| datvyst | date | 13 | null |
|
|
|||||
| kod | varchar | 20 | null |
|
|
|||||
| modul | varchar | 3 | null |
|
|
|||||
| poznam | text | 2147483647 | √ | null |
|
|
||||
| sumzkl | numeric | 15,2 | 0.0 |
|
|
|||||
| sumzklmen | numeric | 15,2 | 0.0 |
|
|
|||||
| ucetni | bool | 1 | false |
|
|
|||||
| idzakazky | int4 | 10 | √ | null |
|
|
||||
| idstred | int4 | 10 | null |
|
|
|||||
| idzklmducet | int4 | 10 | √ | null |
|
|
||||
| idzkldalucet | int4 | 10 | √ | null |
|
|
||||
| idleasing | int4 | 10 | null |
|
|
Table contained 0 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| mdannakl_pkey | Primary key | Asc | iddannakl |
| mdannakl_datvyst_index | Performance | Asc | datvyst |
| mdannakl_idleasing_index | Performance | Asc | idleasing |
| mdannakl_idstred_index | Performance | Asc | idstred |
| mdannakl_idzakazky_index | Performance | Asc | idzakazky |
| mdannakl_idzkldalucet_index | Performance | Asc | idzkldalucet |
| mdannakl_idzklmducet_index | Performance | Asc | idzklmducet |
| mdannakl_kod_index | Performance | Asc | kod |
Relationships
Close relationships within degrees of separation
