studieretningsfag


Columns

Column Type Size Nulls Auto Default Children Parents Comments
sturf_id int8 19 null
studieretningshovedfag varchar 1 √ null
stur_id int8 19 √ null
studieretninger.stur_id sturf_stur_fk R
skfa_id int8 19 √ null
skolefag.skfa_id sturf_skfa_fk R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
sturf_pk Primary key Asc sturf_id
sturf_skfa_fk_i1 Performance Asc skfa_id
sturf_stur_fk_i Performance Asc stur_id
sturf_sturf_uk_uk Must be unique Asc/Asc stur_id + skfa_id

Check Constraints

Constraint Name Constraint
studieretningsfag_check4 (('STUDIERETNINGSHOVEDFAG' IS NOT NULL))
studieretningsfag_studieretningshovedfag_check (((studieretningshovedfag)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
studieretningsfag_check3 (('SKFA_ID' IS NOT NULL))
studieretningsfag_check2 (('OPDTID' IS NOT NULL))
studieretningsfag_check1 (('OPDMOD' IS NOT NULL))
studieretningsfag_check5 (('STURF_ID' IS NOT NULL))
studieretningsfag_check (('OPDINIT' IS NOT NULL))
studieretningsfag_check6 (('STUR_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation