Datadictionary OpenWave 3.1.11
 Previous topic Chapter index Next topic

Table: tbcorrespbinnen

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Tabel met binnengekomen correspondentie per vergunningsaanvraag of inrichting

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbcorrespbinnen_dnkey_seq'::regclass)

Primary key.

 

dnkeybouwvergunningen

integer

 

 

 

 

Foreign key naar TbBouwvergunningen.dnkey

 

dnkeyovvergunningen

integer

 

 

 

 

Foreign key naar TbOvVergunningen.dnkey

 

dnkeyhandhavingen

integer

 

 

 

 

Foreign key naar TbHandhavingen.dnkey

 

dnkeycontactadressen

integer

 

 

 

 

Foreign key naar TbContactadressen.dnkey

 

 

dvarchiefnummer

varchar(25)

 

 

 

 

Archiefnummer, boekingsnummer.

 

 

dvomschrijving

varchar(200)

 

 

 

 

Omschrijving van binnengekomen brief.

 

 

dddatumbinnen

timestamp

 

 

 

 

Datum brief binnengekomen.

 

 

dvonderwerp

varchar(25)

 

 

 

 

Vrij onderwerpkolom.

 

 

dvkenmerk

varchar(25)

 

 

 

 

Briefkenmerk.

 

dnkeyhorecavergunningen

integer

 

 

 

 

Foreign Key baar tabel TbHorecavergunningen.dnkey.

 

dnkeybestemmingsplannen

integer

 

 

 

 

Foreign Key naar tabel TbBestemmingsplannen.dnkey.

 

dnkeysoortcorrbinnen

integer

 

 

 

 

Foreign Key naar tabel TbSoortCorrespBinnen.dnkey

 

dnkeyinfoaanvraag

integer

 

 

 

 

Foreign Key naar tabel TbInfoAanvragen.dnkey.

 

dnkeymilinrichtingen

integer

 

 

 

 

Foreign Key naar tabel TbMilInrichtingen.dnkey.

 

dnkeymilvergunningen

integer

 

 

 

 

Foreign Key naar tabel TbMilVergunningen.dnkey.

 

 

dvhyperlink

varchar(256)

 

 

 

 

Verwijzing naar een bestand, map of URL

 

 

dddatering

timestamp

 

 

 

 

Datering van binnengekomen stuk.

 

 

dvextrainfo

varchar(2000)

 

 

 

 

Extra kolom bedoeld voor bijzonderheden.

 

dnkeyomgvergunningen

integer

 

 

 

 

Foreign Key naar tabel TbOmgVergunning.dnkey.

 

 

dvdmsdoccode

varchar(50)

 

 

 

 

De lokale code van het document zoals opgeslagen in het DMS.

 

 

dvintdoccode

varchar(40)

 

 

 

 

De integrale landelijke code van het document zoals opgeslagen in het DMS.

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

cfk_corbinnen_soort

dnkeysoortcorrbinnen

public.tbsoortcorrbinnen

dnkey

No Action

No Action

 

Immediate

 

cfk_correspb_bouwverg

dnkeybouwvergunningen

public.tbbouwvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_correspb_contactadressen

dnkeycontactadressen

public.tbcontactadressen

dnkey

No Action

No Action

 

Immediate

 

cfk_correspb_handhavingen

dnkeyhandhavingen

public.tbhandhavingen

dnkey

Cascade

No Action

 

Immediate

 

cfk_correspb_omgverg

dnkeyomgvergunningen

public.tbomgvergunning

dnkey

Cascade

No Action

 

Immediate

 

cfk_correspb_ovvergunningen

dnkeyovvergunningen

public.tbovvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_correspbinnen_bestplan

dnkeybestemmingsplannen

public.tbbestemmingsplannen

dnkey

Cascade

No Action

 

Immediate

 

cfk_correspbinnen_horecaverg

dnkeyhorecavergunningen

public.tbhorecavergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_correspbinnen_info

dnkeyinfoaanvraag

public.tbinfoaanvragen

dnkey

Cascade

No Action

 

Immediate

 

cfk_correspbinnen_milinricht

dnkeymilinrichtingen

public.tbmilinrichtingen

dnkey

Cascade

No Action

 

Immediate

 

cfk_correspbinnen_milverg

dnkeymilvergunningen

public.tbmilvergunningen

dnkey

Cascade

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

cnn_corrbinnen_datumb

dddatumbinnen IS NOT NULL

 

cnn_corrbinnen_srtcbinnen

dnkeysoortcorrbinnen IS NOT NULL

 

cnn_correspb_keyverg

((((((((((((((((dnkeybouwvergunningen IS NOT NULL) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhandhavingen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL)) OR (((((((((dnkeyovvergunningen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyhandhavingen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((((((dnkeyhandhavingen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((((((dnkeyhorecavergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((((((dnkeybestemmingsplannen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((((((dnkeymilvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((((((dnkeymilinrichtingen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((((((dnkeyomgvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((((((dnkeyinfoaanvraag IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL))

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbcorrespbinnen

btree

 

dnkey

 

idx_corbinnen_soort

btree

 

dnkeysoortcorrbinnen

 

 

 

idx_correspb_keyomgverg

btree

 

dnkeyomgvergunningen

 

 

 

idx_correspbinnen_datering

btree

 

dddatering

 

 

 

idx_correspbinnen_horecaverg

btree

 

dnkeyhorecavergunningen

 

 

 

idx_correspbinnen_keybestplan

btree

 

dnkeybestemmingsplannen

 

 

 

idx_correspbinnen_keyinfo

btree

 

dnkeyinfoaanvraag

 

 

 

idx_correspbinnen_milinricht

btree

 

dnkeymilinrichtingen

 

 

 

idx_correspbinnen_milverg

btree

 

dnkeymilvergunningen

 

 

 

idx_correspondb_keybouwverg

btree

 

dnkeybouwvergunningen

 

 

 

idx_correspondb_keycontactadre

btree

 

dnkeycontactadressen

 

 

 

idx_correspondb_keyhandhaving

btree

 

dnkeyhandhavingen

 

 

 

idx_correspondb_keyovvergunnin

btree

 

dnkeyovvergunningen

 

 

 

 

Triggers

There are no triggers for table tbcorrespbinnen

 

Rules

There are no rules for table tbcorrespbinnen

 

Referenced

There are no tables referenced by table tbcorrespbinnen

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.tbcorrespbinnen (
 dnkey SERIAL,
 dnkeybouwvergunningen INTEGER,
 dnkeyovvergunningen INTEGER,
 dnkeyhandhavingen INTEGER,
 dnkeycontactadressen INTEGER,
 dvarchiefnummer VARCHAR(25),
 dvomschrijving VARCHAR(200),
 dddatumbinnen TIMESTAMP WITHOUT TIME ZONE,
 dvonderwerp VARCHAR(25),
 dvkenmerk VARCHAR(25),
 dnkeyhorecavergunningen INTEGER,
 dnkeybestemmingsplannen INTEGER,
 dnkeysoortcorrbinnen INTEGER,
 dnkeyinfoaanvraag INTEGER,
 dnkeymilinrichtingen INTEGER,
 dnkeymilvergunningen INTEGER,
 dvhyperlink VARCHAR(256),
 dddatering TIMESTAMP WITHOUT TIME ZONE,
 dvextrainfo VARCHAR(2000),
 dnkeyomgvergunningen INTEGER,
 dvdmsdoccode VARCHAR(50),
 dvintdoccode VARCHAR(40),
 CONSTRAINT cpk_tbcorrespbinnen PRIMARY KEY(dnkey),
 CONSTRAINT cnn_corrbinnen_datumb CHECK (dddatumbinnen IS NOT NULL),
 CONSTRAINT cnn_corrbinnen_srtcbinnen CHECK (dnkeysoortcorrbinnen IS NOT NULL),
 CONSTRAINT cnn_correspb_keyverg CHECK (((((((((((((((((dnkeybouwvergunningen IS NOT NULL) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhandhavingen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL)) OR (((((((((dnkeyovvergunningen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyhandhavingen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((((((dnkeyhandhavingen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((((((dnkeyhorecavergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((((((dnkeybestemmingsplannen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((((((dnkeymilvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((((((dnkeymilinrichtingen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((((((dnkeyomgvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyinfoaanvraag IS NULL))) OR (((((((((dnkeyinfoaanvraag IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL))),
 CONSTRAINT cfk_corbinnen_soort FOREIGN KEY (dnkeysoortcorrbinnen)
   REFERENCES public.tbsoortcorrbinnen(dnkey)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_correspb_bouwverg FOREIGN KEY (dnkeybouwvergunningen)
   REFERENCES public.tbbouwvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_correspb_contactadressen FOREIGN KEY (dnkeycontactadressen)
   REFERENCES public.tbcontactadressen(dnkey)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_correspb_handhavingen FOREIGN KEY (dnkeyhandhavingen)
   REFERENCES public.tbhandhavingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_correspb_omgverg FOREIGN KEY (dnkeyomgvergunningen)
   REFERENCES public.tbomgvergunning(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_correspb_ovvergunningen FOREIGN KEY (dnkeyovvergunningen)
   REFERENCES public.tbovvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_correspbinnen_bestplan FOREIGN KEY (dnkeybestemmingsplannen)
   REFERENCES public.tbbestemmingsplannen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_correspbinnen_horecaverg FOREIGN KEY (dnkeyhorecavergunningen)
   REFERENCES public.tbhorecavergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_correspbinnen_info FOREIGN KEY (dnkeyinfoaanvraag)
   REFERENCES public.tbinfoaanvragen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_correspbinnen_milinricht FOREIGN KEY (dnkeymilinrichtingen)
   REFERENCES public.tbmilinrichtingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_correspbinnen_milverg FOREIGN KEY (dnkeymilvergunningen)
   REFERENCES public.tbmilvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
)
WITH (oids = false);

COMMENT ON TABLE public.tbcorrespbinnen
IS 'Tabel met binnengekomen correspondentie per vergunningsaanvraag of inrichting';

COMMENT ON COLUMN public.tbcorrespbinnen.dnkey
IS 'Primary key.';

COMMENT ON COLUMN public.tbcorrespbinnen.dnkeybouwvergunningen
IS 'Foreign key naar TbBouwvergunningen.dnkey';

COMMENT ON COLUMN public.tbcorrespbinnen.dnkeyovvergunningen
IS 'Foreign key naar TbOvVergunningen.dnkey';

COMMENT ON COLUMN public.tbcorrespbinnen.dnkeyhandhavingen
IS 'Foreign key naar TbHandhavingen.dnkey';

COMMENT ON COLUMN public.tbcorrespbinnen.dnkeycontactadressen
IS 'Foreign key naar TbContactadressen.dnkey';

COMMENT ON COLUMN public.tbcorrespbinnen.dvarchiefnummer
IS 'Archiefnummer, boekingsnummer.';

COMMENT ON COLUMN public.tbcorrespbinnen.dvomschrijving
IS 'Omschrijving van binnengekomen brief.';

COMMENT ON COLUMN public.tbcorrespbinnen.dddatumbinnen
IS 'Datum brief binnengekomen.';

COMMENT ON COLUMN public.tbcorrespbinnen.dvonderwerp
IS 'Vrij onderwerpkolom.';

COMMENT ON COLUMN public.tbcorrespbinnen.dvkenmerk
IS 'Briefkenmerk.';

COMMENT ON COLUMN public.tbcorrespbinnen.dnkeyhorecavergunningen
IS 'Foreign Key baar tabel TbHorecavergunningen.dnkey.';

COMMENT ON COLUMN public.tbcorrespbinnen.dnkeybestemmingsplannen
IS 'Foreign Key naar tabel TbBestemmingsplannen.dnkey.';

COMMENT ON COLUMN public.tbcorrespbinnen.dnkeysoortcorrbinnen
IS 'Foreign Key naar tabel TbSoortCorrespBinnen.dnkey';

COMMENT ON COLUMN public.tbcorrespbinnen.dnkeyinfoaanvraag
IS 'Foreign Key naar tabel TbInfoAanvragen.dnkey.';

COMMENT ON COLUMN public.tbcorrespbinnen.dnkeymilinrichtingen
IS 'Foreign Key naar tabel TbMilInrichtingen.dnkey.';

COMMENT ON COLUMN public.tbcorrespbinnen.dnkeymilvergunningen
IS 'Foreign Key naar tabel TbMilVergunningen.dnkey.';

COMMENT ON COLUMN public.tbcorrespbinnen.dvhyperlink
IS 'Verwijzing naar een bestand, map of URL';

COMMENT ON COLUMN public.tbcorrespbinnen.dddatering
IS 'Datering van binnengekomen stuk.';

COMMENT ON COLUMN public.tbcorrespbinnen.dvextrainfo
IS 'Extra kolom bedoeld voor bijzonderheden.';

COMMENT ON COLUMN public.tbcorrespbinnen.dnkeyomgvergunningen
IS 'Foreign Key naar tabel TbOmgVergunning.dnkey.';

COMMENT ON COLUMN public.tbcorrespbinnen.dvdmsdoccode
IS 'De lokale code van het document zoals opgeslagen in het DMS.';

COMMENT ON COLUMN public.tbcorrespbinnen.dvintdoccode
IS 'De integrale landelijke code van het document zoals opgeslagen in het DMS.';

CREATE INDEX idx_corbinnen_soort ON public.tbcorrespbinnen
 USING btree (dnkeysoortcorrbinnen);

CREATE INDEX idx_correspb_keyomgverg ON public.tbcorrespbinnen
 USING btree (dnkeyomgvergunningen);

CREATE INDEX idx_correspbinnen_datering ON public.tbcorrespbinnen
 USING btree (dddatering);

CREATE INDEX idx_correspbinnen_horecaverg ON public.tbcorrespbinnen
 USING btree (dnkeyhorecavergunningen);

CREATE INDEX idx_correspbinnen_keybestplan ON public.tbcorrespbinnen
 USING btree (dnkeybestemmingsplannen);

CREATE INDEX idx_correspbinnen_keyinfo ON public.tbcorrespbinnen
 USING btree (dnkeyinfoaanvraag);

CREATE INDEX idx_correspbinnen_milinricht ON public.tbcorrespbinnen
 USING btree (dnkeymilinrichtingen);

CREATE INDEX idx_correspbinnen_milverg ON public.tbcorrespbinnen
 USING btree (dnkeymilvergunningen);

CREATE INDEX idx_correspondb_keybouwverg ON public.tbcorrespbinnen
 USING btree (dnkeybouwvergunningen);

CREATE INDEX idx_correspondb_keycontactadre ON public.tbcorrespbinnen
 USING btree (dnkeycontactadressen);

CREATE INDEX idx_correspondb_keyhandhaving ON public.tbcorrespbinnen
 USING btree (dnkeyhandhavingen);

CREATE INDEX idx_correspondb_keyovvergunnin ON public.tbcorrespbinnen
 USING btree (dnkeyovvergunningen); 


This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50
 Previous topic Chapter index Next topic