Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| koha_id | int8 | 19 | null |
|
|
||||||
| elev_id | int8 | 19 | √ | null |
|
|
|||||
| hendelses_dato | timestamp | 22 | √ | null |
|
|
|||||
| registrerings_dato | timestamp | 22 | √ | null |
|
|
|||||
| hendelseskode | varchar | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| koha_pk | Primary key | Asc | koha_id |
| koha_elev_fk_i | Performance | Asc | elev_id |
| koha_uk | Must be unique | Asc/Asc/Asc/Asc | hendelseskode + elev_id + hendelses_dato + registrerings_dato |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| kommunebrevs_haendelser_check3 | (('REGISTRERINGS_DATO' IS NOT NULL)) |
| kommunebrevs_haendelser_check | (('ELEV_ID' IS NOT NULL)) |
| kommunebrevs_haendelser_check2 | (('KOHA_ID' IS NOT NULL)) |
| kommunebrevs_haendelser_check1 | (('HENDELSESKODE' IS NOT NULL)) |