elevtyper_elevtyp_byggeklodser


Columns

Column Type Size Nulls Auto Default Children Parents Comments
eltyty_id int8 19 null
eltyby_id int8 19 √ null
elevtyper_byggeklodser.eltyby_id eeb_ebr_fk R
elty_id int8 19 √ null
elevtyper.elty_id eeb_elr_fk R
opdmod varchar 4 √ null
opdtid timestamp 22 √ null
opdinit varchar 30 √ null

Indexes

Constraint Name Type Sort Column(s)
eltyty_pk Primary key Asc eltyty_id
eeb_ebr_fk_i1 Performance Asc eltyby_id
eeb_elr_fk_i1 Performance Asc elty_id
eltyty_uk Must be unique Asc/Asc eltyby_id + elty_id

Check Constraints

Constraint Name Constraint
elevtyper_elevtyp_byggeklodser_check3 (('OPDINIT' IS NOT NULL))
elevtyper_elevtyp_byggeklodser_check2 (('ELTY_ID' IS NOT NULL))
elevtyper_elevtyp_byggeklodser_check1 (('ELTYTY_ID' IS NOT NULL))
elevtyper_elevtyp_byggeklodser_check5 (('OPDTID' IS NOT NULL))
elevtyper_elevtyp_byggeklodser_check4 (('OPDMOD' IS NOT NULL))
elevtyper_elevtyp_byggeklodser_check (('ELTYBY_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation