Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| land_id | int8 | 19 | null |
|
|
||||||||||||||||||
| opdtid | timestamp | 22 | √ | null |
|
|
|||||||||||||||||
| opdinit | varchar | 30 | √ | null |
|
|
|||||||||||||||||
| landekode | varchar | 3 | √ | null |
|
|
|||||||||||||||||
| varchar | 50 | √ | null |
|
|
||||||||||||||||||
| nationalitet | varchar | 50 | √ | null |
|
|
|||||||||||||||||
| opdmod | varchar | 4 | √ | null |
|
|
|||||||||||||||||
| landegruppe | varchar | 2 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| land_pk | Primary key | Asc | land_id |
| land_land1_uk | Must be unique | Asc | landekode |
| lande_land_i | Performance | Asc | navn |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| lande_check3 | (('NAVN' IS NOT NULL)) |
| lande_check6 | (('OPDTID' IS NOT NULL)) |
| lande_landegruppe_check | (((landegruppe)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '3'::character varying, '4'::character varying, '5'::character varying, '6'::character varying, '7'::character varying, '8'::character varying])::text[]))) |
| lande_check1 | (('LANDEKODE' IS NOT NULL)) |
| lande_check | (('LANDEGRUPPE' IS NOT NULL)) |
| lande_check5 | (('OPDMOD' IS NOT NULL)) |
| lande_check2 | (('LAND_ID' IS NOT NULL)) |
| lande_check4 | (('OPDINIT' IS NOT NULL)) |