Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| valintakoe_id | text | 2147483647 | null |
|
|
||||||
| hakukohde_oid | text | 2147483647 | √ | null |
|
|
|||||
| valintakoe_nimi | text | 2147483647 | √ | null |
|
|
|||||
| valintakoe_kuvaus | text | 2147483647 | √ | null |
|
|
|||||
| valintakoe_peritty | bool | 1 | √ | null |
|
|
|||||
| valintakoe_tunniste | text | 2147483647 | √ | null |
|
|
|||||
| valintakoe_aktiivinen | bool | 1 | √ | null |
|
|
|||||
| valintakoe_kutsun_kohde | text | 2147483647 | √ | null |
|
|
|||||
| muokattu | timestamptz | 35,6 | √ | null |
|
|
|||||
| valintakoe_kutsutaanko_kaikki | bool | 1 | √ | null |
|
|
|||||
| valintakoe_lahetetaanko_koekutsut | bool | 1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| gen_valintakoe_valintakoe_id_pk | Primary key | Asc | valintakoe_id |
| 32d2e8c58b80f57ac3a06de536c9237e | Performance | Asc | hakukohde_oid |