Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| lovl_id | int8 | 19 | null |
|
|
|||
| fra_cosa_formal | varchar | 4 | √ | null |
|
|
||
| fra_version | varchar | 4 | √ | null |
|
|
||
| fra_udda_type | varchar | 3 | √ | null |
|
|
||
| til_cosa_formal | varchar | 4 | √ | null |
|
|
||
| til_version | varchar | 4 | √ | null |
|
|
||
| til_udda_type | varchar | 3 | √ | null |
|
|
||
| gyldig_fra | timestamp | 22 | √ | null |
|
|
||
| gyldig_til | timestamp | 22 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| lovl_id_pk | Primary key | Asc | lovl_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| lovlige_skift_check6 | (('TIL_UDDA_TYPE' IS NOT NULL)) |
| lovlige_skift_check | (('FRA_COSA_FORMAL' IS NOT NULL)) |
| lovlige_skift_check4 | (('LOVL_ID' IS NOT NULL)) |
| lovlige_skift_check5 | (('TIL_COSA_FORMAL' IS NOT NULL)) |
| lovlige_skift_check7 | (('TIL_VERSION' IS NOT NULL)) |
| lovlige_skift_check2 | (('FRA_VERSION' IS NOT NULL)) |
| lovlige_skift_check1 | (('FRA_UDDA_TYPE' IS NOT NULL)) |
| lovlige_skift_check3 | (('GYLDIG_FRA' IS NOT NULL)) |