inb_ae_fuldtid_cpr_end


Columns

Column Type Size Nulls Auto Default Children Parents Comments
afce_id int8 19 null
afe_id int8 19 √ null
inb_ae_fuldtid_end.afe_id afce_afe_fk R
cpr_nr varchar 11 √ null
uddannelse varchar 4 √ null
version varchar 4 √ null
skoleperiode varchar 4 √ null
telleperiode int2 5 √ null
skoleforlob varchar 12 √ null
kombination varchar 5 √ null
varighed numeric 4,1 √ null
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
telledato timestamp 22 √ null
bidrag numeric 12,5 √ null
restbidrag numeric 9,5 √ null
speciale varchar 2 √ null
ae_rekvirent varchar 4 √ null
holdident varchar 8 √ null
bipe_startdato timestamp 22 √ null
bipe_slutdato timestamp 22 √ null
ds_nummer varchar 10 √ null
studiestart timestamp 22 √ null
opgorelsesmetode varchar 10 √ null
landegruppe varchar 2 √ null
ind_ud varchar 1 √ null
semesternummer int2 5 √ null
varighed_int varchar 1 √ null
ae_rekvirent_type varchar 5 √ null
elevtype varchar 10 √ null

Indexes

Constraint Name Type Sort Column(s)
afce_pk Primary key Asc afce_id
acfe_skoleforlob_i Performance Asc skoleforlob
afce_afce1_uk Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc afce_id + afe_id + cpr_nr + uddannelse + version + skoleperiode + telleperiode + skoleforlob + ae_rekvirent + speciale + elevtype + ds_nummer + studiestart + landegruppe + ind_ud + varighed_int + ae_rekvirent_type
afce_afe_fk_i Performance Asc afe_id
afce_cpr_nr_i Performance Asc/Asc/Asc/Asc/Asc/Asc cpr_nr + uddannelse + version + skoleperiode + speciale + telleperiode

Check Constraints

Constraint Name Constraint
inb_ae_fuldtid_cpr_end_check17 (('VERSION' IS NOT NULL))
inb_ae_fuldtid_cpr_end_check4 (('BIDRAG' IS NOT NULL))
inb_ae_fuldtid_cpr_end_check5 (('CPR_NR' IS NOT NULL))
inb_ae_fuldtid_cpr_end_check13 (('TELLEDATO' IS NOT NULL))
inb_ae_fuldtid_cpr_end_check2 (('AFCE_ID' IS NOT NULL))
inb_ae_fuldtid_cpr_end_check7 (('OPGORELSESMETODE' IS NOT NULL))
inb_ae_fuldtid_cpr_end_check15 (('UDDANNELSE' IS NOT NULL))
inb_ae_fuldtid_cpr_end_check16 (('VARIGHED' IS NOT NULL))
inb_ae_fuldtid_cpr_end_check10 (('SKOLEPERIODE' IS NOT NULL))
inb_ae_fuldtid_cpr_end_check3 (('AFE_ID' IS NOT NULL))
inb_ae_fuldtid_cpr_end_check (('AE_REKVIRENT' IS NOT NULL))
inb_ae_fuldtid_cpr_end_check8 (('RESTBIDRAG' IS NOT NULL))
inb_ae_fuldtid_cpr_end_opgorelsesmetode_check (((opgorelsesmetode)::text = ANY ((ARRAY['Antal'::character varying, 'Kroner'::character varying, 'Årselev'::character varying])::text[])))
inb_ae_fuldtid_cpr_end_landegruppe_check (((landegruppe)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '3'::character varying, '4'::character varying, '5'::character varying, '6'::character varying, '7'::character varying, '8'::character varying])::text[])))
inb_ae_fuldtid_cpr_end_check6 (('KOMBINATION' IS NOT NULL))
inb_ae_fuldtid_cpr_end_check12 (('STARTDATO' IS NOT NULL))
inb_ae_fuldtid_cpr_end_check9 (('SKOLEFORLOB' IS NOT NULL))
inb_ae_fuldtid_cpr_end_ind_ud_check (((ind_ud)::text = ANY ((ARRAY['1'::character varying, '2'::character varying])::text[])))
inb_ae_fuldtid_cpr_end_check14 (('TELLEPERIODE' IS NOT NULL))
inb_ae_fuldtid_cpr_end_check11 (('SLUTDATO' IS NOT NULL))
inb_ae_fuldtid_cpr_end_varighed_int_check (((varighed_int)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '3'::character varying, '4'::character varying])::text[])))
inb_ae_fuldtid_cpr_end_check1 (('AE_REKVIRENT_TYPE' IS NOT NULL))

Relationships

Close relationships within degrees of separation