aktivitetsplaceringer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
akpl_id int8 19 null
bookinger.akpl_id book_akpl_fk R
fraver_skema.akpl_id fravs_akpl_fk R
fraver_uger.akpl_id fu_akpl_fk R
fraversprotokollinier.akpl_id frvpl_akpl_fk R
pers_id int8 19 √ null
personer.pers_id akpl_pers_fk R
akti_id int8 19 √ null
aktiviteter.akti_id akpl_akti_fk R
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
logi varchar 1 √ null
hopl_id int8 19 √ null
holdplaceringer.hopl_id akpl_hopl_fk R
ivku_id int8 19 √ null
iv_kursister.ivku_id akpl_ivku_fk R
kupl_id int8 19 √ null
kursusplaceringer.kupl_id akpl_kupl_fk R
a260book_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
periode_endret varchar 1 √ null
ovpl_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
akpl_pk Primary key Asc akpl_id
akpl_akpl1_uk Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc pers_id + akti_id + startdato + hopl_id + ivku_id + kupl_id + ovpl_id
akpl_akti_fk_i Performance Asc akti_id
akpl_hopl_fk_i Performance Asc hopl_id
akpl_hopl_id_idx Performance Asc hopl_id
akpl_ivku_fk_i Performance Asc ivku_id
akpl_kupl_fk_i1 Performance Asc kupl_id
akpl_kupl_id_idx Performance Asc kupl_id
akpl_ovpl2_fk_i Performance Asc ovpl_id
akpl_pers_fk_i Performance Asc pers_id

Check Constraints

Constraint Name Constraint
aktivitetsplaceringer_check2 (('LOGI' IS NOT NULL))
aktivitetsplaceringer_check7 (('PERS_ID' IS NOT NULL))
aktivitetsplaceringer_check6 (('PERIODE_ENDRET' IS NOT NULL))
aktivitetsplaceringer_check (('AKPL_ID' IS NOT NULL))
aktivitetsplaceringer_check3 (('OPDINIT' IS NOT NULL))
aktivitetsplaceringer_check1 (('AKTI_ID' IS NOT NULL))
aktivitetsplaceringer_check5 (('OPDTID' IS NOT NULL))
aktivitetsplaceringer_check9 (('STARTDATO' IS NOT NULL))
aktivitetsplaceringer_check8 (('SLUTDATO' IS NOT NULL))
aktivitetsplaceringer_periode_endret_check (((periode_endret)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
aktivitetsplaceringer_check4 (('OPDMOD' IS NOT NULL))
aktivitetsplaceringer_logi_check (((logi)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))

Relationships

Close relationships within degrees of separation