centrale_perspektiver


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ceper_id int8 19 null
kbr_hendelseskoder.ceper_id khk_ceper_fk R
personperspektiver.ceper_id perspst_ceper_fk R
perspektiver.ceper_id pspek_ceper_fk R
opdtid timestamp 22 √ null
opdinit varchar 30 √ null
opdmod varchar 4 √ null
centralt_perspektiv varchar 5 √ null
kort_betegnelse varchar 15 √ null
betegnelse varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
ceper_pk_1 Primary key Asc ceper_id
ceper_ceper_uk Must be unique Asc centralt_perspektiv

Check Constraints

Constraint Name Constraint
centrale_perspektiver_check1 (('CENTRALT_PERSPEKTIV' IS NOT NULL))
centrale_perspektiver_check2 (('CEPER_ID' IS NOT NULL))
centrale_perspektiver_check3 (('KORT_BETEGNELSE' IS NOT NULL))
centrale_perspektiver_check6 (('OPDTID' IS NOT NULL))
centrale_perspektiver_check4 (('OPDINIT' IS NOT NULL))
centrale_perspektiver_check5 (('OPDMOD' IS NOT NULL))
centrale_perspektiver_check (('BETEGNELSE' IS NOT NULL))

Relationships

Close relationships within degrees of separation