Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ansta_id | int8 | 19 | null |
|
|
||||||
| rekkefolge | int2 | 5 | √ | null |
|
|
|||||
| statuskode | varchar | 1 | √ | null |
|
|
|||||
| statustekst | varchar | 100 | √ | null |
|
|
|||||
| opdmod | varchar | 4 | √ | null |
|
|
|||||
| opdinit | varchar | 30 | √ | null |
|
|
|||||
| opdtid | timestamp | 22 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ansta_pk | Primary key | Asc | ansta_id |
| ansta_uk | Must be unique | Asc | statuskode |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| ansogerstatus_check1 | (('OPDINIT' IS NOT NULL)) |
| ansogerstatus_statuskode_check | (((statuskode)::text = ANY ((ARRAY['-'::character varying, 'A'::character varying, 'F'::character varying, 'I'::character varying, 'K'::character varying, 'M'::character varying, 'N'::character varying, 'O'::character varying, 'P'::character varying, 'S'::character varying, 'T'::character varying, 'U'::character varying, 'V'::character varying, 'X'::character varying, 'Y'::character varying, 'Z'::character varying])::text[]))) |
| ansogerstatus_check5 | (('STATUSKODE' IS NOT NULL)) |
| ansogerstatus_check6 | (('STATUSTEKST' IS NOT NULL)) |
| ansogerstatus_check2 | (('OPDMOD' IS NOT NULL)) |
| ansogerstatus_check3 | (('OPDTID' IS NOT NULL)) |
| ansogerstatus_check | (('ANSTA_ID' IS NOT NULL)) |
| ansogerstatus_check4 | (('REKKEFOLGE' IS NOT NULL)) |