skoleperioder


Columns

Column Type Size Nulls Auto Default Children Parents Comments
skpe_id int8 19 null
eksterneskoleforlob.skpe_id exskf_skpe_fk R
elev_i_skolepraktik.skpe_id eisp_skpe_fk R
elevtyper_skolerperioder.skpe_id esr_skpe_fk R
gyldige_tmk_pa_skoleperiode.skpe_id gtms_skpe_fk R
skoleforlob.skpe_id skof_skpe_fk R
telleperioder.skpe_id tape_skpe_fk R
udda_id int8 19 √ null
uddannelser.udda_id skpe_udda_fk R
skoleperiode varchar 4 √ null
navn varchar 3 √ null
spec_id int8 19 √ null
specialer.spec_id skpe_spec_fk R
min_eksaminer int2 5 √ null
max_eksaminer int2 5 √ null
beregningsform varchar 1 √ null
praktikvarighed int2 5 √ null
afgangsperiode varchar 1 √ null
gebyrbetaling varchar 1 √ null
forlob varchar 1 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
sortering int2 5 √ null
pety_id int8 19 √ null
periodetyper.pety_id skpe_pety_fk R
forskellige_fag varchar 1 √ null
mundtlig_skriftlig varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
skpe_pk Primary key Asc skpe_id
skpe_pety_fk_i Performance Asc pety_id
skpe_skpe1_uk Must be unique Asc/Asc/Asc udda_id + skoleperiode + spec_id
skpe_spec_fk_i Performance Asc spec_id
skpe_udda_fk_i Performance Asc udda_id

Check Constraints

Constraint Name Constraint
skoleperioder_check (('AFGANGSPERIODE' IS NOT NULL))
skoleperioder_check10 (('UDDA_ID' IS NOT NULL))
skoleperioder_gebyrbetaling_check (((gebyrbetaling)::text = ANY ((ARRAY['B'::character varying, 'F'::character varying])::text[])))
skoleperioder_min_eksaminer_check (((min_eksaminer IS NULL) OR (min_eksaminer >= 0)))
skoleperioder_beregningsform_check (((beregningsform)::text = ANY ((ARRAY['A'::character varying, 'B'::character varying])::text[])))
skoleperioder_afgangsperiode_check (((afgangsperiode)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skoleperioder_forlob_check (((forlob)::text = ANY ((ARRAY['I'::character varying, 'H'::character varying])::text[])))
skoleperioder_check1 (('BEREGNINGSFORM' IS NOT NULL))
skoleperioder_check2 (('GEBYRBETALING' IS NOT NULL))
skoleperioder_check8 (('SKOLEPERIODE' IS NOT NULL))
skoleperioder_check4 (('OPDINIT' IS NOT NULL))
skoleperioder_check6 (('OPDTID' IS NOT NULL))
skoleperioder_max_eksaminer_check (((max_eksaminer IS NULL) OR (max_eksaminer >= 0)))
skoleperioder_mundtlig_skriftlig_check (((mundtlig_skriftlig)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skoleperioder_check3 (('NAVN' IS NOT NULL))
skoleperioder_check5 (('OPDMOD' IS NOT NULL))
skoleperioder_forskellige_fag_check (((forskellige_fag)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
skoleperioder_check7 (('PETY_ID' IS NOT NULL))
skoleperioder_check9 (('SKPE_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation