inb_ae_fuldtid_end


Columns

Column Type Size Nulls Auto Default Children Parents Comments
afe_id int8 19 null
inb_ae_fuldtid_cpr_end.afe_id afce_afe_fk R
indbendl_id int8 19 √ null
endelige_indberetninger.indbendl_id afe_indbendl_fk R
skolenr varchar 4 √ null
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
uddannelse varchar 4 √ null
version varchar 4 √ null
skoleperiode varchar 4 √ null
telleperiode int2 5 √ null
kombination varchar 5 √ null
varighed numeric 4,1 √ null
bidrag numeric 12,5 √ null
restbidrag numeric 9,5 √ null
antal_elever int4 10 √ null
recordtype varchar 15 √ null
speciale varchar 2 √ null
ae_rekvirent varchar 4 √ null
ds_nummer varchar 10 √ null
opgorelsesmetode varchar 10 √ null
systemversion varchar 15 √ null
studiestart timestamp 22 √ 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)
afe_pk Primary key Asc afe_id
afe_afe1_uk Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc afe_id + indbendl_id + uddannelse + version + skoleperiode + telleperiode + kombination + elevtype + varighed + ae_rekvirent + speciale + ds_nummer + studiestart + landegruppe + ind_ud + varighed_int + ae_rekvirent_type
afe_indbendl_fk_i Performance Asc indbendl_id

Check Constraints

Constraint Name Constraint
inb_ae_fuldtid_end_check9 (('SKOLENR' IS NOT NULL))
inb_ae_fuldtid_end_opgorelsesmetode_check (((opgorelsesmetode)::text = ANY ((ARRAY['Antal'::character varying, 'Kroner'::character varying, 'Årselev'::character varying])::text[])))
inb_ae_fuldtid_end_check10 (('SKOLEPERIODE' IS NOT NULL))
inb_ae_fuldtid_end_ind_ud_check (((ind_ud)::text = ANY ((ARRAY['1'::character varying, '2'::character varying])::text[])))
inb_ae_fuldtid_end_check17 (('VERSION' IS NOT NULL))
inb_ae_fuldtid_end_check5 (('KOMBINATION' IS NOT NULL))
inb_ae_fuldtid_end_check2 (('ANTAL_ELEVER' IS NOT NULL))
inb_ae_fuldtid_end_check12 (('STARTDATO' IS NOT NULL))
inb_ae_fuldtid_end_check6 (('OPGORELSESMETODE' IS NOT NULL))
inb_ae_fuldtid_end_check16 (('VARIGHED' IS NOT NULL))
inb_ae_fuldtid_end_check3 (('BIDRAG' IS NOT NULL))
inb_ae_fuldtid_end_check8 (('RESTBIDRAG' IS NOT NULL))
inb_ae_fuldtid_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_end_check4 (('INDBENDL_ID' IS NOT NULL))
inb_ae_fuldtid_end_check1 (('AFE_ID' IS NOT NULL))
inb_ae_fuldtid_end_check7 (('RECORDTYPE' IS NOT NULL))
inb_ae_fuldtid_end_check13 (('SYSTEMVERSION' IS NOT NULL))
inb_ae_fuldtid_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_end_recordtype_check (((recordtype)::text = ANY ((ARRAY['DETAIL ÆNDRET'::character varying, 'MASTER ÆNDRET'::character varying, 'NY'::character varying, 'UDGÅET'::character varying])::text[])))
inb_ae_fuldtid_end_check14 (('TELLEPERIODE' IS NOT NULL))
inb_ae_fuldtid_end_check11 (('SLUTDATO' IS NOT NULL))
inb_ae_fuldtid_end_check15 (('UDDANNELSE' IS NOT NULL))
inb_ae_fuldtid_end_check (('AE_REKVIRENT_TYPE' IS NOT NULL))

Relationships

Close relationships within degrees of separation