ansvarsomrader


Columns

Column Type Size Nulls Auto Default Children Parents Comments
anom_id int8 19 null
aktiviteter.anom_id akti_anom_fk R
aktivitetsgrupper.anom_id akgr_anom_fk R
eksamensbegivenheder.anom_id eksabegi_anom_fk R
skoleforlob.anom_id skof_anom_fk R
ansvarsomrade varchar 10 √ null
gyldig_fra timestamp 22 √ null
kort_betegnelse varchar 15 √ null
betegnelse varchar 50 √ null
gyldig_til timestamp 22 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
udgr_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
pom_id int8 19 √ null
projektomrader.pom_id anom_pom_fk R
lok_id int8 19 √ null
lokationer.lok_id anom_lok_fk R
risy_id int8 19 √ null
ringesystemer.risy_id anom_risy_fk R
skka_id int8 19 √ null
skoledagskalendere.skka_id anom_skka_fk R
kontaktperson varchar 50 √ null
kontakt_telefonnr varchar 20 √ null
tilmeldingshjemmeside varchar 200 √ null
ponr_id int8 19 √ null
postnr.ponr_id anom_ponr_fk R
starttidspunkt varchar 5 √ null
sluttidspunkt varchar 5 √ null
kontakt_email varchar 100 √ null
kviknummer_lig_aktivitet varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
anom_pk Primary key Asc anom_id
anom_anom1_uk Must be unique Asc ansvarsomrade
anom_lok_fk_i Performance Asc lok_id
anom_pom_fk_i Performance Asc pom_id
anom_ponr_fk_i Performance Asc ponr_id
anom_risy_fk_i Performance Asc risy_id
anom_skka_fk_i Performance Asc skka_id
anom_udgr_fk_i Performance Asc udgr_id

Check Constraints

Constraint Name Constraint
ansvarsomrader_check1 (('ANSVARSOMRADE' IS NOT NULL))
ansvarsomrader_check3 (('GYLDIG_FRA' IS NOT NULL))
ansvarsomrader_check6 (('OPDINIT' IS NOT NULL))
ansvarsomrader_check (('ANOM_ID' IS NOT NULL))
ansvarsomrader_check2 (('BETEGNELSE' IS NOT NULL))
ansvarsomrader_check8 (('OPDTID' IS NOT NULL))
ansvarsomrader_check7 (('OPDMOD' IS NOT NULL))
ansvarsomrader_check5 (('KVIKNUMMER_LIG_AKTIVITET' IS NOT NULL))
ansvarsomrader_check4 (('KORT_BETEGNELSE' IS NOT NULL))

Relationships

Close relationships within degrees of separation