specialer_til_specialer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
sts_id int8 19 null
spec_id_forste_speciale int8 19 √ null
specialer.spec_id sts_spec_forste_speciale_fk R
spec_id_andet_speciale int8 19 √ null
specialer.spec_id sts_spec_fk R
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
opdmod varchar 4 √ null

Indexes

Constraint Name Type Sort Column(s)
sts_pk Primary key Asc sts_id
sts_spec_fk_i Performance Asc spec_id_andet_speciale
sts_spec_forste_speciale_fk_i Performance Asc spec_id_forste_speciale
sts_uk Must be unique Asc/Asc spec_id_forste_speciale + spec_id_andet_speciale

Check Constraints

Constraint Name Constraint
specialer_til_specialer_check (('OPDMOD' IS NOT NULL))
specialer_til_specialer_check1 (('SPEC_ID_ANDET_SPECIALE' IS NOT NULL))
specialer_til_specialer_check2 (('SPEC_ID_FORSTE_SPECIALE' IS NOT NULL))
specialer_til_specialer_check3 (('STS_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation