amu_kursister


Columns

Column Type Size Nulls Auto Default Children Parents Comments
amkr_id int8 19 null
amu_holdidenter.amkr_id amho_amkr_fk R
kursusplaceringer.amkr_id kupl_amkr_fk R
noter.amkr_id note_amkr_fk R
pers_id int8 19 √ null
personer.pers_id amkr_pers_fk R
cofo_id int8 19 √ null
cosa_formal.cofo_id amkr_cofo_fk R
indmeldt timestamp 22 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
opbevar_til date 13 √ null
opbevar_aub_til date 13 √ null
opbevar_kar_til date 13 √ null
opbevar_oko_til date 13 √ null
opbevar_su_til date 13 √ null

Indexes

Constraint Name Type Sort Column(s)
amkr_pk Primary key Asc amkr_id
amkr_cofo_fk_i Performance Asc cofo_id
amkr_pers_fk_i Performance Asc pers_id

Check Constraints

Constraint Name Constraint
amu_kursister_check2 (('INDMELDT' IS NOT NULL))
amu_kursister_check4 (('OPDMOD' IS NOT NULL))
amu_kursister_check5 (('OPDTID' IS NOT NULL))
amu_kursister_check (('AMKR_ID' IS NOT NULL))
amu_kursister_check6 (('PERS_ID' IS NOT NULL))
amu_kursister_check1 (('COFO_ID' IS NOT NULL))
amu_kursister_check3 (('OPDINIT' IS NOT NULL))

Relationships

Close relationships within degrees of separation