ds_afdelinger


Columns

Column Type Size Nulls Auto Default Children Parents Comments
dsafd_id int8 19 null
generel_ansogning.dsafd_id1 ganso_dsafd_fk1 R
generel_ansogning.dsafd_id2 ganso_dsafd_fk2 R
generel_ansogning.dsafd_id3 ganso_dsafd_fk3 R
generel_ansogning.dsafd_id4 ganso_dsafd_fk4 R
generel_studiestart.dsafd_id gstus_dsafd_fk R
lokationer.dsafd_id lok_dsafd_fk R
perioder_for_ds_afdelinger.dsafd_id pfda_dsafd_fk R
ds_nummer varchar 10 √ null
navn varchar 50 √ null
gade varchar 50 √ null
sted varchar 50 √ null
ponr_id int8 19 √ null
postnr.ponr_id dsafd_ponr_fk R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
dsafd_pk Primary key Asc dsafd_id
dsafd_ponr_fk_i Performance Asc ponr_id
dsafd_uk Must be unique Asc ds_nummer

Check Constraints

Constraint Name Constraint
ds_afdelinger_check (('DSAFD_ID' IS NOT NULL))
ds_afdelinger_check5 (('OPDMOD' IS NOT NULL))
ds_afdelinger_check4 (('OPDINIT' IS NOT NULL))
ds_afdelinger_check2 (('GADE' IS NOT NULL))
ds_afdelinger_check1 (('DS_NUMMER' IS NOT NULL))
ds_afdelinger_check3 (('NAVN' IS NOT NULL))
ds_afdelinger_check6 (('OPDTID' IS NOT NULL))
ds_afdelinger_check7 (('PONR_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation