skolefag_pa_iv_aktiviteter


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ski_id int8 19 null
akti_id int8 19 √ null
aktiviteter.akti_id ski_akti_fk R
skfa_id int8 19 √ null
skolefag.skfa_id ski_skfa_fk R
afregningsform varchar 1 √ null
akkord varchar 1 √ null
acsa_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
ski_pk Primary key Asc ski_id
ski_acsa_fk_i Performance Asc acsa_id
ski_akti_fk_i Performance Asc akti_id
ski_skfa_fk_i Performance Asc skfa_id
ski_ski1_uk Must be unique Asc/Asc akti_id + skfa_id

Check Constraints

Constraint Name Constraint
skolefag_pa_iv_aktiviteter_akkord_check (((akkord)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolefag_pa_iv_aktiviteter_check4 (('OPDMOD' IS NOT NULL))
skolefag_pa_iv_aktiviteter_afregningsform_check (((afregningsform)::text = ANY ((ARRAY['A'::character varying, 'L'::character varying])::text[])))
skolefag_pa_iv_aktiviteter_check7 (('SKI_ID' IS NOT NULL))
skolefag_pa_iv_aktiviteter_check1 (('AKKORD' IS NOT NULL))
skolefag_pa_iv_aktiviteter_check (('AFREGNINGSFORM' IS NOT NULL))
skolefag_pa_iv_aktiviteter_check5 (('OPDTID' IS NOT NULL))
skolefag_pa_iv_aktiviteter_check3 (('OPDINIT' IS NOT NULL))
skolefag_pa_iv_aktiviteter_check6 (('SKFA_ID' IS NOT NULL))
skolefag_pa_iv_aktiviteter_check2 (('AKTI_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation