inb_ae_skprak_end


Columns

Column Type Size Nulls Auto Default Children Parents Comments
recordtype varchar 15 √ null
ase_id int8 19 null
inb_ae_skprak_cpr_end.ase_id asce_ase_fk R
indbendl_id int8 19 √ null
endelige_indberetninger.indbendl_id ase_indbendl_fk R
uddannelse varchar 4 √ null
version varchar 4 √ null
skoleperiode varchar 4 √ null
kombination varchar 5 √ null
speciale varchar 2 √ null
skolenr varchar 4 √ null
bidrag numeric 12,5 √ null
antal_elever int4 10 √ null
ae_rekvirent varchar 4 √ null
ae_rekvirent_type varchar 5 √ null
antal_afgangsmeldte_elever int4 10 √ null
elevtype varchar 10 √ null

Indexes

Constraint Name Type Sort Column(s)
ase_pk Primary key Asc ase_id
ase_ase1_uk Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc ase_id + indbendl_id + uddannelse + version + skoleperiode + kombination + elevtype + speciale + ae_rekvirent + ae_rekvirent_type
ase_indbendl_fk_i Performance Asc indbendl_id

Check Constraints

Constraint Name Constraint
inb_ae_skprak_end_check1 (('ANTAL_AFGANGSMELDTE_ELEVER' IS NOT NULL))
inb_ae_skprak_end_check11 (('VERSION' IS NOT NULL))
inb_ae_skprak_end_check4 (('BIDRAG' IS NOT NULL))
inb_ae_skprak_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_skprak_end_check2 (('ANTAL_ELEVER' IS NOT NULL))
inb_ae_skprak_end_check3 (('ASE_ID' IS NOT NULL))
inb_ae_skprak_end_check6 (('KOMBINATION' IS NOT NULL))
inb_ae_skprak_end_check10 (('UDDANNELSE' IS NOT NULL))
inb_ae_skprak_end_check5 (('INDBENDL_ID' IS NOT NULL))
inb_ae_skprak_end_check (('AE_REKVIRENT_TYPE' IS NOT NULL))
inb_ae_skprak_end_check8 (('SKOLENR' IS NOT NULL))
inb_ae_skprak_end_check7 (('RECORDTYPE' IS NOT NULL))
inb_ae_skprak_end_check9 (('SKOLEPERIODE' IS NOT NULL))

Relationships

Close relationships within degrees of separation