las_hold


Columns

Column Type Size Nulls Auto Default Children Parents Comments
skol_id int8 19 √ null
skoler.skol_id las_hol_skol_fk R
las_hol_id int8 19 null
las_arselever.las_hol_id las_aelv_las_hol_fk R
las_elevdata.las_hol2_id las_edat_las_hol_fk R
las_elevdata.las_hol_id las_edat_las_hol_afgangshol_fk R
las_elever.las_hol_id las_elv_laholdkode_for_elev_fk R
las_elever.las_nhol1_id las_elv_las_hol_fk R
las_elever.las_nhol2_id las_elv_las_hhold2_for_elev_fk R
las_karakterer.las_hol_id las_kar_las_hol_fk R
hold_kode varchar 10 √ null
formalskode varchar 10 √ null
fag varchar 20 √ null
startdato varchar 20 √ null
slutdato varchar 20 √ null
periode varchar 10 √ null
au_perioder varchar 10 √ null
telledato varchar 20 √ null
varighed numeric 12,2 √ null
rest_varighed numeric 12,2 √ null
norm numeric 12,2 √ null
speciale varchar 10 √ null
navn varchar 30 √ null
kostelevtype varchar 10 √ null
arselevtype varchar 10 √ null
aben_uddannelse varchar 3 √ null
relativ_telledato varchar 10 √ null
oko_miljo_hold varchar 3 √ null
internatkursus varchar 3 √ null
las_fag_id int8 19 √ null
las_fag.las_fag_id las_hol_las_fag_fk R

Indexes

Constraint Name Type Sort Column(s)
las_hol_pk_1 Primary key Asc las_hol_id
las_hol_las_fag_fk_i Performance Asc las_fag_id
las_hol_las_hold_uk_uk Must be unique Asc/Asc hold_kode + skol_id
las_hol_skol_fk_i Performance Asc skol_id

Check Constraints

Constraint Name Constraint
las_hold_check (('HOLD_KODE' IS NOT NULL))
las_hold_check1 (('LAS_HOL_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation