leresteder


Columns

Column Type Size Nulls Auto Default Children Parents Comments
lrst_id int8 19 null
aftaler.lrst_id afta_lrst_fk R
debitorer.lrst_id debi_lrst_fk R
elev_i_praktikforlob.lrst_id eib_lrst_fk R
generel_ansogning.lrst_id leres_fk R
holdplaceringer.lrst_id hopl_lrst_fk R
holdplaceringer.lrst_id_betal hopl_lrst_fk2 R
kursusplaceringer.lrst_id kupl_lrst_fk R
leresteder_ean.lrst_id lrst_id_fk R
personer.lrst_id pers_lrst_fk R
skolefag_pa_hold.udlic_lrst_id skph_udlic_lrst_fk R
skolehjemselever.lrst_id shje_lrst_fk R
skoler.lrst_id skol_lrst_fk R
sosu_uddannelsesaftaler.lrst_id sur_lrst_fk R
ponr_id int8 19 √ null
postnr.ponr_id lrst_ponr_fk R
virk_id int8 19 √ null
virksomheder.virk_id lrst_virk_fk R
lerestedsid varchar 10 √ null
navn varchar 50 √ null
formodet_passiv varchar 1 √ null
brevmodtager varchar 1 √ null
aermodtager varchar 1 √ null
central_lokal varchar 1 √ null
lobenummer int2 5 √ null
gade varchar 50 √ null
sted varchar 50 √ null
telefon varchar 16 √ null
kontaktperson varchar 50 √ null
stilling varchar 50 √ null
telefon_kontaktperson varchar 16 √ null
kontakt_email varchar 200 √ null
inaktiv_pr timestamp 22 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
easy_p_lerestedsid varchar 10 √ null
kursistbrev_til_lerested varchar 1 √ null
egenidentifikation varchar 16 √ null
kunde_person_ref varchar 35 √ null
afdeling varchar 1 √ null
pnummer varchar 10 √ null
amtskode numeric 38 √ null
amtstekst varchar 50 √ null
boersnotering varchar 20 √ null
dsstoerrelseskode varchar 1 √ null
fax varchar 18 √ null
hovedafd numeric 38 √ null
husbogstav_fra varchar 1 √ null
internetadresse varchar 50 √ null
kommunetekst varchar 50 √ null
pnansatte numeric 38 √ null
pndsstoerrelseskode varchar 1 √ null
pnr varchar 16 √ null
postboks varchar 13 √ null
reklame_nejtak varchar 2 √ null
stednavn varchar 59 √ null
stiftelses_dato varchar 20 √ null
tdc_id varchar 16 √ null
tegningsregler varchar 255 √ null
vejkode numeric 38 √ null

Indexes

Constraint Name Type Sort Column(s)
lrst_pk Primary key Asc lrst_id
leresteder_idx1 Performance Asc navn
leresteder_idx2 Performance Asc gade
lrst_egenid_indx Performance Asc egenidentifikation
lrst_id_uk Must be unique Asc lerestedsid
lrst_lrst2_uk Must be unique Asc/Asc virk_id + lobenummer
lrst_p_id_indx Performance Asc easy_p_lerestedsid
lrst_ponr_fk_i Performance Asc ponr_id
lrst_virk_fk_i Performance Asc virk_id
lrst_virk_id_idx Performance Asc virk_id

Check Constraints

Constraint Name Constraint
leresteder_check11 (('OPDMOD' IS NOT NULL))
leresteder_check4 (('FORMODET_PASSIV' IS NOT NULL))
leresteder_brevmodtager_check (((brevmodtager)::text = ANY ((ARRAY['L'::character varying, 'V'::character varying])::text[])))
leresteder_check2 (('BREVMODTAGER' IS NOT NULL))
leresteder_check5 (('KURSISTBREV_TIL_LERESTED' IS NOT NULL))
leresteder_formodet_passiv_check (((formodet_passiv)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
leresteder_check3 (('CENTRAL_LOKAL' IS NOT NULL))
leresteder_check13 (('PONR_ID' IS NOT NULL))
leresteder_check6 (('LERESTEDSID' IS NOT NULL))
leresteder_kursistbrev_til_lerested_check (((kursistbrev_til_lerested)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
leresteder_check10 (('OPDINIT' IS NOT NULL))
leresteder_check9 (('NAVN' IS NOT NULL))
leresteder_central_lokal_check (((central_lokal)::text = ANY ((ARRAY['C'::character varying, 'L'::character varying])::text[])))
leresteder_check8 (('LRST_ID' IS NOT NULL))
leresteder_check (('AERMODTAGER' IS NOT NULL))
leresteder_check14 (('VIRK_ID' IS NOT NULL))
leresteder_check7 (('LOBENUMMER' IS NOT NULL))
leresteder_afdeling_check (((afdeling)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
leresteder_check12 (('OPDTID' IS NOT NULL))
leresteder_aermodtager_check (((aermodtager)::text = ANY ((ARRAY['L'::character varying, 'V'::character varying])::text[])))
leresteder_check1 (('AFDELING' IS NOT NULL))

Relationships

Close relationships within degrees of separation