folkeskoler


Columns

Column Type Size Nulls Auto Default Children Parents Comments
fosk_id int8 19 null
generel_ansogning.fosk_id ganso_fosk_fk R
personer.fosk_id pers_fosk_fk R
opdtid timestamp 22 √ null
opdinit varchar 30 √ null
nr varchar 6 √ null
navn varchar 50 √ null
opdmod varchar 4 √ null
skolestatus varchar 1 √ null
ponr_id int8 19 √ null
postnr.ponr_id folkskoler_postnr_fk R

Indexes

Constraint Name Type Sort Column(s)
fosk_pk Primary key Asc fosk_id
folkskoler_postnr_fk_i Performance Asc ponr_id
fosk_fosk1_uk Must be unique Asc nr

Check Constraints

Constraint Name Constraint
folkeskoler_check2 (('NR' IS NOT NULL))
folkeskoler_check4 (('OPDMOD' IS NOT NULL))
folkeskoler_check (('FOSK_ID' IS NOT NULL))
folkeskoler_check5 (('OPDTID' IS NOT NULL))
folkeskoler_check1 (('NAVN' IS NOT NULL))
folkeskoler_check3 (('OPDINIT' IS NOT NULL))

Relationships

Close relationships within degrees of separation