resultatformer_skolefag


Columns

Column Type Size Nulls Auto Default Children Parents Comments
refo_id int8 19 √ null
resultatformer.refo_id refo_skfa_refo_fk R
skfa_id int8 19 √ null
skolefag.skfa_id refo_skfa_skfa_fk R
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
opdmod varchar 4 √ null
uvfa_id int8 19 √ null
refo_skfa_id int8 19 null
refo_uvfa_id int8 19 √ null
resultatformer_uvm_fag.refo_uvfa_id refo_skfa_refo_uvfa_fk R
vfm_startmaned varchar 8 √ null
kalendermaneder.visningsformat_mdr refo_skfa_kamd_fk R
vfm_slutmaned varchar 8 √ null
kalendermaneder.visningsformat_mdr refo_skfa_kamd_fk2 R

Indexes

Constraint Name Type Sort Column(s)
refo_skfa_pk Primary key Asc refo_skfa_id
refo_skfa_kamd_fk2_i Performance Asc vfm_slutmaned
refo_skfa_kamd_fk_i Performance Asc vfm_startmaned
refo_skfa_refo_fk_i Performance Asc refo_id
refo_skfa_refo_uvfa_fk_i Performance Asc refo_uvfa_id
refo_skfa_skfa_fk_i Performance Asc skfa_id
refo_skfa_uk Must be unique Asc/Asc/Asc skfa_id + refo_id + vfm_startmaned

Check Constraints

Constraint Name Constraint
resultatformer_skolefag_check5 (('SKFA_ID' IS NOT NULL))
resultatformer_skolefag_check2 (('OPDTID' IS NOT NULL))
resultatformer_skolefag_check1 (('OPDMOD' IS NOT NULL))
resultatformer_skolefag_check3 (('REFO_ID' IS NOT NULL))
resultatformer_skolefag_check4 (('REFO_SKFA_ID' IS NOT NULL))
resultatformer_skolefag_check6 (('VFM_STARTMANED' IS NOT NULL))
resultatformer_skolefag_check (('OPDINIT' IS NOT NULL))

Relationships

Close relationships within degrees of separation