personperspektiver


Columns

Column Type Size Nulls Auto Default Children Parents Comments
perspst_id int8 19 null
dato timestamp 22 √ null
pers_id int8 19 √ null
personer.pers_id perspst_pers_fk R
ceper_id int8 19 √ null
centrale_perspektiver.ceper_id perspst_ceper_fk R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
perspst_pk Primary key Asc perspst_id
perspst_ceper_fk_i Performance Asc ceper_id
perspst_uk Must be unique Asc pers_id

Check Constraints

Constraint Name Constraint
personperspektiver_check3 (('OPDMOD' IS NOT NULL))
personperspektiver_check4 (('OPDTID' IS NOT NULL))
personperspektiver_check (('CEPER_ID' IS NOT NULL))
personperspektiver_check5 (('PERSPST_ID' IS NOT NULL))
personperspektiver_check6 (('PERS_ID' IS NOT NULL))
personperspektiver_check1 (('DATO' IS NOT NULL))
personperspektiver_check2 (('OPDINIT' IS NOT NULL))

Relationships

Close relationships within degrees of separation