elev_i_skolepraktik


Columns

Column Type Size Nulls Auto Default Children Parents Comments
eisp_id int8 19 null
ae_bidrag_skolepraktik.eisp_id aesp_eisp_fk R
holdplaceringer.eisp_id hopl_eisp_fk R
afta_id int8 19 √ null
aftaler.afta_id eisp_afta_fk R
skpe_id int8 19 √ null
skoleperioder.skpe_id eisp_skpe_fk R
skka_id int8 19 √ null
skoledagskalendere.skka_id eisp_skka_fk R
tmk_id int8 19 √ null
tilskudsmerkekombinationer.tmk_id eisp_tmk_fk R
elev_id int8 19 √ null
elever.elev_id eisp_elev_fk R
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
stmk_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
aere_id int8 19 √ null
ae_rekvirenter.aere_id eisp_aere_fk R
holdi_id int8 19 √ null
holdidenter.holdi_id eisp_holdi_fk R
o_formal varchar 10 √ null
o_ansvar varchar 10 √ null
o_projekt varchar 10 √ null
prafo_id int8 19 √ null
praktikforlob.prafo_id eisp_prafo_fk R
udforb_id int8 19 √ null
uddannelsesforlob.udforb_id eisp_udforb_fk R

Indexes

Constraint Name Type Sort Column(s)
eisp_pk Primary key Asc eisp_id
eisp_aere_fk_i Performance Asc aere_id
eisp_afta_fk_i Performance Asc afta_id
eisp_eisp1_uk Must be unique Asc/Asc afta_id + startdato
eisp_elev_fk_i Performance Asc elev_id
eisp_holdi_fk_i Performance Asc holdi_id
eisp_prafo_fk_i Performance Asc prafo_id
eisp_skka_fk_i Performance Asc skka_id
eisp_skpe_fk_i Performance Asc skpe_id
eisp_stmk_fk_i Performance Asc stmk_id
eisp_tmk_fk_i Performance Asc tmk_id
eisp_udforb_fk_i Performance Asc udforb_id

Check Constraints

Constraint Name Constraint
elev_i_skolepraktik_check5 (('OPDMOD' IS NOT NULL))
elev_i_skolepraktik_check1 (('AFTA_ID' IS NOT NULL))
elev_i_skolepraktik_check3 (('ELEV_ID' IS NOT NULL))
elev_i_skolepraktik_check10 (('STARTDATO' IS NOT NULL))
elev_i_skolepraktik_check11 (('TMK_ID' IS NOT NULL))
elev_i_skolepraktik_check8 (('SKPE_ID' IS NOT NULL))
elev_i_skolepraktik_check7 (('SKKA_ID' IS NOT NULL))
elev_i_skolepraktik_check (('AERE_ID' IS NOT NULL))
elev_i_skolepraktik_check6 (('OPDTID' IS NOT NULL))
elev_i_skolepraktik_check4 (('OPDINIT' IS NOT NULL))
elev_i_skolepraktik_check2 (('EISP_ID' IS NOT NULL))
elev_i_skolepraktik_check9 (('SLUTDATO' IS NOT NULL))

Relationships

Close relationships within degrees of separation