Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | null |
|
|
||||||
| version | int8 | 19 | null |
|
|
||||||
| eisisallamerkitysta | varchar | 2048 | √ | null |
|
|
|||||
| huomioitavakoodi | varchar | 256 | √ | null |
|
|
|||||
| kasite | varchar | 256 | √ | null |
|
|
|||||
| kayttoohje | varchar | 2048 | √ | null |
|
|
|||||
| kieli | varchar | 256 | null |
|
|
||||||
| kuvaus | varchar | 2048 | √ | null |
|
|
|||||
| lyhytnimi | varchar | 256 | √ | null |
|
|
|||||
| nimi | varchar | 512 | null |
|
|
||||||
| sisaltaakoodiston | varchar | 2048 | √ | null |
|
|
|||||
| sisaltaamerkityksen | varchar | 2048 | √ | null |
|
|
|||||
| koodiversio_id | int8 | 19 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| koodimetadata_pkey | Primary key | Asc | id |
| koodimetadata_kieli_key | Must be unique | Asc/Asc | kieli + koodiversio_id |
| koodimetadata_koodiversio_id_idx | Performance | Asc | koodiversio_id |
Relationships
Close relationships within degrees of separation
