uvm_fag_konteringer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ufk_id int8 19 null
finansar varchar 4 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
uvfa_id int8 19 √ null
uvm_fag.uvfa_id ufk_uvfa_fk R
cofo_id int8 19 √ null
cosa_formal.cofo_id ufk_cofo_fk R

Indexes

Constraint Name Type Sort Column(s)
ufk_pk Primary key Asc ufk_id
ufk_cofo_fk_i Performance Asc cofo_id
ufk_ufk_uk Must be unique Asc/Asc finansar + uvfa_id
ufk_uvfa_fk_i Performance Asc uvfa_id

Check Constraints

Constraint Name Constraint
uvm_fag_konteringer_check1 (('OPDINIT' IS NOT NULL))
uvm_fag_konteringer_check2 (('OPDMOD' IS NOT NULL))
uvm_fag_konteringer_check3 (('OPDTID' IS NOT NULL))
uvm_fag_konteringer_check5 (('UVFA_ID' IS NOT NULL))
uvm_fag_konteringer_check4 (('UFK_ID' IS NOT NULL))
uvm_fag_konteringer_check (('FINANSAR' IS NOT NULL))

Relationships

Close relationships within degrees of separation