revisionsspor_skolepraktik


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
eksamensresultater_ea.id Implied Constraint R
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))

Relationships

Close relationships within degrees of separation