elevflytningshistorik


Columns

Column Type Size Nulls Auto Default Children Parents Comments
efh_id int8 19 null
skol_id_fraskole int8 19 √ null
skoler.skol_id efh_fraskole_fk R
skol_id_tilskole int8 19 √ null
skoler.skol_id efh_tilskole_fk R
elev_id int8 19 √ null
elever.elev_id efh_elev_fk R
flyttedato timestamp 22 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
afgangsdato timestamp 22 √ null
ceaf_id int8 19 √ null
centrale_afgangsarsager.ceaf_id efh_ceaf_fk R

Indexes

Constraint Name Type Sort Column(s)
efh_pk Primary key Asc efh_id
efh_ceaf_fk_i Performance Asc ceaf_id
efh_efh_uk_uk Must be unique Asc/Asc/Asc/Asc elev_id + flyttedato + skol_id_fraskole + skol_id_tilskole
efh_elev_fk_i Performance Asc elev_id
efh_skol_fk_i Performance Asc skol_id_fraskole
tilskole_for_elevflytningsh__i Performance Asc skol_id_tilskole

Check Constraints

Constraint Name Constraint
elevflytningshistorik_check4 (('OPDMOD' IS NOT NULL))
elevflytningshistorik_check1 (('ELEV_ID' IS NOT NULL))
elevflytningshistorik_check2 (('FLYTTEDATO' IS NOT NULL))
elevflytningshistorik_check5 (('OPDTID' IS NOT NULL))
elevflytningshistorik_check (('EFH_ID' IS NOT NULL))
elevflytningshistorik_check6 (('SKOL_ID_TILSKOLE' IS NOT NULL))
elevflytningshistorik_check3 (('OPDINIT' IS NOT NULL))

Relationships

Close relationships within degrees of separation