Datadictionary OpenWave 3.1.11
 Previous topic Chapter index Next topic

Table: tbcorrespondentie

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Tabel met uitgaande correspondentie per vergunningsaanvraag of inrichting

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbcorrespondentie_dnkey_seq'::regclass)

Primary key.

 

dnkeycontactadressen

integer

 

 

 

 

Foreign key naar TbContactadressen.dnkey

 

dnkeyhandhavingen

integer

 

 

 

 

Foreign key naar TbHandhavingen.dnkey

 

dnkeybouwvergunningen

integer

 

 

 

 

Foreign key naar TbBouwvergunningen.dnkey

 

dnkeyovvergunningen

integer

 

 

 

 

Foreign key naar TbOvVergunningen.dnkey

 

dnkeydocumenten

integer

 

 

 

 

Foreign key naar TbDocumenten.dnkey

 

 

ddbriefdatum

timestamp

 

 

 

 

Datum dat bepaald document is verzonden.

 

 

dvdocfilenaam

varchar(255)

 

 

 

 

Directory en bestandsnaam waaronder een speciefiek document is opgeslagen.

 

dnkeyhorecavergunningen

integer

 

 

 

 

Foreign Key naar tabel TbHorecavergunningen.dnkey.

 

dnkeybestemmingsplannen

integer

 

 

 

 

Foreign Key naar tabel TbBestemmingsplannen.dnkey.

 

 

dvonderwerp

varchar(50)

 

 

 

 

Onderwerp van uitgaande brief.

 

 

dlverstuurd

char(1)

 

 

 

'N'::bpchar

T of F of N. T betekent is de brief daadwerkelijk verstuurd. N betekent weet niet.

 

dnkeyinfoaanvraag

integer

 

 

 

 

Foreign Key naar tabel TbInfoAanvragen.dnkey

 

 

dvkenmerk

varchar(20)

 

 

 

 

Kenmerk van uitgaande brief.

 

dnkeymilinrichtingen

integer

 

 

 

 

Foreign Key naar tabel TbMilInrichtingen.dnkey.

 

dnkeymilvergunningen

integer

 

 

 

 

Foreign Key naar tabel TbMilVergunningen.dnkey.

 

dnkeyinspbezoeken

integer

 

 

 

 

Foreign key naar tbinspbezoeken.dnkey.

 

dnkeyadviezen

integer

 

 

 

 

Foreign key naar tbadviezen.dnkey.

 

 

dvextrainfo

varchar(2000)

 

 

 

 

Extra kolom bedoeld bijv voor vermelden van bijlagen, maar ook als body voor een email

 

dnkeyomgvergunningen

integer

 

 

 

 

Foreign Key naar tabel TbOmgVergunning.dnkey.

 

dvcodeeigenaar

char(5)

 

 

 

 

Foreign key naar Tbmedewerkers.dvcode. Hiermee wordt de eigenaar van het document bedoeld. (koppeling docuemnten naar DMS).

 

 

dvdmsdoccode

varchar(40)

 

 

 

 

De lokale identificatiecode van het document in het DMS.

 

dnkeyklachten

integer

 

 

 

 

Foreign key naar tbklachten.dnkey.

 

 

dvdmskenmerk

varchar(200)

 

 

 

 

DMS-hyperlink naar het document

 

 

dvdmsbarcode

varchar(50)

 

 

 

 

DMS-barcode van het document

 

 

dvintdoccode

varchar(40)

 

 

 

 

De toegekende integrale landelijke identificatiecode van het document in het DMS.

 

 

dlinhoudisnaardms

char(1)

 

 

 

'F'::bpchar

T of F. Indien T dan is daadwerkelijk een document onder dvintdoccode opgeslagen in het DMS.

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

cfk_corresp_bestplan

dnkeybestemmingsplannen

public.tbbestemmingsplannen

dnkey

Cascade

No Action

 

Immediate

 

cfk_corresp_bouwverg

dnkeybouwvergunningen

public.tbbouwvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_corresp_codeeigenaar

dvcodeeigenaar

public.tbmedewerkers

dvcode

No Action

No Action

 

Immediate

 

cfk_corresp_contactadressen

dnkeycontactadressen

public.tbcontactadressen

dnkey

No Action

No Action

 

Immediate

 

cfk_corresp_documenten

dnkeydocumenten

public.tbdocumenten

dnkey

No Action

No Action

 

Immediate

 

cfk_corresp_handhavingen

dnkeyhandhavingen

public.tbhandhavingen

dnkey

Cascade

No Action

 

Immediate

 

cfk_corresp_info

dnkeyinfoaanvraag

public.tbinfoaanvragen

dnkey

Cascade

No Action

 

Immediate

 

cfk_corresp_keyklachten

dnkeyklachten

public.tbklachten

dnkey

No Action

No Action

 

Immediate

 

cfk_corresp_omgverg

dnkeyomgvergunningen

public.tbomgvergunning

dnkey

Cascade

No Action

 

Immediate

 

cfk_corresp_ovvergunningen

dnkeyovvergunningen

public.tbovvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_correspondentie_horecaverg

dnkeyhorecavergunningen

public.tbhorecavergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_correspondentie_milinricht

dnkeymilinrichtingen

public.tbmilinrichtingen

dnkey

Cascade

No Action

 

Immediate

 

cfk_correspondentie_milverg

dnkeymilvergunningen

public.tbmilvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_tbcorresp_keyadviezen

dnkeyadviezen

public.tbadviezen

dnkey

No Action

No Action

 

Immediate

 

cfk_tbcorresp_keyinspbezoeken

dnkeyinspbezoeken

public.tbinspbezoeken

dnkey

No Action

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

chk_corresp_dlverstuurd

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

 

chk_tbcorresp_dlinhisnaardms

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

 

cnn_corresp_dlverstuurd

dlverstuurd IS NOT NULL

 

cnn_corresp_keydocum

dnkeydocumenten IS NOT NULL

 

cnn_corresp_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))

 

cnn_tbcorresp_dlinhisnaardms

dlinhoudisnaardms IS NOT NULL

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbcorrespondentie

btree

 

dnkey

 

idx_corresp_codeeigenaar

btree

 

dvcodeeigenaar

 

 

 

idx_corresp_keybestplan

btree

 

dnkeybestemmingsplannen

 

 

 

idx_corresp_keyinfo

btree

 

dnkeyinfoaanvraag

 

 

 

idx_corresp_keyklachten

btree

 

dnkeyklachten

 

 

 

idx_corresp_keyomgverg

btree

 

dnkeyomgvergunningen

 

 

 

idx_correspond_keybouwverg

btree

 

dnkeybouwvergunningen

 

 

 

idx_correspond_keycontactadres

btree

 

dnkeycontactadressen

 

 

 

idx_correspond_keydocumenten

btree

 

dnkeydocumenten

 

 

 

idx_correspond_keyhandhaving

btree

 

dnkeyhandhavingen

 

 

 

idx_correspond_keyovvergunning

btree

 

dnkeyovvergunningen

 

 

 

idx_correspondentie_briefdatum

btree

 

ddbriefdatum

 

 

 

idx_correspondentie_horecaverg

btree

 

dnkeyhorecavergunningen

 

 

 

idx_correspondentie_milinricht

btree

 

dnkeymilinrichtingen

 

 

 

idx_correspondentie_milverg

btree

 

dnkeymilvergunningen

 

 

 

 

Triggers

There are no triggers for table tbcorrespondentie

 

Rules

There are no rules for table tbcorrespondentie

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

tbcorafschriften

public

cfk_tbcorafschr_keycorresp

dnkeycorrespondentie

public.tbcorrespondentie

dnkey

Cascade

No Action

 

Immediate

 

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.tbcorrespondentie (
 dnkey SERIAL,
 dnkeycontactadressen INTEGER,
 dnkeyhandhavingen INTEGER,
 dnkeybouwvergunningen INTEGER,
 dnkeyovvergunningen INTEGER,
 dnkeydocumenten INTEGER,
 ddbriefdatum TIMESTAMP WITHOUT TIME ZONE,
 dvdocfilenaam VARCHAR(255),
 dnkeyhorecavergunningen INTEGER,
 dnkeybestemmingsplannen INTEGER,
 dvonderwerp VARCHAR(50),
 dlverstuurd CHAR(1) DEFAULT 'N'::bpchar,
 dnkeyinfoaanvraag INTEGER,
 dvkenmerk VARCHAR(20),
 dnkeymilinrichtingen INTEGER,
 dnkeymilvergunningen INTEGER,
 dnkeyinspbezoeken INTEGER,
 dnkeyadviezen INTEGER,
 dvextrainfo VARCHAR(2000),
 dnkeyomgvergunningen INTEGER,
 dvcodeeigenaar CHAR(5),
 dvdmsdoccode VARCHAR(40),
 dnkeyklachten INTEGER,
 dvdmskenmerk VARCHAR(200),
 dvdmsbarcode VARCHAR(50),
 dvintdoccode VARCHAR(40),
 dlinhoudisnaardms CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tbcorrespondentie PRIMARY KEY(dnkey),
 CONSTRAINT chk_corresp_dlverstuurd CHECK (dlverstuurd = ANY (ARRAY['T'::bpchar, 'F'::bpchar, 'N'::bpchar])),
 CONSTRAINT chk_tbcorresp_dlinhisnaardms CHECK (dlinhoudisnaardms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT cnn_corresp_dlverstuurd CHECK (dlverstuurd IS NOT NULL),
 CONSTRAINT cnn_corresp_keydocum CHECK (dnkeydocumenten IS NOT NULL),
 CONSTRAINT cnn_corresp_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 cnn_tbcorresp_dlinhisnaardms CHECK (dlinhoudisnaardms IS NOT NULL),
 CONSTRAINT cfk_corresp_bestplan FOREIGN KEY (dnkeybestemmingsplannen)
   REFERENCES public.tbbestemmingsplannen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_corresp_bouwverg FOREIGN KEY (dnkeybouwvergunningen)
   REFERENCES public.tbbouwvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_corresp_codeeigenaar FOREIGN KEY (dvcodeeigenaar)
   REFERENCES public.tbmedewerkers(dvcode)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_corresp_contactadressen FOREIGN KEY (dnkeycontactadressen)
   REFERENCES public.tbcontactadressen(dnkey)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_corresp_documenten FOREIGN KEY (dnkeydocumenten)
   REFERENCES public.tbdocumenten(dnkey)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_corresp_handhavingen FOREIGN KEY (dnkeyhandhavingen)
   REFERENCES public.tbhandhavingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_corresp_info FOREIGN KEY (dnkeyinfoaanvraag)
   REFERENCES public.tbinfoaanvragen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_corresp_keyklachten FOREIGN KEY (dnkeyklachten)
   REFERENCES public.tbklachten(dnkey)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_corresp_omgverg FOREIGN KEY (dnkeyomgvergunningen)
   REFERENCES public.tbomgvergunning(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_corresp_ovvergunningen FOREIGN KEY (dnkeyovvergunningen)
   REFERENCES public.tbovvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_correspondentie_horecaverg FOREIGN KEY (dnkeyhorecavergunningen)
   REFERENCES public.tbhorecavergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_correspondentie_milinricht FOREIGN KEY (dnkeymilinrichtingen)
   REFERENCES public.tbmilinrichtingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_correspondentie_milverg FOREIGN KEY (dnkeymilvergunningen)
   REFERENCES public.tbmilvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_tbcorresp_keyadviezen FOREIGN KEY (dnkeyadviezen)
   REFERENCES public.tbadviezen(dnkey)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_tbcorresp_keyinspbezoeken FOREIGN KEY (dnkeyinspbezoeken)
   REFERENCES public.tbinspbezoeken(dnkey)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE
)
WITH (oids = false);

COMMENT ON TABLE public.tbcorrespondentie
IS 'Tabel met uitgaande correspondentie per vergunningsaanvraag of inrichting';

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

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

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

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

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

COMMENT ON COLUMN public.tbcorrespondentie.dnkeydocumenten
IS 'Foreign key naar TbDocumenten.dnkey';

COMMENT ON COLUMN public.tbcorrespondentie.ddbriefdatum
IS 'Datum dat bepaald document is verzonden.';

COMMENT ON COLUMN public.tbcorrespondentie.dvdocfilenaam
IS 'Directory en bestandsnaam waaronder een speciefiek document is opgeslagen.';

COMMENT ON COLUMN public.tbcorrespondentie.dnkeyhorecavergunningen
IS 'Foreign Key naar tabel TbHorecavergunningen.dnkey.';

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

COMMENT ON COLUMN public.tbcorrespondentie.dvonderwerp
IS 'Onderwerp van uitgaande brief.';

COMMENT ON COLUMN public.tbcorrespondentie.dlverstuurd
IS 'T of F of N. T betekent is de brief daadwerkelijk verstuurd. N betekent weet niet.';

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

COMMENT ON COLUMN public.tbcorrespondentie.dvkenmerk
IS 'Kenmerk van uitgaande brief.';

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

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

COMMENT ON COLUMN public.tbcorrespondentie.dnkeyinspbezoeken
IS 'Foreign key naar tbinspbezoeken.dnkey.';

COMMENT ON COLUMN public.tbcorrespondentie.dnkeyadviezen
IS 'Foreign key naar tbadviezen.dnkey.';

COMMENT ON COLUMN public.tbcorrespondentie.dvextrainfo
IS 'Extra kolom bedoeld bijv voor vermelden van bijlagen, maar ook als span voor een email';

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

COMMENT ON COLUMN public.tbcorrespondentie.dvcodeeigenaar
IS 'Foreign key naar Tbmedewerkers.dvcode. Hiermee wordt de eigenaar van het document bedoeld. (koppeling docuemnten naar DMS).';

COMMENT ON COLUMN public.tbcorrespondentie.dvdmsdoccode
IS 'De lokale identificatiecode van het document in het DMS.';

COMMENT ON COLUMN public.tbcorrespondentie.dnkeyklachten
IS 'Foreign key naar tbklachten.dnkey.';

COMMENT ON COLUMN public.tbcorrespondentie.dvdmskenmerk
IS 'DMS-hyperlink naar het document';

COMMENT ON COLUMN public.tbcorrespondentie.dvdmsbarcode
IS 'DMS-barcode van het document';

COMMENT ON COLUMN public.tbcorrespondentie.dvintdoccode
IS 'De toegekende integrale landelijke identificatiecode van het document in het DMS.';

COMMENT ON COLUMN public.tbcorrespondentie.dlinhoudisnaardms
IS 'T of F. Indien T dan is daadwerkelijk een document onder dvintdoccode opgeslagen in het DMS.';

CREATE INDEX idx_corresp_codeeigenaar ON public.tbcorrespondentie
 USING btree (dvcodeeigenaar COLLATE pg_catalog."default");

CREATE INDEX idx_corresp_keybestplan ON public.tbcorrespondentie
 USING btree (dnkeybestemmingsplannen);

CREATE INDEX idx_corresp_keyinfo ON public.tbcorrespondentie
 USING btree (dnkeyinfoaanvraag);

CREATE INDEX idx_corresp_keyklachten ON public.tbcorrespondentie
 USING btree (dnkeyklachten);

CREATE INDEX idx_corresp_keyomgverg ON public.tbcorrespondentie
 USING btree (dnkeyomgvergunningen);

CREATE INDEX idx_correspond_keybouwverg ON public.tbcorrespondentie
 USING btree (dnkeybouwvergunningen);

CREATE INDEX idx_correspond_keycontactadres ON public.tbcorrespondentie
 USING btree (dnkeycontactadressen);

CREATE INDEX idx_correspond_keydocumenten ON public.tbcorrespondentie
 USING btree (dnkeydocumenten);

CREATE INDEX idx_correspond_keyhandhaving ON public.tbcorrespondentie
 USING btree (dnkeyhandhavingen);

CREATE INDEX idx_correspond_keyovvergunning ON public.tbcorrespondentie
 USING btree (dnkeyovvergunningen);

CREATE INDEX idx_correspondentie_briefdatum ON public.tbcorrespondentie
 USING btree (ddbriefdatum);

CREATE INDEX idx_correspondentie_horecaverg ON public.tbcorrespondentie
 USING btree (dnkeyhorecavergunningen);

CREATE INDEX idx_correspondentie_milinricht ON public.tbcorrespondentie
 USING btree (dnkeymilinrichtingen);

CREATE INDEX idx_correspondentie_milverg ON public.tbcorrespondentie
 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