Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| rev_eisp_id | int8 | 19 | null |
|
|
||||||
| startdato | timestamp | 22 | √ | null |
|
|
|||||
| slutdato | timestamp | 22 | √ | null |
|
|
|||||
| opropdmod | varchar | 4 | √ | null |
|
|
|||||
| opropdtid | timestamp | 22 | √ | null |
|
|
|||||
| opropdinit | varchar | 30 | √ | null |
|
|
|||||
| pers_cpr_nummer | varchar | 11 | √ | null |
|
|
|||||
| elev_uddannelse | varchar | 4 | √ | null |
|
|
|||||
| elev_version | varchar | 4 | √ | null |
|
|
|||||
| elev_ae_rekvirent | varchar | 4 | √ | null |
|
|
|||||
| afta_afta_type | varchar | 5 | √ | null |
|
|
|||||
| afta_central_lokal | varchar | 1 | √ | null |
|
|
|||||
| afta_startdato | timestamp | 22 | √ | null |
|
|
|||||
| afta_slutdato | timestamp | 22 | √ | null |
|
|
|||||
| skka_skoledagskalender | varchar | 8 | √ | null |
|
|
|||||
| skka_startdato | timestamp | 22 | √ | null |
|
|
|||||
| skka_slutdato | timestamp | 22 | √ | null |
|
|
|||||
| skpe_uddannelse | varchar | 4 | √ | null |
|
|
|||||
| skpe_version | varchar | 4 | √ | null |
|
|
|||||
| skpe_skoleperiode | varchar | 4 | √ | null |
|
|
|||||
| aere_ae_rekvirent | varchar | 4 | √ | null |
|
|
|||||
| eisp_id | int8 | 19 | √ | null |
|
|
|||||
| afta_id | int8 | 19 | √ | null |
|
|
|||||
| skpe_id | int8 | 19 | √ | null |
|
|
|||||
| elev_id | int8 | 19 | √ | null |
|
|
|||||
| skka_id | int8 | 19 | √ | null |
|
|
|||||
| tmk_id | int8 | 19 | √ | null |
|
|
|||||
| aere_id | int8 | 19 | √ | null |
|
|
|||||
| holdi_id | int8 | 19 | √ | null |
|
|
|||||
| pers_id | int8 | 19 | √ | null |
|
|
|||||
| afta_afttyp_obl | varchar | 4 | √ | null |
|
|
|||||
| tmk_kombination | varchar | 5 | √ | null |
|
|
|||||
| stmk_kombination | varchar | 5 | √ | null |
|
|
|||||
| skpe_speciale | varchar | 2 | √ | null |
|
|
|||||
| holdi_holdident | varchar | 8 | √ | null |
|
|
|||||
| holdi_startdato | timestamp | 22 | √ | null |
|
|
|||||
| holdi_slutdato | timestamp | 22 | √ | null |
|
|
|||||
| stmk_id | int8 | 19 | √ | null |
|
|
|||||
| operation | varchar | 1 | √ | null |
|
|
|||||
| opdmod | varchar | 4 | √ | null |
|
|
|||||
| opdinit | varchar | 30 | √ | null |
|
|
|||||
| opdtid | timestamp | 22 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| rev_eisp_pk | Primary key | Asc | rev_eisp_id |
| rev_eisp_id_elev_id_idx | Performance | Asc | elev_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| revisionsspor_skolepraktik_afta_afta_type_check | (((afta_afta_type)::text = ANY ((ARRAY['AFPV'::character varying, 'LAND'::character varying, 'PIU'::character varying, 'SKPS'::character varying])::text[]))) |
| revisionsspor_skolepraktik_check | (('OPDINIT' IS NOT NULL)) |
| revisionsspor_skolepraktik_check3 | (('OPERATION' IS NOT NULL)) |
| revisionsspor_skolepraktik_check2 | (('OPDTID' IS NOT NULL)) |
| revisionsspor_skolepraktik_afta_central_lokal_check | (((afta_central_lokal)::text = ANY ((ARRAY['C'::character varying, 'L'::character varying, 'S'::character varying])::text[]))) |
| revisionsspor_skolepraktik_check1 | (('OPDMOD' IS NOT NULL)) |
| revisionsspor_skolepraktik_operation_check | (((operation)::text = ANY ((ARRAY['-'::character varying, 'D'::character varying, 'I'::character varying, 'U'::character varying])::text[]))) |
| revisionsspor_skolepraktik_check4 | (('REV_EISP_ID' IS NOT NULL)) |