inb_ae_skprak_cpr_end


Columns

Column Type Size Nulls Auto Default Children Parents Comments
asce_id int8 19 null
ase_id int8 19 √ null
inb_ae_skprak_end.ase_id asce_ase_fk R
cpr_nr varchar 11 √ null
uddannelse varchar 4 √ null
version varchar 4 √ null
skoleperiode varchar 4 √ null
kombination varchar 5 √ null
speciale varchar 2 √ null
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
bidrag numeric 9,5 √ null
ae_rekvirent varchar 4 √ null
afgangsdato timestamp 22 √ null
afgangsarsag varchar 5 √ null
holdident varchar 8 √ null
alt_startdato timestamp 22 √ null
alt_slutdato timestamp 22 √ null
antal_onsdage int4 10 √ null
ae_rekvirent_type varchar 5 √ null
elevtype varchar 10 √ null

Indexes

Constraint Name Type Sort Column(s)
asce_pk Primary key Asc asce_id
asce_asce1_uk Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc asce_id + ase_id + cpr_nr + uddannelse + version + skoleperiode + speciale + elevtype + ae_rekvirent + ae_rekvirent_type
asce_ase_fk_i Performance Asc ase_id
asce_cpr_nr_i Performance Asc/Asc/Asc/Asc/Asc/Asc cpr_nr + uddannelse + version + skoleperiode + speciale + ae_rekvirent

Check Constraints

Constraint Name Constraint
inb_ae_skprak_cpr_end_check (('AE_REKVIRENT' IS NOT NULL))
inb_ae_skprak_cpr_end_check10 (('UDDANNELSE' IS NOT NULL))
inb_ae_skprak_cpr_end_check9 (('STARTDATO' IS NOT NULL))
inb_ae_skprak_cpr_end_check11 (('VERSION' IS NOT NULL))
inb_ae_skprak_cpr_end_check7 (('SKOLEPERIODE' IS NOT NULL))
inb_ae_skprak_cpr_end_check5 (('CPR_NR' IS NOT NULL))
inb_ae_skprak_cpr_end_check3 (('ASE_ID' IS NOT NULL))
inb_ae_skprak_cpr_end_check1 (('AE_REKVIRENT_TYPE' IS NOT NULL))
inb_ae_skprak_cpr_end_check2 (('ASCE_ID' IS NOT NULL))
inb_ae_skprak_cpr_end_check4 (('BIDRAG' IS NOT NULL))
inb_ae_skprak_cpr_end_check8 (('SLUTDATO' IS NOT NULL))
inb_ae_skprak_cpr_end_check6 (('KOMBINATION' IS NOT NULL))

Relationships

Close relationships within degrees of separation