Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | null |
|
|
|||
| version | int8 | 19 | null |
|
|
|||
| aktiivinen | bool | 1 | null |
|
|
|||
| kuvaus | varchar | 255 | √ | null |
|
|
||
| nimi | varchar | 255 | null |
|
|
|||
| oid | varchar | 255 | null |
|
|
|||
| tunniste | varchar | 255 | null |
|
|
|||
| laskentakaava_id | int8 | 19 | √ | null |
|
|
||
| master_valintakoe_id | int8 | 19 | √ | null |
|
|
||
| valinnan_vaihe_id | int8 | 19 | null |
|
|
|||
| lahetetaanko_koekutsut | bool | 1 | null |
|
|
|||
| kutsutaanko_kaikki | bool | 1 | √ | null |
|
|
||
| kutsuttavien_maara | int4 | 10 | √ | null |
|
|
||
| kutsun_kohde | varchar | 255 | √ | null |
|
|
||
| kutsun_kohde_avain | varchar | 255 | √ | null |
|
|
||
| transaction_id | int8 | 19 | null |
|
|
|||
| update_time | timestamptz | 35,6 | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| valintakoe_history_update_time_idx | Performance | Asc | update_time |
Relationships
Close relationships within degrees of separation
