skolefag_pa_hold


Columns

Column Type Size Nulls Auto Default Children Parents Comments
skph_id int8 19 null
gebyrer_pr_rate.skph_id gbra_skph_fk R
projekttitler_for_skph.skph_id pskph_skph_fk R
skolefag_pa_hold_perioder.skph_id sphp_skph_fk R
skolefag_pa_hold_pladser.skph_id sphpl_skph_fk R
skolefag_pa_holdplaceringer.skph_id skhp_skph_fk R
tillagspriser_skolefag_pa_hold.skph_id skhp_id_fk1 R
akti_id int8 19 √ null
aktiviteter.akti_id skph_akti_fk R
skfa_id int8 19 √ null
skolefag.skfa_id skph_skfa_fk R
fagstatus varchar 1 √ null
skolefag_arves varchar 1 √ null
varighed_dage numeric 4,1 √ null
acsa_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
elevlektioner int2 5 √ null
lererlektioner numeric 5,1 √ null
antalopgaver numeric 5,2 √ null
vfm_eksamenstermin varchar 8 √ null
kalendermaneder.visningsformat_mdr skph_kamd_fk R
afregningsform varchar 1 √ null
akkord varchar 1 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
oprettet_i_elevplan varchar 1 √ null
fkb_id int8 19 √ null
uddannelser.udda_id skph_udd_fk R
godkendt_skole int8 19 √ null
skoler.skol_id skph_godk_fk R
gennemforende_skole int8 19 √ null
skoler.skol_id skph_genn_fk R
timer_pr_dag numeric 6,2 √ null
lms varchar 1 √ null
pladser varchar 4 √ null
justeret_pris numeric 10,2 √ null
parameterliste varchar 1 √ null
anfo_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
eksaminationssprog varchar 2 √ null
tillegspris numeric 10,2 √ null
tillegspris_arsag varchar 200 √ null
primert_fag varchar 1 √ null
fuld_justeret_pris numeric 10,2 √ null
udlic_lrst_id int8 19 √ null
leresteder.lrst_id skph_udlic_lrst_fk R

Indexes

Constraint Name Type Sort Column(s)
skph_pk Primary key Asc skph_id
skph_acsa_fk_1 Performance Asc acsa_id
skph_akti_fk_i1 Performance Asc akti_id
skph_anfo_fk_i1 Performance Asc anfo_id
skph_fkb_fk_i Performance Asc fkb_id
skph_genn_fk_1 Performance Asc gennemforende_skole
skph_godk_fk_1 Performance Asc godkendt_skole
skph_kamd_fk_1 Performance Asc vfm_eksamenstermin
skph_skfa_fk_1 Performance Asc skfa_id
skph_skfa_id_idx Performance Asc skfa_id
skph_skph1_uk Must be unique Asc/Asc akti_id + skfa_id
skph_udlic_lrst_fk_i Performance Asc udlic_lrst_id

Check Constraints

Constraint Name Constraint
skolefag_pa_hold_check5 (('OPDINIT' IS NOT NULL))
skolefag_pa_hold_check7 (('OPDTID' IS NOT NULL))
skolefag_pa_hold_fagstatus_check (((fagstatus)::text = ANY ((ARRAY['E'::character varying, 'I'::character varying, 'L'::character varying, 'O'::character varying, 'P'::character varying, 'S'::character varying, 'T'::character varying, 'V'::character varying])::text[])))
skolefag_pa_hold_skolefag_arves_check (((skolefag_arves)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolefag_pa_hold_check2 (('AKTI_ID' IS NOT NULL))
skolefag_pa_hold_afregningsform_check (((afregningsform)::text = ANY ((ARRAY['A'::character varying, 'L'::character varying])::text[])))
skolefag_pa_hold_check8 (('OPRETTET_I_ELEVPLAN' IS NOT NULL))
skolefag_pa_hold_check14 (('VARIGHED_DAGE' IS NOT NULL))
skolefag_pa_hold_check9 (('PARAMETERLISTE' IS NOT NULL))
skolefag_pa_hold_check12 (('SKOLEFAG_ARVES' IS NOT NULL))
skolefag_pa_hold_primert_fag_check (((primert_fag)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolefag_pa_hold_lms_check (((lms)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolefag_pa_hold_check3 (('FAGSTATUS' IS NOT NULL))
skolefag_pa_hold_check6 (('OPDMOD' IS NOT NULL))
skolefag_pa_hold_check11 (('SKFA_ID' IS NOT NULL))
skolefag_pa_hold_check1 (('AKKORD' IS NOT NULL))
skolefag_pa_hold_check10 (('PRIMERT_FAG' IS NOT NULL))
skolefag_pa_hold_oprettet_i_elevplan_check (((oprettet_i_elevplan)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolefag_pa_hold_check4 (('LMS' IS NOT NULL))
skolefag_pa_hold_parameterliste_check (((parameterliste)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolefag_pa_hold_check (('AFREGNINGSFORM' IS NOT NULL))
skolefag_pa_hold_akkord_check (((akkord)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skolefag_pa_hold_check13 (('SKPH_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation