eksamensmark_pa_skhp


Columns

Column Type Size Nulls Auto Default Children Parents Comments
eksmskhp_id int8 19 null
skhp_id int8 19 √ null
skolefag_pa_holdplaceringer.skhp_id eksmskhp_skhp_fk R
evfo_id int8 19 √ null
evalueringsformer.evfo_id eksmskhp_evfo_fk R
visningsformat_mdr varchar 8 √ null
kalendermaneder.visningsformat_mdr eksmskhp_kamd_fk R
eksamen varchar 1 √ null
genereret varchar 1 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
opdmod varchar 4 √ null
prilishs_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
prilisss_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
prioritet int4 10 √ null
holdeksamen varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
eksmskhp_pk Primary key Asc eksmskhp_id
eksmskhp_eksmskhp1_uk Must be unique Asc/Asc/Asc skhp_id + evfo_id + visningsformat_mdr
eksmskhp_evfo_fk_i Performance Asc evfo_id
eksmskhp_kamd_fk_i Performance Asc visningsformat_mdr
eksmskhp_prilishs_fk_i Performance Asc prilishs_id
eksmskhp_prilisss_fk_i Performance Asc prilisss_id
eksmskhp_skhp_fk_i Performance Asc skhp_id
eksmsskhp_skhp_id_idx Performance Asc skhp_id

Check Constraints

Constraint Name Constraint
eksamensmark_pa_skhp_eksamen_check (((eksamen)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
eksamensmark_pa_skhp_genereret_check (((genereret)::text = ANY ((ARRAY['A'::character varying, 'B'::character varying, 'M'::character varying])::text[])))
eksamensmark_pa_skhp_check6 (('OPDMOD' IS NOT NULL))
eksamensmark_pa_skhp_check1 (('EKSMSKHP_ID' IS NOT NULL))
eksamensmark_pa_skhp_check5 (('OPDINIT' IS NOT NULL))
eksamensmark_pa_skhp_check4 (('HOLDEKSAMEN' IS NOT NULL))
eksamensmark_pa_skhp_check7 (('OPDTID' IS NOT NULL))
eksamensmark_pa_skhp_check2 (('EVFO_ID' IS NOT NULL))
eksamensmark_pa_skhp_check3 (('GENERERET' IS NOT NULL))
eksamensmark_pa_skhp_check (('EKSAMEN' IS NOT NULL))
eksamensmark_pa_skhp_check9 (('VISNINGSFORMAT_MDR' IS NOT NULL))
eksamensmark_pa_skhp_holdeksamen_check (((holdeksamen)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
eksamensmark_pa_skhp_check8 (('SKHP_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation