Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| koulutus_id | uuid | 2147483647 | √ | null |
|
|
||
| external_id | text | 2147483647 | √ | null |
|
|
||
| tila | text | 2147483647 | √ | null |
|
|
||
| nimi_fi | text | 2147483647 | √ | null |
|
|
||
| nimi_sv | text | 2147483647 | √ | null |
|
|
||
| nimi_en | text | 2147483647 | √ | null |
|
|
||
| koulutus_nimi | json | 2147483647 | √ | null |
|
|
||
| omistaja_organisaatio | text | 2147483647 | √ | null |
|
|
||
| luotu | timestamp | 29,6 | √ | null |
|
|
||
| kuvaus | json | 2147483647 | √ | null |
|
|
||
| hakuaika_alkaa | timestamp | 29,6 | √ | null |
|
|
||
| hakuaika_paattyy | timestamp | 29,6 | √ | null |
|
|
||
| aloituspaikat_lkm | int4 | 10 | √ | null |
|
|
||
| is_tyovoimakoulutus | bool | 1 | √ | null |
|
|
||
| johtaa_tutkintoon | bool | 1 | √ | null |
|
|
||
| is_maksullinen | bool | 1 | √ | null |
|
|
||
| hakulomake_linkki | json | 2147483647 | √ | null |
|
|
||
| maksullisuus_kuvaus | json | 2147483647 | √ | null |
|
|
||
| kielivalinta | json | 2147483647 | √ | null |
|
|
||
| tarjoajat | json | 2147483647 | √ | null |
|
|
||
| ammattinimikkeet | json | 2147483647 | √ | null |
|
|
||
| asiasanat | json | 2147483647 | √ | null |
|
|
||
| opetuskielet | json | 2147483647 | √ | null |
|
|
||
| osaaminen_urit_json | json | 2147483647 | √ | null |
|
|
||
| muokattu | timestamptz | 35,6 | √ | null |
|
|
||
| dw_metadata_source_timestamp_at | timestamptz | 35,6 | √ | null |
|
|
||
| dw_metadata_stg_stored_at | timestamptz | 35,6 | √ | null |
|
|
||
| dw_metadata_dbt_copied_at | timestamptz | 35,6 | √ | null |
|
|
||
| dw_metadata_filename | varchar | 2147483647 | √ | null |
|
|
||
| dw_metadata_file_row_number | int4 | 10 | √ | null |
|
|
||
| dw_metadata_dw_stored_at | timestamptz | 35,6 | √ | null |
|
|