Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ekmarevi_id | int8 | 19 | null |
|
|
||||||
| eksamenstermin | timestamp | 22 | √ | null |
|
|
|||||
| cpr_nr | varchar | 11 | √ | null |
|
|
|||||
| aktivitet | varchar | 12 | √ | null |
|
|
|||||
| startdato | timestamp | 22 | √ | null |
|
|
|||||
| niveau | varchar | 1 | √ | null |
|
|
|||||
| skolefag | varchar | 5 | √ | null |
|
|
|||||
| genereret | varchar | 1 | √ | null |
|
|
|||||
| evalueringsform | varchar | 3 | √ | null |
|
|
|||||
| opropdtid | timestamp | 22 | √ | null |
|
|
|||||
| opropdinit | varchar | 30 | √ | null |
|
|
|||||
| eksamen | varchar | 1 | √ | null |
|
|
|||||
| opdinit | varchar | 30 | √ | null |
|
|
|||||
| opdtid | timestamp | 22 | √ | null |
|
|
|||||
| opdmod | varchar | 4 | √ | null |
|
|
|||||
| eksmskhp_id | int8 | 19 | √ | null |
|
|
|||||
| operation | varchar | 1 | √ | null |
|
|
|||||
| prioliste | varchar | 5 | √ | null |
|
|
|||||
| fradato | timestamp | 22 | √ | null |
|
|
|||||
| version | varchar | 4 | √ | null |
|
|
|||||
| uddannelse | varchar | 4 | √ | null |
|
|
|||||
| visningsformat_mdr | varchar | 8 | √ | null |
|
|
|||||
| opropdmod | varchar | 4 | √ | null |
|
|
|||||
| prioritet | int4 | 10 | √ | null |
|
|
|||||
| holdeksamen | varchar | 1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ekmarevi_pk | Primary key | Asc | ekmarevi_id |
| ekmarevi_cpr_nr_idx | Performance | Asc | cpr_nr |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| eksamensmark_revspor_check4 | (('EKSAMENSTERMIN' IS NOT NULL)) |
| eksamensmark_revspor_eksamen_check | (((eksamen)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| eksamensmark_revspor_check12 | (('OPERATION' IS NOT NULL)) |
| eksamensmark_revspor_check10 | (('OPDMOD' IS NOT NULL)) |
| eksamensmark_revspor_check2 | (('EKMAREVI_ID' IS NOT NULL)) |
| eksamensmark_revspor_check7 | (('HOLDEKSAMEN' IS NOT NULL)) |
| eksamensmark_revspor_check9 | (('OPDINIT' IS NOT NULL)) |
| eksamensmark_revspor_operation_check | (((operation)::text = ANY ((ARRAY['-'::character varying, 'D'::character varying, 'I'::character varying, 'U'::character varying])::text[]))) |
| eksamensmark_revspor_check6 | (('GENERERET' IS NOT NULL)) |
| eksamensmark_revspor_genereret_check | (((genereret)::text = ANY ((ARRAY['M'::character varying, 'A'::character varying, 'B'::character varying])::text[]))) |
| eksamensmark_revspor_check14 | (('OPROPDTID' IS NOT NULL)) |
| eksamensmark_revspor_check16 | (('STARTDATO' IS NOT NULL)) |
| eksamensmark_revspor_check8 | (('NIVEAU' IS NOT NULL)) |
| eksamensmark_revspor_check11 | (('OPDTID' IS NOT NULL)) |
| eksamensmark_revspor_holdeksamen_check | (((holdeksamen)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| eksamensmark_revspor_check15 | (('SKOLEFAG' IS NOT NULL)) |
| eksamensmark_revspor_check | (('AKTIVITET' IS NOT NULL)) |
| eksamensmark_revspor_check13 | (('OPROPDINIT' IS NOT NULL)) |
| eksamensmark_revspor_check3 | (('EKSAMEN' IS NOT NULL)) |
| eksamensmark_revspor_check5 | (('EVALUERINGSFORM' IS NOT NULL)) |
| eksamensmark_revspor_check1 | (('CPR_NR' IS NOT NULL)) |