Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | null |
|
|
||||||
| version | int8 | 19 | null |
|
|
||||||
| osoiterivi1 | varchar | 255 | √ | null |
|
|
|||||
| osoiterivi2 | varchar | 255 | √ | null |
|
|
|||||
| postinumero | varchar | 255 | √ | null |
|
|
|||||
| postitoimipaikka | varchar | 255 | √ | null |
|
|
|||||
| alkamisaika | timestamp | 29,6 | null |
|
|
||||||
| lisatietoja | varchar | 255 | √ | null |
|
|
|||||
| paattymisaika | timestamp | 29,6 | null |
|
|
||||||
| valintakoe_id | int8 | 19 | null |
|
|
||||||
| kellonaika_kaytossa | bool | 1 | true |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| valintakoe_ajankohta_pkey | Primary key | Asc | id |
| valintakoe_ajankohta_valintakoe_id | Performance | Asc | valintakoe_id |
Relationships
Close relationships within degrees of separation
