las_karakterer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
skol_id int8 19 √ null
skoler.skol_id las_kar_skol_fk R
las_kar_id int8 19 null
cpr_nr varchar 20 √ null
fagnr varchar 20 √ null
hold varchar 10 √ null
karakter_lbnr int8 19 √ null
formalskode varchar 10 √ null
godkendt varchar 3 √ null
elevnavn varchar 30 √ null
klasse varchar 10 √ null
karakterdato varchar 20 √ null
karaktertype varchar 10 √ null
karakter int8 19 √ null
faggr varchar 10 √ null
fagnavn varchar 30 √ null
liniefag varchar 3 √ null
hovedopgave varchar 3 √ null
valgfag varchar 3 √ null
bestaet varchar 3 √ null
points int8 19 √ null
cosa_formal varchar 10 √ null
brugerid varchar 10 √ null
dato varchar 20 √ null
tid varchar 20 √ null
las_fag_id int8 19 √ null
las_fag.las_fag_id las_kar_las_fag_fk R
las_elv_id int8 19 √ null
las_elever.las_elv_id las_kar_las_elv_fk R
las_hol_id int8 19 √ null
las_hold.las_hol_id las_kar_las_hol_fk R

Indexes

Constraint Name Type Sort Column(s)
las_kar_pk_1 Primary key Asc las_kar_id
las_kar_las_elv_fk_i Performance Asc las_elv_id
las_kar_las_fag_fk_i Performance Asc las_fag_id
las_kar_las_hol_fk_i Performance Asc las_hol_id
las_kar_las_kar_uk_uk_i Performance Asc/Asc/Asc karakter_lbnr + skol_id + godkendt
las_kar_skol_fk_i Performance Asc skol_id

Check Constraints

Constraint Name Constraint
las_karakterer_check6 (('LAS_KAR_ID' IS NOT NULL))
las_karakterer_check1 (('FAGNR' IS NOT NULL))
las_karakterer_check (('CPR_NR' IS NOT NULL))
las_karakterer_check5 (('LAS_HOL_ID' IS NOT NULL))
las_karakterer_check2 (('HOLD' IS NOT NULL))
las_karakterer_check3 (('LAS_ELV_ID' IS NOT NULL))
las_karakterer_check4 (('LAS_FAG_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation