elevudlanfag


Columns

Column Type Size Nulls Auto Default Children Parents Comments
eludfg_id int8 19 null
exskf_id int8 19 null
eksterneskoleforlob.exskf_id eludfg_exskf_fk R
uvfa_id int8 19 null
uvm_fag.uvfa_id eludfg_uvfa_fk R
opdinit varchar 30 null
opdtid timestamp 22 null
opdmod varchar 4 null

Indexes

Constraint Name Type Sort Column(s)
eludfg_pk Primary key Asc eludfg_id
eludfg_eludfg1_uk Must be unique Asc/Asc exskf_id + uvfa_id
eludfg_exskf_fk_i Performance Asc exskf_id
eludfg_uvfa_fk_i Performance Asc uvfa_id

Check Constraints

Constraint Name Constraint
elevudlanfag_check2 (('OPDINIT' IS NOT NULL))
elevudlanfag_check (('ELUDFG_ID' IS NOT NULL))
elevudlanfag_check1 (('EXSKF_ID' IS NOT NULL))
elevudlanfag_check5 (('UVFA_ID' IS NOT NULL))
elevudlanfag_check4 (('OPDTID' IS NOT NULL))
elevudlanfag_check3 (('OPDMOD' IS NOT NULL))

Relationships