inb_aer_end


Columns

Column Type Size Nulls Auto Default Children Parents Comments
aer_e_id int8 19 null
aer_indb_indberetningsperiode.aer_e_id aeri_aer_e_aer_e_fk R
inb_aer_end_grundlag.aer_e_id aeg_aer_e_fk R
summering varchar 1 √ null
rectype varchar 3 √ null
afsendid varchar 8 √ null
dantmp varchar 26 √ null
indbendl_id int8 19 √ null
endelige_indberetninger.indbendl_id aer_e_indbendl_fk R
opret_ret varchar 1 √ null
virk_se_nr varchar 8 √ null
lrst_navn varchar 50 √ null
lrst_gade varchar 50 √ null
lrst_sted varchar 50 √ null
lrst_postnr varchar 15 √ null
pers_cpr_nr varchar 11 √ null
pers_fornavn varchar 50 √ null
pers_efternavn varchar 50 √ null
skolepraktik varchar 2 √ null
afta_startdato timestamp 22 √ null
seneste_slutdato timestamp 22 √ null
elev_afgangsdato timestamp 22 √ null
afta_slutdato timestamp 22 √ null
udda_version varchar 4 √ null
udda_betegnelse varchar 50 √ null
anden_betaler varchar 3 √ null
afbrudt_skoleophold timestamp 22 √ null
bemtxt varchar 100 √ null
ds_nr varchar 10 √ null
eiap_startdato timestamp 22 √ null
gl_se_nr varchar 8 √ null
gl_cpr_nr varchar 11 √ null
gl_skoleophold_start timestamp 22 √ null
eiap_slutdato timestamp 22 √ null
cosa_formal varchar 4 √ null
spec_speciale varchar 2 √ null
refusion numeric 10,2 √ null
befordring numeric 10,2 √ null
eiap_kontaktperson varchar 50 √ null
eiap_telefonnr varchar 16 √ null
eiap_lokalnr varchar 16 √ null
periodetype varchar 10 √ null
skoleforlob varchar 12 √ null
overlap_tilladt varchar 1 √ null
gl_skoleforlob varchar 12 √ null
kort_afta varchar 4 √ null
udd_afsluttet varchar 1 √ null
cvr_nr varchar 8 √ null
inb_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
eiap_guid varchar 32 √ null

Indexes

Constraint Name Type Sort Column(s)
aer_e_pk Primary key Asc aer_e_id
aer_e_aer_e_uk_1_uk Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc indbendl_id + eiap_startdato + pers_cpr_nr + gl_cpr_nr + cosa_formal + udda_version + skoleforlob + opret_ret + inb_id
aer_e_indbendl_fk_i Performance Asc indbendl_id

Check Constraints

Constraint Name Constraint
inb_aer_end_check4 (('DANTMP' IS NOT NULL))
inb_aer_end_check8 (('LRST_NAVN' IS NOT NULL))
inb_aer_end_check10 (('OPRET_RET' IS NOT NULL))
inb_aer_end_check12 (('PERS_EFTERNAVN' IS NOT NULL))
inb_aer_end_check9 (('LRST_POSTNR' IS NOT NULL))
inb_aer_end_summering_check (((summering)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
inb_aer_end_check7 (('KORT_AFTA' IS NOT NULL))
inb_aer_end_opret_ret_check (((opret_ret)::text = ANY ((ARRAY['O'::character varying, 'R'::character varying])::text[])))
inb_aer_end_check13 (('PERS_FORNAVN' IS NOT NULL))
inb_aer_end_check2 (('AFTA_SLUTDATO' IS NOT NULL))
inb_aer_end_check16 (('VIRK_SE_NR' IS NOT NULL))
inb_aer_end_check6 (('EIAP_STARTDATO' IS NOT NULL))
inb_aer_end_udd_afsluttet_check (((udd_afsluttet)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
inb_aer_end_check (('AER_E_ID' IS NOT NULL))
inb_aer_end_check1 (('AFSENDID' IS NOT NULL))
inb_aer_end_overlap_tilladt_check (((overlap_tilladt)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
inb_aer_end_check14 (('RECTYPE' IS NOT NULL))
inb_aer_end_check5 (('EIAP_SLUTDATO' IS NOT NULL))
inb_aer_end_check11 (('PERS_CPR_NR' IS NOT NULL))
inb_aer_end_check15 (('SUMMERING' IS NOT NULL))
inb_aer_end_check3 (('AFTA_STARTDATO' IS NOT NULL))

Relationships

Close relationships within degrees of separation