eksterne_telleperioder


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ektp_id int8 19 null
tape_id int8 19 √ null
telleperioder.tape_id ektp_tape_fk R
exskf_id int8 19 √ null
eksterneskoleforlob.exskf_id ektp_exskf_fk R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
ektp_pk Primary key Asc ektp_id
ektp_exskf_fk_i Performance Asc exskf_id
ektp_tape_fk_i Performance Asc tape_id
ektp_uk Must be unique Asc/Asc exskf_id + tape_id

Check Constraints

Constraint Name Constraint
eksterne_telleperioder_check5 (('TAPE_ID' IS NOT NULL))
eksterne_telleperioder_check (('EKTP_ID' IS NOT NULL))
eksterne_telleperioder_check1 (('EXSKF_ID' IS NOT NULL))
eksterne_telleperioder_check3 (('OPDMOD' IS NOT NULL))
eksterne_telleperioder_check4 (('OPDTID' IS NOT NULL))
eksterne_telleperioder_check2 (('OPDINIT' IS NOT NULL))

Relationships

Close relationships within degrees of separation