personer_revisionsspor


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pr_id int8 19 null
pers_id int8 19 √ null
fornavn varchar 50 √ null
efternavn varchar 50 √ null
opropdtid timestamp 22 √ null
cpr_nr varchar 11 √ null
opropdinit varchar 30 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
opropdmod varchar 4 √ null
opdmod varchar 4 √ null
dod varchar 1 √ null
adr_pa_udskrift varchar 1 √ null
adr_pa_udskrift_verge varchar 1 √ null
kommunekode varchar 3 √ null
landkode varchar 3 √ null
folkeskolenr varchar 6 √ null
sprogkode varchar 2 √ null
postnr varchar 15 √ null
alternativ_postnr varchar 15 √ null
verge_postnr varchar 15 √ null
se_nr varchar 8 √ null
lobenr int2 5 √ null
co varchar 100 √ null
foto_filnavn varchar 255 √ null
gade varchar 50 √ null
sted varchar 50 √ null
alt_adr_gyldig_fra timestamp 22 √ null
alt_adr_gyldig_til timestamp 22 √ null
alt_co varchar 100 √ null
alt_gade varchar 50 √ null
alt_sted varchar 50 √ null
cpr_nr_verge varchar 11 √ null
fornavn_verge varchar 50 √ null
efternavn_verge varchar 50 √ null
co_verge varchar 100 √ null
gade_verge varchar 50 √ null
sted_verge varchar 50 √ null
telefon_verge varchar 16 √ null
helbredsattest timestamp 22 √ null
am_tilknytning varchar 1 √ null
skolestatus varchar 1 √ null
cpr_abonnement int2 5 √ null
kode_nr varchar 50 √ null
kot_cpr_nr varchar 10 √ null
elevplan_person varchar 1 √ null
cpr_abonnement_verge int2 5 √ null
operation varchar 1 √ null
adr_pa_udskrift_verge2 varchar 1 √ null
verge2_postnr varchar 15 √ null
cpr_nr_verge2 varchar 11 √ null
fornavn_verge2 varchar 50 √ null
efternavn_verge2 varchar 50 √ null
co_verge2 varchar 100 √ null
gade_verge2 varchar 50 √ null
sted_verge2 varchar 50 √ null
telefon_verge2 varchar 16 √ null
cpr_abonnement_verge2 int2 5 √ null
midlertidigt_umyndiggjort varchar 1 √ null
kompetencevurderet varchar 1 √ null
mentor varchar 200 √ null
reklamebeskyttet varchar 1 √ null
email_verge varchar 50 √ null
email_verge2 varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
pr_pk Primary key Asc pr_id
pr_pers_id_idx Performance Asc pers_id
stil_pr_idx1 Performance Asc cpr_nr
stil_pr_idx2 Performance Asc pers_id

Check Constraints

Constraint Name Constraint
personer_revisionsspor_operation_check (((operation)::text = ANY ((ARRAY['-'::character varying, 'D'::character varying, 'I'::character varying, 'U'::character varying])::text[])))
personer_revisionsspor_check2 (('OPDTID' IS NOT NULL))
personer_revisionsspor_kompetencevurderet_check (((kompetencevurderet)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
personer_revisionsspor_midlertidigt_umyndiggjort_check (((midlertidigt_umyndiggjort)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
personer_revisionsspor_adr_pa_udskrift_verge_check (((adr_pa_udskrift_verge)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
personer_revisionsspor_check5 (('PERS_ID' IS NOT NULL))
personer_revisionsspor_check4 (('OPROPDTID' IS NOT NULL))
personer_revisionsspor_dod_check (((dod)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
personer_revisionsspor_adr_pa_udskrift_verge2_check (((adr_pa_udskrift_verge2)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
personer_revisionsspor_check (('OPDINIT' IS NOT NULL))
personer_revisionsspor_check7 (('REKLAMEBESKYTTET' IS NOT NULL))
personer_revisionsspor_reklamebeskyttet_check (((reklamebeskyttet)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
personer_revisionsspor_skolestatus_check (((skolestatus)::text = ANY ((ARRAY['0'::character varying, '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[])))
personer_revisionsspor_elevplan_person_check (((elevplan_person)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
personer_revisionsspor_adr_pa_udskrift_check (((adr_pa_udskrift)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
personer_revisionsspor_am_tilknytning_check (((am_tilknytning)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '3'::character varying])::text[])))
personer_revisionsspor_check6 (('PR_ID' IS NOT NULL))
personer_revisionsspor_check1 (('OPDMOD' IS NOT NULL))
personer_revisionsspor_check3 (('OPERATION' IS NOT NULL))

Relationships

Close relationships within degrees of separation