specialer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
spec_id int8 19 null
aftaler.easy_p_spec_id easyp_spec R
aftaler.spec_id afta_spec_fk R
elever.gvu_speciale elev_spec_gvu_fk R
elevtyper_specialer.spec_id esp_spec_fk R
generelt_optag.spec_id gopta_spec_fk R
kvalifikationer_til_hovedforlo.spec_id kvho_spec_fk R
skoleperioder.spec_id skpe_spec_fk R
sosu_uddannelsesaftaler.spec_id sur_spec_fk R
specialer_til_specialer.spec_id_andet_speciale sts_spec_fk R
specialer_til_specialer.spec_id_forste_speciale sts_spec_forste_speciale_fk R
specialer_uvm_fag.spec_id spec_uvfa_spec_fk R
undervisningsforlob.spec_id1 unb_spec_fk R
undervisningsforlob.spec_id2 unb_spec_fk2 R
udda_id int8 19 √ null
uddannelser.udda_id spec_udda_fk R
speciale varchar 2 √ null
betegnelse varchar 50 √ null
kort_betegnelse varchar 15 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
delkompetence varchar 1 √ null
lukket_for_optag timestamp 22 √ null
dkll varchar 1 √ null
eqf varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
spec_pk Primary key Asc spec_id
spec_spec1_uk Must be unique Asc/Asc udda_id + speciale
spec_udda_fk_i Performance Asc udda_id
specialeidx1 Performance Asc speciale
specialer_i01 Performance Asc/Asc spec_id + speciale

Check Constraints

Constraint Name Constraint
specialer_check7 (('SPEC_ID' IS NOT NULL))
specialer_check (('BETEGNELSE' IS NOT NULL))
specialer_check4 (('OPDMOD' IS NOT NULL))
specialer_check6 (('SPECIALE' IS NOT NULL))
specialer_check5 (('OPDTID' IS NOT NULL))
specialer_check8 (('UDDA_ID' IS NOT NULL))
specialer_check3 (('OPDINIT' IS NOT NULL))
specialer_check1 (('DELKOMPETENCE' IS NOT NULL))
specialer_check2 (('KORT_BETEGNELSE' IS NOT NULL))
specialer_delkompetence_check (((delkompetence)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))

Relationships

Close relationships within degrees of separation