grunddata_uvm_fag


Columns

Column Type Size Nulls Auto Default Children Parents Comments
guf_id int8 19 null
uvfa_id int8 19 √ null
uvm_fag.uvfa_id guf_uvfa_fk R
grda_id int8 19 √ null
grunddata.grda_id guf_grda_fk R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
guf_pk Primary key Asc guf_id
guf_grda_fk_i Performance Asc grda_id
guf_guf_uk Must be unique Asc/Asc grda_id + uvfa_id
guf_uvfa_fk_i Performance Asc uvfa_id

Check Constraints

Constraint Name Constraint
grunddata_uvm_fag_check2 (('OPDINIT' IS NOT NULL))
grunddata_uvm_fag_check1 (('GUF_ID' IS NOT NULL))
grunddata_uvm_fag_check4 (('OPDTID' IS NOT NULL))
grunddata_uvm_fag_check3 (('OPDMOD' IS NOT NULL))
grunddata_uvm_fag_check (('GRDA_ID' IS NOT NULL))
grunddata_uvm_fag_check5 (('UVFA_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation