sae


Columns

Column Type Size Nulls Auto Default Children Parents Comments
sae_id int8 19 null
sae_cpr.sae_id saec_sae_fk R
indbendl_id int8 19 √ null
endelige_indberetninger.indbendl_id sae_indbendl_fk R
uddannelse varchar 4 √ null
version varchar 4 √ null
speciale varchar 2 √ null
skoleperiode varchar 4 √ null
kombination varchar 5 √ null
antal_elever int4 10 √ null
bidrag numeric 9,5 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
opdmod varchar 4 √ null
ae_rekvirent varchar 4 √ null
antal_afgangsmeldte_elever int4 10 √ null
skal_med varchar 1 √ null
ae_rekvirent_type varchar 5 √ null
elevtype varchar 10 √ null

Indexes

Constraint Name Type Sort Column(s)
sae_pk Primary key Asc sae_id
sae_indbendl_fk_i Performance Asc indbendl_id
sae_sae1_uk Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc indbendl_id + ae_rekvirent_type + uddannelse + version + speciale + skoleperiode + kombination + elevtype + ae_rekvirent + sae_id

Check Constraints

Constraint Name Constraint
sae_check8 (('OPDTID' IS NOT NULL))
sae_check5 (('KOMBINATION' IS NOT NULL))
sae_check1 (('ANTAL_AFGANGSMELDTE_ELEVER' IS NOT NULL))
sae_check6 (('OPDINIT' IS NOT NULL))
sae_check (('AE_REKVIRENT_TYPE' IS NOT NULL))
sae_check11 (('SKOLEPERIODE' IS NOT NULL))
sae_check9 (('SAE_ID' IS NOT NULL))
sae_check4 (('INDBENDL_ID' IS NOT NULL))
sae_check2 (('ANTAL_ELEVER' IS NOT NULL))
sae_check3 (('BIDRAG' IS NOT NULL))
sae_skal_med_check (((skal_med)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
sae_check13 (('VERSION' IS NOT NULL))
sae_check7 (('OPDMOD' IS NOT NULL))
sae_check12 (('UDDANNELSE' IS NOT NULL))
sae_check10 (('SKAL_MED' IS NOT NULL))

Relationships

Close relationships within degrees of separation