lokationer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
lok_id int8 19 null
aktiviteter.lok_id akti_lok_fk R
aktivitetsgrupper.lok_id akgr_lok_fk R
ansvarsomrader.lok_id anom_lok_fk R
eksamensbegivenheder.lok_id eksabegi_lok_fk R
elevafdelinger.lok_id elafd_lok_fk R
skolefag_pa_hold_perioder.lok_id sphp_lok_fk R
ponr_id int8 19 √ null
postnr.ponr_id lok_ponr_fk R
komm_id int8 19 √ null
kommuner.komm_id lok_komm_fk R
lokation varchar 50 √ null
betegnelse varchar 50 √ null
gade varchar 50 √ null
sted varchar 50 √ null
tlfnr varchar 16 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
uvma_id int8 19 √ null
uvm_afdelinger.uvma_id lok_uvma_fk R
dsafd_id int8 19 √ null
ds_afdelinger.dsafd_id lok_dsafd_fk R

Indexes

Constraint Name Type Sort Column(s)
lok_pk Primary key Asc lok_id
lok_dsafd_fk_i1 Performance Asc dsafd_id
lok_komm_fk_i Performance Asc komm_id
lok_ponr_fk_i Performance Asc ponr_id
lok_uk Must be unique Asc lokation
lok_uvma_fk_i Performance Asc uvma_id

Check Constraints

Constraint Name Constraint
lokationer_check (('BETEGNELSE' IS NOT NULL))
lokationer_check4 (('LOK_ID' IS NOT NULL))
lokationer_check2 (('KOMM_ID' IS NOT NULL))
lokationer_check7 (('OPDTID' IS NOT NULL))
lokationer_check3 (('LOKATION' IS NOT NULL))
lokationer_check6 (('OPDMOD' IS NOT NULL))
lokationer_check5 (('OPDINIT' IS NOT NULL))
lokationer_check1 (('GADE' IS NOT NULL))
lokationer_check8 (('PONR_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation