sdfe_kaldag


Columns

Column Type Size Nulls Auto Default Children Parents Comments
sdka_id int8 19 null
sdfe_id int8 19 √ null
skoledage_for_eksterne_booking.sdfe_id sdka_sdfe_fk R
dato timestamp 22 √ null
kaldag_id int8 19 √ null
kalenderdage.kaldag_id sdka_kaldag_fk R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
sdka_pk Primary key Asc sdka_id
sdka_kaldag_fk_i Performance Asc kaldag_id
sdka_sdfe_fk_i Performance Asc sdfe_id

Check Constraints

Constraint Name Constraint
sdfe_kaldag_check3 (('OPDTID' IS NOT NULL))
sdfe_kaldag_check2 (('OPDMOD' IS NOT NULL))
sdfe_kaldag_check1 (('OPDINIT' IS NOT NULL))
sdfe_kaldag_check (('DATO' IS NOT NULL))
sdfe_kaldag_check4 (('SDKA_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation