eksamensdelres_underfag_ea


Columns

Column Type Size Nulls Auto Default Children Parents Comments
edue_id int8 19 null
evalueringsform varchar 3 √ null
eksamensdelresultater_ea.evalueringsform edue_eksdelres_fk R
eksres_id int8 19 √ null
eksamensdelresultater_ea.eksres_id edue_eksdelres_fk R
karaktertype varchar 3 √ null
eksamensdelresultater_ea.karaktertype edue_eksdelres_fk R
niveau varchar 1 √ null
eksamensdelresultater_ea.niveau edue_eksdelres_fk R
skolefag varchar 5 √ null
eksamensdelresultater_ea.skolefag edue_eksdelres_fk R
uvmfag varchar 5 √ null
uvmfag_niveau varchar 1 √ null
uvmfag_betegnelse varchar 50 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
edue_pk_1 Primary key Asc edue_id
edue_edue_uk_uk Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc eksres_id + skolefag + niveau + karaktertype + evalueringsform + uvmfag + uvmfag_niveau
edue_eksdelres_fk_i Performance Asc/Asc/Asc/Asc/Asc eksres_id + skolefag + niveau + karaktertype + evalueringsform
edue_eksres_id_idx Performance Asc eksres_id

Check Constraints

Constraint Name Constraint
eksamensdelres_underfag_ea_check5 (('OPDINIT' IS NOT NULL))
eksamensdelres_underfag_ea_check2 (('EVALUERINGSFORM' IS NOT NULL))
eksamensdelres_underfag_ea_check10 (('UVMFAG_BETEGNELSE' IS NOT NULL))
eksamensdelres_underfag_ea_check4 (('NIVEAU' IS NOT NULL))
eksamensdelres_underfag_ea_check3 (('KARAKTERTYPE' IS NOT NULL))
eksamensdelres_underfag_ea_check11 (('UVMFAG_NIVEAU' IS NOT NULL))
eksamensdelres_underfag_ea_check (('EDUE_ID' IS NOT NULL))
eksamensdelres_underfag_ea_check7 (('OPDTID' IS NOT NULL))
eksamensdelres_underfag_ea_check8 (('SKOLEFAG' IS NOT NULL))
eksamensdelres_underfag_ea_check1 (('EKSRES_ID' IS NOT NULL))
eksamensdelres_underfag_ea_check6 (('OPDMOD' IS NOT NULL))
eksamensdelres_underfag_ea_check9 (('UVMFAG' IS NOT NULL))

Relationships

Close relationships within degrees of separation