karaktervardi


Columns

Column Type Size Nulls Auto Default Children Parents Comments
kvar_id int8 19 null
karakterer.kvar_id kara_kvar_fk R
karakterer.kvar_id_7trin kara_kvar_fk_7trin R
karakterer.kvar_id_ects kara_kvar_fk_ects R
kask_id int8 19 √ null
karakterskala.kask_id kvar_kask_fk R
karaktervardi varchar 2 √ null
betegnelse varchar 50 √ null
sekvens int2 5 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
bestaet varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
kvar_pk Primary key Asc kvar_id
kvar_kask_fk_i1 Performance Asc kask_id
kvar_kvar1_uk Must be unique Asc/Asc kask_id + karaktervardi

Check Constraints

Constraint Name Constraint
karaktervardi_check (('BESTAET' IS NOT NULL))
karaktervardi_check8 (('SEKVENS' IS NOT NULL))
karaktervardi_bestaet_check (((bestaet)::text = ANY ((ARRAY['A'::character varying, 'J'::character varying, 'N'::character varying])::text[])))
karaktervardi_check2 (('KARAKTERVARDI' IS NOT NULL))
karaktervardi_check3 (('KASK_ID' IS NOT NULL))
karaktervardi_check1 (('BETEGNELSE' IS NOT NULL))
karaktervardi_check5 (('OPDINIT' IS NOT NULL))
karaktervardi_check6 (('OPDMOD' IS NOT NULL))
karaktervardi_check7 (('OPDTID' IS NOT NULL))
karaktervardi_check4 (('KVAR_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation