aftaler


Columns

Column Type Size Nulls Auto Default Children Parents Comments
afta_type varchar 5 √ null
skol_id int8 19 √ null
skoler.skol_id afta_skol_fk R
elev_id int8 19 √ null
elever.elev_id afta_elev_fk R
afta_id int8 19 null
elev_i_skolepraktik.afta_id eisp_afta_fk R
pauser.afta_id pause_afta_fk R
aftaleid int8 19 √ null
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
central_lokal varchar 1 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
spec_id int8 19 √ null
specialer.spec_id afta_spec_fk R
lrst_id int8 19 √ null
leresteder.lrst_id afta_lrst_fk R
land_id int8 19 √ null
lande.land_id afta_land_fk R
skol_id_skolepraktik_pa_denne_ int8 19 √ null
skoler.skol_id afta_skol_skolepraktik_pa_denn R
kommentar varchar 200 √ null
status varchar 1 √ null
merittekst varchar 200 √ null
formodet_passivdato timestamp 22 √ null
godkendt_aer varchar 1 √ null
godkendelsesdato timestamp 22 √ null
afttyp_obl varchar 4 √ null
skolepraktik varchar 1 √ null
afttyp_supl1 varchar 4 √ null
afttyp_supl2 varchar 4 √ null
afttyp_supl3 varchar 4 √ null
easy_p_spec_id int8 19 √ null
specialer.spec_id easyp_spec R
easy_p_version varchar 4 √ null
easy_p_aftalestart timestamp 22 √ null
easy_p_aftaleslut timestamp 22 √ null
aer_indberet varchar 1 √ null
afslutningsarsag varchar 4 √ null
afslutningsarsag_betegnelse varchar 50 √ null
afgang_i_easy_a varchar 1 √ null
afttyp_supl4 varchar 4 √ null
afttyp_supl5 varchar 4 √ null
lon_nr varchar 8 √ null

Indexes

Constraint Name Type Sort Column(s)
afta_pk Primary key Asc afta_id
afta_afta1_uk Must be unique Asc/Asc aftaleid + central_lokal
afta_elev_fk_i Performance Asc elev_id
afta_land_fk_i Performance Asc land_id
afta_lrst_fk_i Performance Asc lrst_id
afta_obl_koder_i Performance Asc afttyp_obl
afta_skol_fk_i Performance Asc skol_id
afta_skol_skolepraktik_pa_de_1 Performance Asc skol_id_skolepraktik_pa_denne_
afta_spec_fk_i Performance Asc spec_id
easyp_spec_i Performance Asc easy_p_spec_id

Check Constraints

Constraint Name Constraint
aftaler_afta_type_check1 (((afta_type)::text = ANY ((ARRAY['AFPV'::character varying, 'LAND'::character varying, 'PIU'::character varying, 'SKPS'::character varying])::text[])))
aftaler_central_lokal_check (((central_lokal)::text = ANY ((ARRAY['C'::character varying, 'L'::character varying, 'S'::character varying])::text[])))
aftaler_skolepraktik_check (((skolepraktik)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
aftaler_check1 (('AFTA_ID' IS NOT NULL))
aftaler_check10 (('STARTDATO' IS NOT NULL))
aftaler_check7 (('OPDTID' IS NOT NULL))
aftaler_godkendt_aer_check (((godkendt_aer)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
aftaler_afgang_i_easy_a_check (((afgang_i_easy_a)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
aftaler_check6 (('OPDMOD' IS NOT NULL))
aftaler_check (('AFTALEID' IS NOT NULL))
aftaler_check2 (('AFTA_TYPE' IS NOT NULL))
aftaler_afta_type_check (((afta_type)::text = ANY ((ARRAY['AFPV'::character varying, 'PIU'::character varying, 'SKPS'::character varying, 'LAND'::character varying])::text[])))
aftaler_check4 (('ELEV_ID' IS NOT NULL))
aftaler_check9 (('SLUTDATO' IS NOT NULL))
aftaler_check3 (('CENTRAL_LOKAL' IS NOT NULL))
aftaler_aer_indberet_check (((aer_indberet)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
aftaler_check8 (('SKOL_ID' IS NOT NULL))
aftaler_check5 (('OPDINIT' IS NOT NULL))
aftaler_status_check (((status)::text = ANY ((ARRAY['A'::character varying, 'P'::character varying])::text[])))

Relationships

Close relationships within degrees of separation