Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| hakukohde_oid | text | 2147483647 | √ | null |
|
|
||
| aidinkieli | text | 2147483647 | √ | null |
|
|
||
| kansalaisuusluokka | int4 | 10 | √ | null |
|
|
||
| sukupuoli | int4 | 10 | √ | null |
|
|
||
| kansalaisuus | text | 2147483647 | √ | null |
|
|
||
| ensikertalainen | bool | 1 | √ | null |
|
|
||
| hakijat | int8 | 19 | √ | null |
|
|
||
| ensisijaisia | int8 | 19 | √ | null |
|
|
||
| ensikertalaisia | int8 | 19 | √ | null |
|
|
||
| hyvaksytyt | int8 | 19 | √ | null |
|
|
||
| vastaanottaneet | int8 | 19 | √ | null |
|
|
||
| lasna | int8 | 19 | √ | null |
|
|
||
| poissa | int8 | 19 | √ | null |
|
|
||
| ilm_yht | int8 | 19 | √ | null |
|
|
||
| maksuvelvollisia | int8 | 19 | √ | null |
|
|
||
| toive_1 | int8 | 19 | √ | null |
|
|
||
| toive_2 | int8 | 19 | √ | null |
|
|
||
| toive_3 | int8 | 19 | √ | null |
|
|
||
| toive_4 | int8 | 19 | √ | null |
|
|
||
| toive_5 | int8 | 19 | √ | null |
|
|
||
| toive_6 | int8 | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| c8a21ac42b7bd655b4c31b883d61ea3c | Performance | Asc | hakukohde_oid |