inb_kbr_header_end


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ikhend_id int8 19 null
inb_kbr_data_end.ikhend_id ikdend_ikhend_fk R
indbendl_id int8 19 √ null
endelige_indberetninger.indbendl_id ikhend_indbendl_fk R
filtype varchar 3 √ null
afsendelses_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
easy_a_version varchar 15 √ null
dato_for_udtrek timestamp 22 √ null
fradato timestamp 22 √ null
tildato timestamp 22 √ null
kommunekode varchar 3 √ null
ds_skole_nr varchar 10 √ null
skolenavn varchar 50 √ null
antal_records int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
ikhend_pk Primary key Asc ikhend_id
ikhend_ikhend_uk Must be unique Asc indbendl_id

Check Constraints

Constraint Name Constraint
inb_kbr_header_end_check4 (('FILTYPE' IS NOT NULL))
inb_kbr_header_end_check (('ANTAL_RECORDS' IS NOT NULL))
inb_kbr_header_end_check3 (('EASY_A_VERSION' IS NOT NULL))
inb_kbr_header_end_check8 (('KOMMUNEKODE' IS NOT NULL))
inb_kbr_header_end_check7 (('INDBENDL_ID' IS NOT NULL))
inb_kbr_header_end_check9 (('SKOLENAVN' IS NOT NULL))
inb_kbr_header_end_check10 (('TILDATO' IS NOT NULL))
inb_kbr_header_end_check5 (('FRADATO' IS NOT NULL))
inb_kbr_header_end_check2 (('DS_SKOLE_NR' IS NOT NULL))
inb_kbr_header_end_check6 (('IKHEND_ID' IS NOT NULL))
inb_kbr_header_end_check1 (('DATO_FOR_UDTREK' IS NOT NULL))

Relationships

Close relationships within degrees of separation