andre_karakterer_meritter


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ankame_id int8 19 null
projekttitler_for_karakterer.ankame_id pfr_ankame_fk R
pers_id int8 19 √ null
personer.pers_id ankame_pers_fk R
skol_id int8 19 √ null
skoler.skol_id ankame_skol_fk R
udda_id int8 19 √ null
uddannelser.udda_id ankame_udda_fk R
skolefag varchar 5 √ null
niveau varchar 1 √ null
undervisning varchar 1 √ null
eksamen varchar 1 √ null
fkm_type varchar 1 √ null
refo_id int8 19 √ null
resultatformer.refo_id ankame_refo_fk R
frit_id int8 19 √ null
fritagelser.frit_id ankame_frit_fk R
termin varchar 8 √ null
kalendermaneder.visningsformat_mdr ankame_kamd_fk R
bevistekst varchar 50 √ null
godskrivningstekst varchar 100 √ null
karakterverdi varchar 2 √ null
evaluering varchar 2000 √ null
fagtilknytning varchar 1 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
medteller_eksamen varchar 1 √ null
kar_verdi_7trin varchar 2 √ null
kar_verdi_ects varchar 2 √ null

Indexes

Constraint Name Type Sort Column(s)
ankame_pk Primary key Asc ankame_id
ankame_ankame_uk_uk Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc pers_id + skol_id + udda_id + skolefag + niveau + termin + refo_id
ankame_frit_fk_i Performance Asc frit_id
ankame_kamd_fk_i Performance Asc termin
ankame_pers_fk_i Performance Asc pers_id
ankame_pers_id_idx Performance Asc pers_id
ankame_refo_fk_i Performance Asc refo_id
ankame_skol_fk_i Performance Asc skol_id
ankame_udda_fk_i Performance Asc udda_id

Check Constraints

Constraint Name Constraint
andre_karakterer_meritter_check2 (('FKM_TYPE' IS NOT NULL))
andre_karakterer_meritter_check7 (('OPDTID' IS NOT NULL))
andre_karakterer_meritter_check6 (('OPDMOD' IS NOT NULL))
andre_karakterer_meritter_bevistekst_check (((bevistekst)::text = ANY ((ARRAY['Fritaget'::character varying, 'Godskrivning'::character varying, 'Merit uden karakteroverførsel'::character varying, 'Merit'::character varying])::text[])))
andre_karakterer_meritter_check8 (('PERS_ID' IS NOT NULL))
andre_karakterer_meritter_check9 (('SKOLEFAG' IS NOT NULL))
andre_karakterer_meritter_check1 (('EKSAMEN' IS NOT NULL))
andre_karakterer_meritter_check3 (('MEDTELLER_EKSAMEN' IS NOT NULL))
andre_karakterer_meritter_eksamen_check (((eksamen)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
andre_karakterer_meritter_check5 (('OPDINIT' IS NOT NULL))
andre_karakterer_meritter_medteller_eksamen_check (((medteller_eksamen)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
andre_karakterer_meritter_fkm_type_check (((fkm_type)::text = ANY ((ARRAY['F'::character varying, 'K'::character varying, 'M'::character varying])::text[])))
andre_karakterer_meritter_undervisning_check (((undervisning)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
andre_karakterer_meritter_check4 (('NIVEAU' IS NOT NULL))
andre_karakterer_meritter_check (('ANKAME_ID' IS NOT NULL))
andre_karakterer_meritter_check10 (('SKOL_ID' IS NOT NULL))
andre_karakterer_meritter_fagtilknytning_check (((fagtilknytning)::text = ANY ((ARRAY['E'::character varying, 'I'::character varying, 'L'::character varying, 'O'::character varying, 'P'::character varying, 'S'::character varying, 'T'::character varying, 'V'::character varying])::text[])))
andre_karakterer_meritter_check12 (('UNDERVISNING' IS NOT NULL))
andre_karakterer_meritter_check11 (('UDDA_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation