Datadictionary OpenWave 3.1.11
 Previous topic Chapter index Next topic

Table: tbvrijevelden

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Tabel met vrije veld labels en inhoud per vergunning

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbvrijevelden_dnkey_seq'::regclass)

Primary key.

 

dnkeybouwvergunningen

integer

 

 

 

 

Foreign key naar TbBouwvergunningen.dnkey.

 

dnkeyhandhavingen

integer

 

 

 

 

Foreign key naar Tbhandhavingen.dnkey.

 

dnkeyovvergunningen

integer

 

 

 

 

Foreign key naar TbOvvergunningen.dnkey.

 

dnkeyhorecavergunningen

integer

 

 

 

 

Foreign key naar tabel TbHorecaVergunningen.dnkey.

 

 

dvomschrijving

varchar(30)

 

 

 

 

Omschrijving (opgehaald uit TbVrijeVeldBetekenissen).

 

 

dvsoort

char(1)

 

 

 

 

Type vrije veld waarde. (opgehaald uit TbVrijeVeldBetekenissen).

 

 

dnvolgorde

integer

 

 

 

 

Volgorde van de vrije velden op het scherm (opgehaald uit TbVrijeVeld-Betekenissen).

 

 

dvstring

varchar(200)

 

 

 

 

Waarde die gebruiker kan invoeren wanneer DvSoort Tekst is.

 

 

dddate

timestamp

 

 

 

 

Waarde die gebruiker kan invoeren wanneer DvSoort datum is.

 

 

dfnumber

double precision

 

 

 

 

Waarde die gebruiker kan invoeren wanneer DvSoort numeriek is.

 

 

dllogic

char(1)

 

 

 

 

Waarde die gebruiker kan invoeren wanneer DvSoort Logisch is.

 

dnkeybestemmingsplannen

integer

 

 

 

 

Foreign key naar tabel TbBestemmingsplannen.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.

 

dnkeyomgvergunningen

integer

 

 

 

 

Foreign key naar tabel TbomgVergunning,Dnkey.

 

Foreign Keys

Name

Fields

FK Table

FK Fields

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_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

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

Fields

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

 

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,
 dnkeyhandhavingen INTEGER,
 dnkeyovvergunningen INTEGER,
 dnkeyhorecavergunningen INTEGER,
 dvomschrijving VARCHAR(30),
 dvsoort CHAR(1),
 dnvolgorde INTEGER,
 dvstring VARCHAR(200),
 dddate TIMESTAMP WITHOUT TIME ZONE,
 dfnumber DOUBLE PRECISION,
 dllogic CHAR(1),
 dnkeybestemmingsplannen INTEGER,
 dnkeyinfoaanvraag INTEGER,
 dnkeymilinrichtingen INTEGER,
 dnkeymilvergunningen INTEGER,
 dnkeyomgvergunningen INTEGER,
 CONSTRAINT cpk_tbvrijevelden PRIMARY KEY(dnkey),
 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_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
)
WITH (oids = false);

COMMENT ON TABLE public.tbvrijevelden
IS 'Tabel met vrije veld labels en inhoud per vergunning';

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

COMMENT ON COLUMN public.tbvrijevelden.dnkeybouwvergunningen
IS '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 'Foreign key naar tabel TbHorecaVergunningen.dnkey.';

COMMENT ON COLUMN public.tbvrijevelden.dvomschrijving
IS 'Omschrijving (opgehaald uit TbVrijeVeldBetekenissen).';

COMMENT ON COLUMN public.tbvrijevelden.dvsoort
IS 'Type vrije veld waarde. (opgehaald uit TbVrijeVeldBetekenissen).';

COMMENT ON COLUMN public.tbvrijevelden.dnvolgorde
IS 'Volgorde van de vrije velden op het scherm (opgehaald uit TbVrijeVeld-Betekenissen).';

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

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

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

COMMENT ON COLUMN public.tbvrijevelden.dllogic
IS 'Waarde die gebruiker kan invoeren wanneer DvSoort Logisch is.';

COMMENT ON COLUMN public.tbvrijevelden.dnkeybestemmingsplannen
IS 'Foreign key naar tabel TbBestemmingsplannen.Dnkey.';

COMMENT ON COLUMN public.tbvrijevelden.dnkeyinfoaanvraag
IS '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 'Foreign key naar tabel TbMilVergunningen.Dnkey.';

COMMENT ON COLUMN public.tbvrijevelden.dnkeyomgvergunningen
IS 'Foreign key naar tabel TbomgVergunning,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.pgsqlmanager.com) at 22-2-2017 10:50
 Previous topic Chapter index Next topic