ftu_personer_grf


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ftupgrf_id int8 19 null
institutionsnummer varchar 10 √ null
afhentnings_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
signaturdato_ansoger timestamp 22 √ null
signatur_vejleder varchar 101 √ null
cpr_nr varchar 11 √ null
fornavn varchar 50 √ null
efternavn varchar 50 √ null
gade varchar 50 √ null
sted varchar 50 √ null
postnr varchar 15 √ null
postdistrikt varchar 50 √ null
adresse_hemmelig varchar 1 √ null
land varchar 50 √ null
alt_co varchar 105 √ null
alt_gade varchar 50 √ null
alt_sted varchar 50 √ null
alt_postnr varchar 15 √ null
alt_postdistrikt varchar 50 √ null
hjemkommune_kode varchar 3 √ null
hjemkommune_navn varchar 50 √ null
folkeskole varchar 6 √ null
folkeskole_navn varchar 50 √ null
telefonnr varchar 50 √ null
mobiltlf varchar 50 √ null
email varchar 200 √ null
cpr_nr_verge varchar 11 √ null
fornavn_verge varchar 50 √ null
efternavn_verge varchar 50 √ null
gade_verge varchar 50 √ null
sted_verge varchar 50 √ null
postnr_verge varchar 15 √ null
postdistrikt_verge varchar 50 √ null
adresse_hemmelig_verge varchar 1 √ null
telefon_verge varchar 50 √ null
ansogningsar varchar 9 √ null
signaturdato_vejleder timestamp 22 √ null
landekode varchar 3 √ null
alt_landekode varchar 3 √ null
alt_land varchar 50 √ null
cpr_nr_verge2 varchar 11 √ null
fornavn_verge2 varchar 50 √ null
efternavn_verge2 varchar 50 √ null
gade_verge2 varchar 50 √ null
sted_verge2 varchar 50 √ null
postnr_verge2 varchar 15 √ null
postdistrikt_verge2 varchar 50 √ null
adresse_hemmelig_verge2 varchar 1 √ null
telefon_verge2 varchar 50 √ null
email_verge varchar 50 √ null
email_verge2 varchar 50 √ null
ftu_a_id int8 19 √ null
ftu_ansogninger_grf.ftu_a_id ftu_per_ftu_a_id_fk R
land_id int8 19 √ null
skolestatus varchar 1 √ null
senest_opdat_fra_person timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
ftupgrf_pk_1 Primary key Asc ftupgrf_id
ftu_per_ftu_a_id_fk_i Performance Asc ftu_a_id
ftup_cpr_nr Performance Asc cpr_nr

Check Constraints

Constraint Name Constraint
ftu_personer_grf_adresse_hemmelig_verge_check (((adresse_hemmelig_verge)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
ftu_personer_grf_check8 (('INSTITUTIONSNUMMER' IS NOT NULL))
ftu_personer_grf_check5 (('FORNAVN' IS NOT NULL))
ftu_personer_grf_check7 (('GADE' IS NOT NULL))
ftu_personer_grf_check (('ADRESSE_HEMMELIG' IS NOT NULL))
ftu_personer_grf_check10 (('POSTNR' IS NOT NULL))
ftu_personer_grf_check11 (('SIGNATUR_VEJLEDER' IS NOT NULL))
ftu_personer_grf_check9 (('POSTDISTRIKT' IS NOT NULL))
ftu_personer_grf_adresse_hemmelig_check (((adresse_hemmelig)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
ftu_personer_grf_check1 (('AFHENTNINGS_ID' IS NOT NULL))
ftu_personer_grf_check4 (('EFTERNAVN' IS NOT NULL))
ftu_personer_grf_check6 (('FTU_A_ID' IS NOT NULL))
ftu_personer_grf_adresse_hemmelig_verge2_check (((adresse_hemmelig_verge2)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
ftu_personer_grf_check2 (('ANSOGNINGSAR' IS NOT NULL))
ftu_personer_grf_check3 (('CPR_NR' IS NOT NULL))

Relationships

Close relationships within degrees of separation