Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| elre_id | int8 | 19 | null |
|
|
|||
| adgangsvej | varchar | 2 | √ | null |
|
|
||
| indmeldelsesdato | timestamp | 22 | √ | null |
|
|
||
| s_u | varchar | 1 | √ | null |
|
|
||
| befordring | varchar | 1 | √ | null |
|
|
||
| cosa_formal | varchar | 4 | √ | null |
|
|
||
| version | varchar | 4 | √ | null |
|
|
||
| afgangsarsag | varchar | 5 | √ | null |
|
|
||
| egnethed | varchar | 1 | √ | null |
|
|
||
| kvalifikationstekst | varchar | 200 | √ | null |
|
|
||
| afgangsdato | timestamp | 22 | √ | null |
|
|
||
| skolenr_kon | varchar | 4 | √ | null |
|
|
||
| skolenr_arr | varchar | 4 | √ | null |
|
|
||
| skolefag | varchar | 5 | √ | null |
|
|
||
| cpr_nr | varchar | 11 | √ | null |
|
|
||
| dod | varchar | 1 | √ | null |
|
|
||
| ae_rekvirent | varchar | 4 | √ | null |
|
|
||
| elevplan_elev | varchar | 1 | √ | null |
|
|
||
| opr_opdtid | timestamp | 22 | √ | null |
|
|
||
| opr_opdinit | varchar | 30 | √ | null |
|
|
||
| opr_opdmod | varchar | 4 | √ | null |
|
|
||
| elev_id | int8 | 19 | √ | null |
|
|
||
| operation | varchar | 1 | √ | null |
|
|
||
| afdeling | varchar | 4 | √ | null |
|
|
||
| opdmod | varchar | 4 | √ | null |
|
|
||
| opdinit | varchar | 30 | √ | null |
|
|
||
| opdtid | timestamp | 22 | √ | null |
|
|
||
| indskrivningsform | varchar | 4 | √ | null |
|
|
||
| gvu_fuldtidsuddannelse | varchar | 4 | √ | null |
|
|
||
| gvu_uddannelsesversion | varchar | 4 | √ | null |
|
|
||
| gvu_speciale | varchar | 2 | √ | null |
|
|
||
| grundforlobsbevis | varchar | 1 | √ | null |
|
|
||
| grundforlobsbevis_oprettet_af | varchar | 30 | √ | null |
|
|
||
| grundforlobsbevis_system | varchar | 1 | √ | null |
|
|
||
| grundforlobsbevis_dato | timestamp | 22 | √ | null |
|
|
||
| studiestart | timestamp | 22 | √ | null |
|
|
||
| studieretning | varchar | 50 | √ | null |
|
|
||
| studieretningsstartar | varchar | 4 | √ | null |
|
|
||
| perspektiv | varchar | 5 | √ | null |
|
|
||
| optages | varchar | 1 | √ | null |
|
|
||
| afgangsmeldes | varchar | 1 | √ | null |
|
|
||
| uddannelseskort | varchar | 1 | √ | null |
|
|
||
| uddannelsesvejleder | varchar | 4 | √ | null |
|
|
||
| b_regelnr | varchar | 5 | √ | null |
|
|
||
| u_regelnr | varchar | 5 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| elre_pk | Primary key | Asc | elre_id |
| elre_elev_id | Performance | Asc | elev_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| elev_revisionsspor_check2 | (('OPDINIT' IS NOT NULL)) |
| elev_revisionsspor_afgangsmeldes_check | (((afgangsmeldes)::text = ANY ((ARRAY['-'::character varying, 'J'::character varying, 'N'::character varying])::text[]))) |
| elev_revisionsspor_operation_check | (((operation)::text = ANY ((ARRAY['-'::character varying, 'D'::character varying, 'I'::character varying, 'U'::character varying])::text[]))) |
| elev_revisionsspor_check4 | (('OPDTID' IS NOT NULL)) |
| elev_revisionsspor_dod_check | (((dod)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| elev_revisionsspor_check1 | (('ELRE_ID' IS NOT NULL)) |
| elev_revisionsspor_optages_check | (((optages)::text = ANY ((ARRAY['-'::character varying, 'J'::character varying, 'N'::character varying])::text[]))) |
| elev_revisionsspor_uddannelseskort_check | (((uddannelseskort)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| elev_revisionsspor_check | (('ELEV_ID' IS NOT NULL)) |
| elev_revisionsspor_s_u_check | (((s_u)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| elev_revisionsspor_check3 | (('OPDMOD' IS NOT NULL)) |
| elev_revisionsspor_egnethed_check | (((egnethed)::text = ANY ((ARRAY['E'::character varying, 'I'::character varying, 'M'::character varying])::text[]))) |
| elev_revisionsspor_grundforlobsbevis_system_check | (((grundforlobsbevis_system)::text = ANY ((ARRAY['A'::character varying, 'E'::character varying])::text[]))) |
| elev_revisionsspor_check5 | (('OPERATION' IS NOT NULL)) |
| elev_revisionsspor_grundforlobsbevis_check | (((grundforlobsbevis)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| elev_revisionsspor_befordring_check | (((befordring)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| elev_revisionsspor_elevplan_elev_check | (((elevplan_elev)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |