fraver_skema


Columns

Column Type Size Nulls Auto Default Children Parents Comments
fravs_id int8 19 null
skemabeg_id int8 19 √ null
skemabegivenheder.skemabeg_id fravs_skemabeg_fk R
akpl_id int8 19 √ null
aktivitetsplaceringer.akpl_id fravs_akpl_fk R
fravk_id int8 19 √ null
fraverskoder.fravk_id fravs_fravk_fk R
minutter int2 5 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
bemerkning varchar 200 √ null
registreringstype varchar 1 √ null
registreret_af varchar 30 √ null

Indexes

Constraint Name Type Sort Column(s)
fravs_pk Primary key Asc fravs_id
fravs_akpl_id_idx Performance Asc akpl_id
fravs_akpl_indx Performance Asc akpl_id
fravs_fravk_fk_i Performance Asc fravk_id
fravs_fravs1_uk Must be unique Asc/Asc skemabeg_id + akpl_id
fravs_skemabeg_fk_i Performance Asc skemabeg_id

Check Constraints

Constraint Name Constraint
fraver_skema_check1 (('FRAVK_ID' IS NOT NULL))
fraver_skema_check3 (('MINUTTER' IS NOT NULL))
fraver_skema_registreringstype_check (((registreringstype)::text = ANY ((ARRAY['A'::character varying, 'L'::character varying, 'E'::character varying])::text[])))
fraver_skema_check4 (('OPDINIT' IS NOT NULL))
fraver_skema_check2 (('FRAVS_ID' IS NOT NULL))
fraver_skema_check6 (('OPDTID' IS NOT NULL))
fraver_skema_check5 (('OPDMOD' IS NOT NULL))
fraver_skema_check7 (('REGISTRERINGSTYPE' IS NOT NULL))
fraver_skema_check8 (('SKEMABEG_ID' IS NOT NULL))
fraver_skema_check (('AKPL_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation