Datadictionary OpenWave 3.1.34
 Previous topic Chapter index Next topic

Table: tbvrijevelden

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Hernieuwd in gebruik vanaf database versie 1.34. In deze tabel staan de kenmerken die toegevoegd zijn aan een zaak/inrichting

 

Columns

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbvrijevelden_dnkey_seq'::regclass)

Primary key.

 

dnkeybouwvergunningen

integer

 

 

 

 

Blijft deprecated. Voorheen de foreign key naar TbBouwvergunningen.dnkey.

 

dnkeyhandhavingen

integer

 

 

 

 

Foreign key naar Tbhandhavingen.dnkey.

 

dnkeyovvergunningen

integer

 

 

 

 

Foreign key naar TbOvvergunningen.dnkey.

 

dnkeyhorecavergunningen

integer

 

 

 

 

Blijft deprecated. Voorheen de foreign key naar tabel TbHorecaVergunningen.dnkey.

 

 

dvomschrijving

varchar(30)

 

 

 

 

Blijft deprecated. Voorheen de omschrijving (opgehaald uit TbVrijeVeldBetekenissen).

 

 

dvsoort

char(1)

 

 

 

 

Blijft deprecated. Wordt opgenomen in vwfrmvrijevelden (verwijst daar naar TbVrijeVeldBetekenissen.dvsoort).

 

 

dnvolgorde

integer

 

 

 

 

Blijft deprecated. Wordt opgenomen in vwfrmvrijevelden (verwijst daar naar TbVrijeVeldBetekenissen.dnvolgorde).

 

 

dvstring

varchar(200)

 

 

 

 

Waarde die men kan invoeren wanneer DvSoort Tekst is.

 

 

dddate

timestamp

 

 

 

 

Waarde die men kan invoeren wanneer DvSoort datum is.

 

 

dfnumber

double precision

 

 

 

 

Waarde die men kan invoeren wanneer DvSoort numeriek is.

 

 

dllogic

char(1)

 

 

 

'N'::bpchar

Waarde die men kan invoeren wanneer DvSoort Logisch is. Keuzes T, F of N maken (ja, nee, nog niet bekend)
default N

 

dnkeybestemmingsplannen

integer

 

 

 

 

Blijft deprecated. Voorheen de foreign key naar tabel TbBestemmingsplannen.dnkey.

 

dnkeyinfoaanvraag

integer

 

 

 

 

Blijft deprecated. Voorheen de foreign key naar tabel TbInfoAanvragen.dnkey.

 

dnkeymilinrichtingen

integer

 

 

 

 

Foreign key naar tabel TbMilInrichtingen.dnkey.

 

dnkeymilvergunningen

integer

 

 

 

 

Blijft deprecated. Voorheen de foreign key naar tabel TbMilVergunningen.dnkey.

 

dnkeyomgvergunningen

integer

 

 

 

 

Foreign key naar tabel TbomgVergunning.dnkey.

 

 

dvopmerking

varchar(2000)

 

 

 

 

Veld om tekstuele toelichting te kunnen geven bij kenmerk.

 

 

dvinvoerdropd

varchar(2000)

 

 

 

 

Weggeschreven waarde n.a.v. keuze van dropdown bij kenmerk.

 

 

ddvervaldatum

timestamp

 

 

 

 

Datum dat kenmerk vervallen is.

 

dnkeyvrijeveldbet

integer

 

 

 

 

Foreign key naar tbvrijeveldbetekenissen.dnkey.

 

Foreign Keys

Name

Columns

FK Table

FK Columns

Delete Action

Update Action

Deferrable

Check Time

Description

cfk_tbvrijevelden_handh

dnkeyhandhavingen

public.tbhandhavingen

dnkey

Cascade

No Action

 

Immediate

 

cfk_tbvrijveld_bestplan

dnkeybestemmingsplannen

public.tbbestemmingsplannen

dnkey

Cascade

No Action

 

Immediate

 

cfk_tbvrijveld_bouwverg

dnkeybouwvergunningen

public.tbbouwvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_tbvrijveld_horecaverg

dnkeyhorecavergunningen

public.tbhorecavergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_tbvrijveld_ovverg

dnkeyovvergunningen

public.tbovvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_vrijevelden_dnkeyvrijeveldbet

dnkeyvrijeveldbet

public.tbvrijeveldenbetekenissen

dnkey

No Action

No Action

 

Immediate

 

cfk_vrijevelden_milinricht

dnkeymilinrichtingen

public.tbmilinrichtingen

dnkey

Cascade

No Action

 

Immediate

 

cfk_vrijevelden_milverg

dnkeymilvergunningen

public.tbmilvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_vrijevelden_omgverg

dnkeyomgvergunningen

public.tbomgvergunning

dnkey

Cascade

No Action

 

Immediate

 

cfk_vrijveld_info

dnkeyinfoaanvraag

public.tbinfoaanvragen

dnkey

Cascade

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

chk_vrijevelden_dllogic

dllogic = ANY (ARRAY['T'::bpchar, 'F'::bpchar, 'N'::bpchar])

 

cnn_vrijevelden_dnkeyvrijeveldbet

dnkeyvrijeveldbet IS NOT NULL

 

cnn_vrijevelden_keyverg

((dnkeybouwvergunningen IS NOT NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeybestemmingsplannen IS NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeymilvergunningen 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 (dnkeymilinrichtingen IS NULL) AND (dnkeymilvergunningen 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 (dnkeymilinrichtingen IS NULL) AND (dnkeymilvergunningen 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 (dnkeymilinrichtingen IS NULL) AND (dnkeymilvergunningen 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 (dnkeymilinrichtingen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen 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 (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL) AND (dnkeybestemmingsplannen 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 (dnkeymilinrichtingen IS NULL) AND (dnkeyomgvergunningen IS NULL) AND (dnkeybestemmingsplannen 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 (dnkeymilinrichtingen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeybestemmingsplannen IS NULL) AND (dnkeyinfoaanvraag IS NULL)) OR ((dnkeyinfoaanvraag IS NOT NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeybouwvergunningen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeybestemmingsplannen IS NULL))

 

 

Indices

Name

Type

Function

Columns

Primary Key

Unique

Description

cpk_tbvrijevelden

btree

 

dnkey

 

idx_vrijeveldem_keybestplan

btree

 

dnkeybestemmingsplannen

 

 

 

idx_vrijeveldem_keybouwverg

btree

 

dnkeybouwvergunningen

 

 

 

idx_vrijeveldem_keyhandh

btree

 

dnkeyhandhavingen

 

 

 

idx_vrijeveldem_keyhorecaverg

btree

 

dnkeyhorecavergunningen

 

 

 

idx_vrijeveldem_keyovverg

btree

 

dnkeyovvergunningen

 

 

 

idx_vrijevelden_keyinfo

btree

 

dnkeyinfoaanvraag

 

 

 

idx_vrijevelden_keymilinr

btree

 

dnkeymilinrichtingen

 

 

 

idx_vrijevelden_keymilverg

btree

 

dnkeymilvergunningen

 

 

 

 

Triggers

There are no triggers for table tbvrijevelden

 

Rules

There are no rules for table tbvrijevelden

 

Policies

There are no policies for table tbvrijevelden

 

Referenced

There are no tables referenced by table tbvrijevelden

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.tbvrijevelden (
 dnkey SERIAL,
 dnkeybouwvergunningen INTEGER STORAGE PLAIN,
 dnkeyhandhavingen INTEGER STORAGE PLAIN,
 dnkeyovvergunningen INTEGER STORAGE PLAIN,
 dnkeyhorecavergunningen INTEGER STORAGE PLAIN,
 dvomschrijving VARCHAR(30),
 dvsoort CHAR(1),
 dnvolgorde INTEGER STORAGE PLAIN,
 dvstring VARCHAR(200),
 dddate TIMESTAMP WITHOUT TIME ZONE STORAGE PLAIN,
 dfnumber DOUBLE PRECISION STORAGE PLAIN,
 dllogic CHAR(1) DEFAULT 'N'::bpchar,
 dnkeybestemmingsplannen INTEGER STORAGE PLAIN,
 dnkeyinfoaanvraag INTEGER STORAGE PLAIN,
 dnkeymilinrichtingen INTEGER STORAGE PLAIN,
 dnkeymilvergunningen INTEGER STORAGE PLAIN,
 dnkeyomgvergunningen INTEGER STORAGE PLAIN,
 dvopmerking VARCHAR(2000),
 dvinvoerdropd VARCHAR(2000),
 ddvervaldatum TIMESTAMP WITHOUT TIME ZONE STORAGE PLAIN,
 dnkeyvrijeveldbet INTEGER STORAGE PLAIN,
 CONSTRAINT cpk_tbvrijevelden PRIMARY KEY(dnkey),
 CONSTRAINT chk_vrijevelden_dllogic CHECK (dllogic = ANY (ARRAY['T'::bpchar, 'F'::bpchar, 'N'::bpchar])),
 CONSTRAINT cnn_vrijevelden_dnkeyvrijeveldbet CHECK (dnkeyvrijeveldbet IS NOT NULL),
 CONSTRAINT cnn_vrijevelden_keyverg CHECK (((dnkeybouwvergunningen IS NOT NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeybestemmingsplannen IS NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeymilvergunningen 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 (dnkeymilinrichtingen IS NULL) AND (dnkeymilvergunningen 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 (dnkeymilinrichtingen IS NULL) AND (dnkeymilvergunningen 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 (dnkeymilinrichtingen IS NULL) AND (dnkeymilvergunningen 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 (dnkeymilinrichtingen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen 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 (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL) AND (dnkeybestemmingsplannen 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 (dnkeymilinrichtingen IS NULL) AND (dnkeyomgvergunningen IS NULL) AND (dnkeybestemmingsplannen 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 (dnkeymilinrichtingen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeybestemmingsplannen IS NULL) AND (dnkeyinfoaanvraag IS NULL)) OR ((dnkeyinfoaanvraag IS NOT NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeybouwvergunningen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeybestemmingsplannen IS NULL))),
 CONSTRAINT cfk_tbvrijevelden_handh FOREIGN KEY (dnkeyhandhavingen)
   REFERENCES public.tbhandhavingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_tbvrijveld_bestplan FOREIGN KEY (dnkeybestemmingsplannen)
   REFERENCES public.tbbestemmingsplannen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_tbvrijveld_bouwverg FOREIGN KEY (dnkeybouwvergunningen)
   REFERENCES public.tbbouwvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_tbvrijveld_horecaverg FOREIGN KEY (dnkeyhorecavergunningen)
   REFERENCES public.tbhorecavergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_tbvrijveld_ovverg FOREIGN KEY (dnkeyovvergunningen)
   REFERENCES public.tbovvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_vrijevelden_dnkeyvrijeveldbet FOREIGN KEY (dnkeyvrijeveldbet)
   REFERENCES public.tbvrijeveldenbetekenissen(dnkey)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_vrijevelden_milinricht FOREIGN KEY (dnkeymilinrichtingen)
   REFERENCES public.tbmilinrichtingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_vrijevelden_milverg FOREIGN KEY (dnkeymilvergunningen)
   REFERENCES public.tbmilvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_vrijevelden_omgverg FOREIGN KEY (dnkeyomgvergunningen)
   REFERENCES public.tbomgvergunning(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_vrijveld_info FOREIGN KEY (dnkeyinfoaanvraag)
   REFERENCES public.tbinfoaanvragen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) ;

COMMENT ON TABLE public.tbvrijevelden
IS 'Hernieuwd in gebruik vanaf database versie 1.34. In deze tabel staan de kenmerken die toegevoegd zijn aan een zaak/inrichting';

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

COMMENT ON COLUMN public.tbvrijevelden.dnkeybouwvergunningen
IS 'Blijft deprecated. Voorheen de foreign key naar TbBouwvergunningen.dnkey.';

COMMENT ON COLUMN public.tbvrijevelden.dnkeyhandhavingen
IS 'Foreign key naar Tbhandhavingen.dnkey.';

COMMENT ON COLUMN public.tbvrijevelden.dnkeyovvergunningen
IS 'Foreign key naar TbOvvergunningen.dnkey.';

COMMENT ON COLUMN public.tbvrijevelden.dnkeyhorecavergunningen
IS 'Blijft deprecated. Voorheen de foreign key naar tabel TbHorecaVergunningen.dnkey.';

COMMENT ON COLUMN public.tbvrijevelden.dvomschrijving
IS 'Blijft deprecated. Voorheen de omschrijving (opgehaald uit TbVrijeVeldBetekenissen).';

COMMENT ON COLUMN public.tbvrijevelden.dvsoort
IS 'Blijft deprecated. Wordt opgenomen in vwfrmvrijevelden (verwijst daar naar TbVrijeVeldBetekenissen.dvsoort).';

COMMENT ON COLUMN public.tbvrijevelden.dnvolgorde
IS 'Blijft deprecated. Wordt opgenomen in vwfrmvrijevelden (verwijst daar naar TbVrijeVeldBetekenissen.dnvolgorde).';

COMMENT ON COLUMN public.tbvrijevelden.dvstring
IS 'Waarde die men kan invoeren wanneer DvSoort Tekst is.';

COMMENT ON COLUMN public.tbvrijevelden.dddate
IS 'Waarde die men kan invoeren wanneer DvSoort datum is.';

COMMENT ON COLUMN public.tbvrijevelden.dfnumber
IS 'Waarde die men kan invoeren wanneer DvSoort numeriek is.';

COMMENT ON COLUMN public.tbvrijevelden.dllogic
IS 'Waarde die men kan invoeren wanneer DvSoort Logisch is. Keuzes T, F of N maken (ja, nee, nog niet bekend)
default N';

COMMENT ON COLUMN public.tbvrijevelden.dnkeybestemmingsplannen
IS 'Blijft deprecated. Voorheen de foreign key naar tabel TbBestemmingsplannen.dnkey.';

COMMENT ON COLUMN public.tbvrijevelden.dnkeyinfoaanvraag
IS 'Blijft deprecated. Voorheen de foreign key naar tabel TbInfoAanvragen.dnkey.';

COMMENT ON COLUMN public.tbvrijevelden.dnkeymilinrichtingen
IS 'Foreign key naar tabel TbMilInrichtingen.dnkey.';

COMMENT ON COLUMN public.tbvrijevelden.dnkeymilvergunningen
IS 'Blijft deprecated. Voorheen de foreign key naar tabel TbMilVergunningen.dnkey.';

COMMENT ON COLUMN public.tbvrijevelden.dnkeyomgvergunningen
IS 'Foreign key naar tabel TbomgVergunning.dnkey.';

COMMENT ON COLUMN public.tbvrijevelden.dvopmerking
IS 'Veld om tekstuele toelichting te kunnen geven bij kenmerk.';

COMMENT ON COLUMN public.tbvrijevelden.dvinvoerdropd
IS 'Weggeschreven waarde n.a.v. keuze van dropdown bij kenmerk.';

COMMENT ON COLUMN public.tbvrijevelden.ddvervaldatum
IS 'Datum dat kenmerk vervallen is.';

COMMENT ON COLUMN public.tbvrijevelden.dnkeyvrijeveldbet
IS 'Foreign key naar tbvrijeveldbetekenissen.dnkey.';

CREATE INDEX idx_vrijeveldem_keybestplan ON public.tbvrijevelden
 USING btree (dnkeybestemmingsplannen);

CREATE INDEX idx_vrijeveldem_keybouwverg ON public.tbvrijevelden
 USING btree (dnkeybouwvergunningen);

CREATE INDEX idx_vrijeveldem_keyhandh ON public.tbvrijevelden
 USING btree (dnkeyhandhavingen);

CREATE INDEX idx_vrijeveldem_keyhorecaverg ON public.tbvrijevelden
 USING btree (dnkeyhorecavergunningen);

CREATE INDEX idx_vrijeveldem_keyovverg ON public.tbvrijevelden
 USING btree (dnkeyovvergunningen);

CREATE INDEX idx_vrijevelden_keyinfo ON public.tbvrijevelden
 USING btree (dnkeyinfoaanvraag);

CREATE INDEX idx_vrijevelden_keymilinr ON public.tbvrijevelden
 USING btree (dnkeymilinrichtingen);

CREATE INDEX idx_vrijevelden_keymilverg ON public.tbvrijevelden
 USING btree (dnkeymilvergunningen); 


This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 18/05/2026 15:10
 Previous topic Chapter index Next topic