Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| eh_id | int8 | 19 | null |
|
|
||||||
| bevis_id | varchar | 27 | √ | null |
|
|
|||||
| bevis_operation | varchar | 1 | √ | null |
|
|
|||||
| opr_init | varchar | 30 | √ | null |
|
|
|||||
| opr_tid | timestamp | 22 | √ | null |
|
|
|||||
| status | varchar | 17 | √ | null |
|
|
|||||
| sendes | varchar | 1 | √ | null |
|
|
|||||
| cprnummer | varchar | 11 | √ | null |
|
|
|||||
| cosa_formal | varchar | 4 | √ | null |
|
|
|||||
| version | varchar | 4 | √ | null |
|
|
|||||
| batch_id | int8 | 19 | √ | null |
|
|
|||||
| skol_id | int8 | 19 | √ | null |
|
|
|||||
| opdmod | varchar | 4 | √ | null |
|
|
|||||
| opdinit | varchar | 30 | √ | null |
|
|
|||||
| opdtid | timestamp | 22 | √ | null |
|
|
|||||
| bevisindhold | text | 2147483647 | √ | null |
|
|
|||||
| bevis_type | varchar | 3 | √ | null |
|
|
|||||
| indberetningsid | varchar | 50 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| eh_pk | Primary key | Asc | eh_id |
| eh_cosa_formal_idx | Performance | Asc | cosa_formal |
| eh_cprnummer_idx | Performance | Asc | cprnummer |
| eh_eksdbhaend_uk | Must be unique | Asc/Asc/Asc | bevis_id + bevis_operation + opr_tid |
| eh_skol_fk_i | Performance | Asc | skol_id |
| eh_x2_idx | Performance | Asc/Asc | cprnummer + cosa_formal |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| eksamensdb_haendelser_check7 | (('OPDMOD' IS NOT NULL)) |
| eksamensdb_haendelser_check10 | (('OPR_TID' IS NOT NULL)) |
| eksamensdb_haendelser_check3 | (('COSA_FORMAL' IS NOT NULL)) |
| eksamensdb_haendelser_sendes_check | (((sendes)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| eksamensdb_haendelser_bevis_type_check | (((bevis_type)::text = ANY ((ARRAY['Eks'::character varying, 'Fag'::character varying])::text[]))) |
| eksamensdb_haendelser_check4 | (('CPRNUMMER' IS NOT NULL)) |
| eksamensdb_haendelser_check8 | (('OPDTID' IS NOT NULL)) |
| eksamensdb_haendelser_bevis_operation_check | (((bevis_operation)::text = ANY ((ARRAY['O'::character varying, 'S'::character varying])::text[]))) |
| eksamensdb_haendelser_check11 | (('SENDES' IS NOT NULL)) |
| eksamensdb_haendelser_check1 | (('BEVIS_OPERATION' IS NOT NULL)) |
| eksamensdb_haendelser_check12 | (('STATUS' IS NOT NULL)) |
| eksamensdb_haendelser_check | (('BEVIS_ID' IS NOT NULL)) |
| eksamensdb_haendelser_check2 | (('BEVIS_TYPE' IS NOT NULL)) |
| eksamensdb_haendelser_status_check | (((status)::text = ANY ((ARRAY['FEJL-DATA'::character varying, 'FEJL-TEKNIK'::character varying, 'OK'::character varying, 'OPRETTET'::character varying, 'PÅ CENTRAL SERVER'::character varying, 'PÅ EASY-F'::character varying, 'PÅ EKSAMENSDB'::character varying])::text[]))) |
| eksamensdb_haendelser_check13 | (('VERSION' IS NOT NULL)) |
| eksamensdb_haendelser_check6 | (('OPDINIT' IS NOT NULL)) |
| eksamensdb_haendelser_check9 | (('OPR_INIT' IS NOT NULL)) |
| eksamensdb_haendelser_check5 | (('EH_ID' IS NOT NULL)) |