Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | null |
|
|
|||
| version | int8 | 19 | null |
|
|
|||
| kuvaus | varchar | 255 | √ | null |
|
|
||
| lahde | varchar | 255 | null |
|
|
|||
| on_pakollinen | bool | 1 | null |
|
|
|||
| tunniste | varchar | 255 | null |
|
|
|||
| funktiokutsu_id | int8 | 19 | null |
|
|
|||
| epasuora_viittaus | bool | 1 | √ | null |
|
|
||
| indeksi | int4 | 10 | null |
|
|
|||
| tekstiryhma_id | int8 | 19 | √ | null |
|
|
||
| vaatii_osallistumisen | bool | 1 | √ | null |
|
|
||
| syotettavissa_kaikille | bool | 1 | √ | null |
|
|
||
| syotettavanarvontyyppi_id | int8 | 19 | √ | null |
|
|
||
| tilastoidaan | bool | 1 | √ | null |
|
|
||
| transaction_id | int8 | 19 | null |
|
|
|||
| update_time | timestamptz | 35,6 | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| valintaperuste_viite_history_update_time_idx | Performance | Asc | update_time |
Relationships
Close relationships within degrees of separation
