amu_konteringer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
amkon_id int8 19 null
amuku_id int8 19 √ null
amu_kursustyper.amuku_id amkon_amuku_fk R
finansar varchar 4 √ null
cofo_id int8 19 √ null
cosa_formal.cofo_id amkon_cofo_fk R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
amkon_pk Primary key Asc amkon_id
amkon_amkon_uk Must be unique Asc/Asc amuku_id + finansar
amkon_amuku_fk_i Performance Asc amuku_id
amkon_cofo_fk_i Performance Asc cofo_id

Check Constraints

Constraint Name Constraint
amu_konteringer_check5 (('OPDMOD' IS NOT NULL))
amu_konteringer_check3 (('FINANSAR' IS NOT NULL))
amu_konteringer_check1 (('AMUKU_ID' IS NOT NULL))
amu_konteringer_check2 (('COFO_ID' IS NOT NULL))
amu_konteringer_check4 (('OPDINIT' IS NOT NULL))
amu_konteringer_check6 (('OPDTID' IS NOT NULL))
amu_konteringer_check (('AMKON_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation