undervisningsforlob


Columns

Column Type Size Nulls Auto Default Children Parents Comments
uvfo_id int8 19 null
aktiviteter.uvfo_id akti_uvfo_fk R
elevplan_identifikation varchar 38 √ null
oprettet_i_elevplan varchar 1 √ null
spec_id2 int8 19 √ null
specialer.spec_id unb_spec_fk2 R
udda_id2 int8 19 √ null
uddannelser.udda_id unb_udda_fk2 R
spec_id1 int8 19 √ null
specialer.spec_id unb_spec_fk R
udda_id1 int8 19 √ null
uddannelser.udda_id unb_udda_fk R
slutdato timestamp 22 √ null
startdato timestamp 22 √ null
titel varchar 100 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
uvfo_pk Primary key Asc uvfo_id
unb_spec_fk2_i Performance Asc spec_id2
unb_spec_fk_i Performance Asc spec_id1
unb_udda_fk2_i Performance Asc udda_id2
unb_udda_fk_i Performance Asc udda_id1
uvfo_uk Must be unique Asc/Asc titel + startdato
uvfo_uk2_i Performance Asc elevplan_identifikation

Check Constraints

Constraint Name Constraint
undervisningsforlob_check5 (('STARTDATO' IS NOT NULL))
undervisningsforlob_check (('OPDINIT' IS NOT NULL))
undervisningsforlob_check6 (('TITEL' IS NOT NULL))
undervisningsforlob_check7 (('UVFO_ID' IS NOT NULL))
undervisningsforlob_check2 (('OPDTID' IS NOT NULL))
undervisningsforlob_check3 (('OPRETTET_I_ELEVPLAN' IS NOT NULL))
undervisningsforlob_check4 (('SLUTDATO' IS NOT NULL))
undervisningsforlob_check1 (('OPDMOD' IS NOT NULL))
undervisningsforlob_oprettet_i_elevplan_check (((oprettet_i_elevplan)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))

Relationships

Close relationships within degrees of separation