regelgrundlag_fag


Columns

Column Type Size Nulls Auto Default Children Parents Comments
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
regfa_id int8 19 null
regr_id int8 19 √ null
regelgrundlag.regr_id regfa_regr_fk R
uvfa_id int8 19 √ null
uvm_fag.uvfa_id regfa_uvfa_fk R

Indexes

Constraint Name Type Sort Column(s)
regfa_pk Primary key Asc regfa_id
regfa_regr_fk_i Performance Asc regr_id
regfa_uk Must be unique Asc/Asc uvfa_id + regr_id
regfa_uvfa_fk_i Performance Asc uvfa_id

Check Constraints

Constraint Name Constraint
regelgrundlag_fag_check5 (('UVFA_ID' IS NOT NULL))
regelgrundlag_fag_check (('OPDINIT' IS NOT NULL))
regelgrundlag_fag_check3 (('REGFA_ID' IS NOT NULL))
regelgrundlag_fag_check4 (('REGR_ID' IS NOT NULL))
regelgrundlag_fag_check1 (('OPDMOD' IS NOT NULL))
regelgrundlag_fag_check2 (('OPDTID' IS NOT NULL))

Relationships

Close relationships within degrees of separation