Datadictionary OpenWave 3.1.11
 Previous topic Chapter index Next topic

Table: tbextramemo

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Tabel bedoeld voor memos die te groot zijn om direct bij een basistabel van een vergunning te worden opgeslagen

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbextramemo_dnkey_seq'::regclass)

Primary key.

 

dnkeyhandhavingen

integer

 

 

 

 

Foreign key naar Tbhandhavingen.dnkey

 

dnkeybouwvergunningen

integer

 

 

 

 

Foreign key naar TbBouwvergunningen.dnkey

 

dnkeyovvergunningen

integer

 

 

 

 

Foreign key naar TbOvVergunningen.dnkey

 

dnkeyhorecavergunningen

integer

 

 

 

 

Foreign key naar tabel TbHoreca- Vergunningen.dnkey.

 

dnkeybestemmingsplannen

integer

 

 

 

 

Foreign key naar tabel TbBestemingsplannen.Dnkey.

 

dnkeyinfoaanvraag

integer

 

 

 

 

Foreign key naar tabel TbInfoAanvragen.Dnkey.

 

dnkeyparent

integer

 

 

 

 

Foreign key naar TbExtramemo.Dnkey.

 

 

dvextramemo

varchar(4000)

 

 

 

 

De - gezipte - memotekst.

 

dnkeymilinrichtingen

integer

 

 

 

 

Foreign key naar TbMilInrichtingen.dnkey.

 

dnkeymilvergunningen

integer

 

 

 

 

Foreign key naar TbMilVergunningen.dnkey.

 

dnkeyomgvergunningen

integer

 

 

 

 

Foreign key naar TbOmgvergunning.dnkey.

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

cfk_extramemo_milinricht

dnkeymilinrichtingen

public.tbmilinrichtingen

dnkey

Cascade

No Action

 

Immediate

 

cfk_extramemo_milverg

dnkeymilvergunningen

public.tbmilvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_tbextramemo_tbbestplan

dnkeybestemmingsplannen

public.tbbestemmingsplannen

dnkey

Cascade

No Action

 

Immediate

 

cfk_tbextramemo_tbbouwverg

dnkeybouwvergunningen

public.tbbouwvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_tbextramemo_tbextramemo

dnkeyparent

public.tbextramemo

dnkey

No Action

No Action

 

Immediate

 

cfk_tbextramemo_tbhandh

dnkeyhandhavingen

public.tbhandhavingen

dnkey

Cascade

No Action

 

Immediate

 

cfk_tbextramemo_tbhorverg

dnkeyhorecavergunningen

public.tbhorecavergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_tbextramemo_tbinfo

dnkeyinfoaanvraag

public.tbinfoaanvragen

dnkey

Cascade

No Action

 

Immediate

 

cfk_tbextramemo_tbomgverg

dnkeyomgvergunningen

public.tbomgvergunning

dnkey

Cascade

No Action

 

Immediate

 

cfk_tbextramemo_tbovverg

dnkeyovvergunningen

public.tbovvergunningen

dnkey

Cascade

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

cnn_extramemo_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 (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilvergunningen 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 (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen 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 (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen 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 (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL))

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbextramemo

btree

 

dnkey

 

idx_extramemo_keybouwverg

btree

 

dnkeybouwvergunningen

 

 

 

idx_extramemo_keyhandh

btree

 

dnkeyhandhavingen

 

 

 

idx_extramemo_keyhorverg

btree

 

dnkeyhorecavergunningen

 

 

 

idx_extramemo_keyinfo

btree

 

dnkeyinfoaanvraag

 

 

 

idx_extramemo_keyomgverg

btree

 

dnkeyomgvergunningen

 

 

 

idx_extramemo_keyovverg

btree

 

dnkeyovvergunningen

 

 

 

idx_extramemo_keyparent

btree

 

dnkeyparent

 

 

 

idx_extramemo_milinricht

btree

 

dnkeymilinrichtingen

 

 

 

idx_extramemo_milverg

btree

 

dnkeymilvergunningen

 

 

 

 

Triggers

There are no triggers for table tbextramemo

 

Rules

There are no rules for table tbextramemo

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

tbextramemo

public

cfk_tbextramemo_tbextramemo

dnkeyparent

public.tbextramemo

dnkey

No Action

No Action

 

Immediate

 

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.tbextramemo (
 dnkey SERIAL,
 dnkeyhandhavingen INTEGER,
 dnkeybouwvergunningen INTEGER,
 dnkeyovvergunningen INTEGER,
 dnkeyhorecavergunningen INTEGER,
 dnkeybestemmingsplannen INTEGER,
 dnkeyinfoaanvraag INTEGER,
 dnkeyparent INTEGER,
 dvextramemo VARCHAR(4000),
 dnkeymilinrichtingen INTEGER,
 dnkeymilvergunningen INTEGER,
 dnkeyomgvergunningen INTEGER,
 CONSTRAINT cpk_tbextramemo PRIMARY KEY(dnkey),
 CONSTRAINT cnn_extramemo_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 (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilvergunningen 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 (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen 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 (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen 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 (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL))),
 CONSTRAINT cfk_extramemo_milinricht FOREIGN KEY (dnkeymilinrichtingen)
   REFERENCES public.tbmilinrichtingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_extramemo_milverg FOREIGN KEY (dnkeymilvergunningen)
   REFERENCES public.tbmilvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_tbextramemo_tbbestplan FOREIGN KEY (dnkeybestemmingsplannen)
   REFERENCES public.tbbestemmingsplannen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_tbextramemo_tbbouwverg FOREIGN KEY (dnkeybouwvergunningen)
   REFERENCES public.tbbouwvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_tbextramemo_tbextramemo FOREIGN KEY (dnkeyparent)
   REFERENCES public.tbextramemo(dnkey)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_tbextramemo_tbhandh FOREIGN KEY (dnkeyhandhavingen)
   REFERENCES public.tbhandhavingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_tbextramemo_tbhorverg FOREIGN KEY (dnkeyhorecavergunningen)
   REFERENCES public.tbhorecavergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_tbextramemo_tbinfo FOREIGN KEY (dnkeyinfoaanvraag)
   REFERENCES public.tbinfoaanvragen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_tbextramemo_tbomgverg FOREIGN KEY (dnkeyomgvergunningen)
   REFERENCES public.tbomgvergunning(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_tbextramemo_tbovverg FOREIGN KEY (dnkeyovvergunningen)
   REFERENCES public.tbovvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
)
WITH (oids = false);

COMMENT ON TABLE public.tbextramemo
IS 'Tabel bedoeld voor memos die te groot zijn om direct bij een basistabel van een vergunning te worden opgeslagen';

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

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

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

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

COMMENT ON COLUMN public.tbextramemo.dnkeyhorecavergunningen
IS 'Foreign key naar tabel TbHoreca- Vergunningen.dnkey.';

COMMENT ON COLUMN public.tbextramemo.dnkeybestemmingsplannen
IS 'Foreign key naar tabel TbBestemingsplannen.Dnkey.';

COMMENT ON COLUMN public.tbextramemo.dnkeyinfoaanvraag
IS 'Foreign key naar tabel TbInfoAanvragen.Dnkey.';

COMMENT ON COLUMN public.tbextramemo.dnkeyparent
IS 'Foreign key naar TbExtramemo.Dnkey.';

COMMENT ON COLUMN public.tbextramemo.dvextramemo
IS 'De - gezipte - memotekst.';

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

COMMENT ON COLUMN public.tbextramemo.dnkeymilvergunningen
IS 'Foreign key naar TbMilVergunningen.dnkey.';

COMMENT ON COLUMN public.tbextramemo.dnkeyomgvergunningen
IS 'Foreign key naar TbOmgvergunning.dnkey.';

CREATE INDEX idx_extramemo_keybouwverg ON public.tbextramemo
 USING btree (dnkeybouwvergunningen);

CREATE INDEX idx_extramemo_keyhandh ON public.tbextramemo
 USING btree (dnkeyhandhavingen);

CREATE INDEX idx_extramemo_keyhorverg ON public.tbextramemo
 USING btree (dnkeyhorecavergunningen);

CREATE INDEX idx_extramemo_keyinfo ON public.tbextramemo
 USING btree (dnkeyinfoaanvraag);

CREATE INDEX idx_extramemo_keyomgverg ON public.tbextramemo
 USING btree (dnkeyomgvergunningen);

CREATE INDEX idx_extramemo_keyovverg ON public.tbextramemo
 USING btree (dnkeyovvergunningen);

CREATE INDEX idx_extramemo_keyparent ON public.tbextramemo
 USING btree (dnkeyparent);

CREATE INDEX idx_extramemo_milinricht ON public.tbextramemo
 USING btree (dnkeymilinrichtingen);

CREATE INDEX idx_extramemo_milverg ON public.tbextramemo
 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