generelt_optag


Columns

Column Type Size Nulls Auto Default Children Parents Comments
gopta_id int8 19 null
generel_ansogning.gopta_id ganso_gopta_fk R
generel_ansogning.gopta_id2 ganso_gopta_fk2 R
generel_studiestart.gopta_id gstus_gopta_fk R
generelt_optag varchar 24 √ null
dimensioneret_optag int4 10 √ null
planlagt_overoptag int4 10 √ null
udda_id int8 19 √ null
uddannelser.udda_id gopta_udda_fk R
spec_id int8 19 √ null
specialer.spec_id gopta_spec_fk R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
gopta_pk Primary key Asc gopta_id
gopta_spec_fk_i Performance Asc spec_id
gopta_udda_fk_i Performance Asc udda_id
gopta_uk Must be unique Asc generelt_optag

Check Constraints

Constraint Name Constraint
generelt_optag_check5 (('UDDA_ID' IS NOT NULL))
generelt_optag_check4 (('OPDTID' IS NOT NULL))
generelt_optag_check3 (('OPDMOD' IS NOT NULL))
generelt_optag_check1 (('GOPTA_ID' IS NOT NULL))
generelt_optag_check (('GENERELT_OPTAG' IS NOT NULL))
generelt_optag_check2 (('OPDINIT' IS NOT NULL))

Relationships

Close relationships within degrees of separation