inb_aer_end_grundlag


Columns

Column Type Size Nulls Auto Default Children Parents Comments
aeg_id int8 19 null
rectype varchar 3 √ null
afsendid varchar 8 √ null
dantmp varchar 26 √ null
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
aer_e_id int8 19 √ null
inb_aer_end.aer_e_id aeg_aer_e_fk R
eiap_id int8 19 √ null
udd_afsluttet varchar 1 √ null
cvr_nr varchar 8 √ null

Indexes

Constraint Name Type Sort Column(s)
aeg_pk Primary key Asc aeg_id
aeg_aer_e_fk_i Performance Asc aer_e_id
aeg_eiap_i1 Performance Asc eiap_id
aeg_uk_1 Must be unique Asc/Asc/Asc aer_e_id + opret_ret + eiap_startdato

Check Constraints

Constraint Name Constraint
inb_aer_end_grundlag_check8 (('EIAP_STARTDATO' IS NOT NULL))
inb_aer_end_grundlag_check13 (('PERS_CPR_NR' IS NOT NULL))
inb_aer_end_grundlag_check14 (('PERS_EFTERNAVN' IS NOT NULL))
inb_aer_end_grundlag_check3 (('AFTA_SLUTDATO' IS NOT NULL))
inb_aer_end_grundlag_check5 (('DANTMP' IS NOT NULL))
inb_aer_end_grundlag_check7 (('EIAP_SLUTDATO' IS NOT NULL))
inb_aer_end_grundlag_check6 (('EIAP_ID' IS NOT NULL))
inb_aer_end_grundlag_udd_afsluttet_check (((udd_afsluttet)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
inb_aer_end_grundlag_check2 (('AFSENDID' IS NOT NULL))
inb_aer_end_grundlag_opret_ret_check (((opret_ret)::text = ANY ((ARRAY['O'::character varying, 'R'::character varying])::text[])))
inb_aer_end_grundlag_check10 (('LRST_NAVN' IS NOT NULL))
inb_aer_end_grundlag_check15 (('PERS_FORNAVN' IS NOT NULL))
inb_aer_end_grundlag_check9 (('KORT_AFTA' IS NOT NULL))
inb_aer_end_grundlag_check (('AEG_ID' IS NOT NULL))
inb_aer_end_grundlag_check4 (('AFTA_STARTDATO' IS NOT NULL))
inb_aer_end_grundlag_check16 (('RECTYPE' IS NOT NULL))
inb_aer_end_grundlag_check17 (('VIRK_SE_NR' IS NOT NULL))
inb_aer_end_grundlag_check11 (('LRST_POSTNR' IS NOT NULL))
inb_aer_end_grundlag_check1 (('AER_E_ID' IS NOT NULL))
inb_aer_end_grundlag_check12 (('OPRET_RET' IS NOT NULL))
inb_aer_end_grundlag_overlap_tilladt_check (((overlap_tilladt)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))

Relationships

Close relationships within degrees of separation