elev_i_praktikforlob


Columns

Column Type Size Nulls Auto Default Children Parents Comments
eipra_id int8 19 null
prafo_id int8 19 √ null
praktikforlob.prafo_id eib_prafo_fk R
udforb_id int8 19 √ null
uddannelsesforlob.udforb_id eib_udforb_fk R
elev_id int8 19 √ null
elever.elev_id eib_elev_fk R
lrst_id int8 19 √ null
leresteder.lrst_id eib_lrst_fk R
prakt_id int8 19 √ null
praktiktyper.prakt_id eib_prakt_fk R
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
bemerkning varchar 1000 √ null
easyp_aftaleid int8 19 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
eib_pk Primary key Asc eipra_id
eib_elev_fk_i Performance Asc elev_id
eib_lrst_fk_i Performance Asc lrst_id
eib_prafo_fk_i Performance Asc prafo_id
eib_prakt_fk_i Performance Asc prakt_id
eib_udforb_fk_i Performance Asc udforb_id
eib_uk Must be unique Asc/Asc/Asc elev_id + startdato + prafo_id

Check Constraints

Constraint Name Constraint
elev_i_praktikforlob_check7 (('STARTDATO' IS NOT NULL))
elev_i_praktikforlob_check4 (('OPDTID' IS NOT NULL))
elev_i_praktikforlob_check6 (('SLUTDATO' IS NOT NULL))
elev_i_praktikforlob_check5 (('PRAFO_ID' IS NOT NULL))
elev_i_praktikforlob_check2 (('OPDINIT' IS NOT NULL))
elev_i_praktikforlob_check3 (('OPDMOD' IS NOT NULL))
elev_i_praktikforlob_check1 (('ELEV_ID' IS NOT NULL))
elev_i_praktikforlob_check (('EIPRA_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation