Datadictionary OpenWave 3.1.11
 Previous topic Chapter index Next topic

Table: tbadviezen

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Tabel met adviezen gekoppeld aan vergunningsaanvragen

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbadviezen_dnkey_seq'::regclass)

Primary key.

 

dnkeyhandhavingen

integer

 

 

 

 

Foreign key naar Tbhandhavingen.

 

dnkeybouwvergunningen

integer

 

 

 

 

Foreign key naar TbBouwvergunningen.

 

dnkeyovvergunningen

integer

 

 

 

 

Foreign key naar TbOvVergunningen.

 

dvcodeadviesinstanties

char(4)

 

 

 

 

Foreign key naar TbAdviesdInstanties.

 

 

dvomschrijving

varchar(40)

 

 

 

 

Omschrijving van het gevraagde advies.

 

 

ddaanvraagdatum

timestamp

 

 

 

 

Datum waarop advies is aangevraagd.

 

 

ddrappeldatum

timestamp

 

 

 

 

Datum waarop advies binnen had moeten zijn. Wordt default berekend uit DdAanvraagdatum + TbAdviesinstanties.Dn-Rappeldagen.

 

 

ddadviesdatum

timestamp

 

 

 

 

Datum waarop advies is uitgebracht.

 

 

dladviespositief

char(1)

 

 

 

'N'::bpchar

T of F of N. Indien de waarde T dan is het advies positief. N wil zeggen nog niet bekend

 

 

dvmemo

varchar(2000)

 

 

 

 

Eventueel inhoudelijk beschrijving van het advies.

 

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.

 

dnkeyretouradvies

integer

 

 

 

 

Foreign key naar tabel TbRetourAdvies.

 

 

dddateringadvies

timestamp

 

 

 

 

Datering van het afgegeven advies.

 

 

dvdocfilenaam

varchar(255)

 

 

 

 

Verwijzing naar een opgeslagen document bij een advies.

 

dvcodemedewerkers

char(5)

 

 

 

 

Foreign key naar Tbmedewerkers. De interne medewerker die verantwoordelijk is voor het advies

 

dnkeymilvergunningen

integer

 

 

 

 

Foreign key naar TbMilVergunningen.

 

dnkeyomgvergunningen

integer

 

 

 

 

Foreign key naar TbOmgVergunningen.

 

 

ddvervallen

timestamp

 

 

 

 

Datum dat adviesaanvraag is komen te vervallen.

 

dnkeyadvcat

integer

 

 

 

 

Foreign key naar tbadvcatadvinstnn.dnkey (adviescategorieen).

 

 

dvintzaakcode

varchar(40)

 

 

 

 

Integrale landelijke zaakidentificatiecode van het advies.

 

 

dvdmszaakcode

varchar(40)

 

 

 

 

Zaakcode waaronder het advies in het DMS en/of zaaksysteem bekend is

 

 

dlisindmsverwijderd

char(1)

 

 

 

'F'::bpchar

T of F. Indien T dan is dit een indicatie dat de overeenkomstige zaak in het externe zaaksysteem waarschijnlijk is verwijderd.

 

 

ddaanvraagverstuurd

timestamp

 

 

 

 

Datum waarop attendering is verstuurd (mail) naar behandelende instantie.

 

 

dvuploadlog

varchar(4000)

 

 

 

 

Log van datum, adviseur en bestandsnaam van geuploade files (naar fileshare of dms).

 

 

dvwavezaakcode

varchar(40)

 

 

 

 

Berekende kolom year(ddadviesaanvraag) + ADV + de dnkey)

 

 

ddstatus_lk01

timestamp

 

 

 

 

Datum dat status van zaak id doorgegeven aan extern systeem met zaak/dms koppeling.

 

 

dvstatus_lk01

varchar(20)

 

 

 

 

De externe statuscode (zie tbzaakstatus) die op ddstatus_lk01 is doorgegeven aan externe zaaksysteem.

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

cfk_adviezen_adviesinst

dvcodeadviesinstanties

public.tbadviesinstanties

dvcode

No Action

No Action

 

Immediate

 

cfk_adviezen_bestplan

dnkeybestemmingsplannen

public.tbbestemmingsplannen

dnkey

Cascade

No Action

 

Immediate

 

cfk_adviezen_bouwverg

dnkeybouwvergunningen

public.tbbouwvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_adviezen_handhavingen

dnkeyhandhavingen

public.tbhandhavingen

dnkey

Cascade

No Action

 

Immediate

 

cfk_adviezen_horecaverg

dnkeyhorecavergunningen

public.tbhorecavergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_adviezen_info

dnkeyinfoaanvraag

public.tbinfoaanvragen

dnkey

Cascade

No Action

 

Immediate

 

cfk_adviezen_milverg

dnkeymilvergunningen

public.tbmilvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_adviezen_omgverg

dnkeyomgvergunningen

public.tbomgvergunning

dnkey

Cascade

No Action

 

Immediate

 

cfk_adviezen_ovverg

dnkeyovvergunningen

public.tbovvergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_adviezen_retour

dnkeyretouradvies

public.tbretouradvies

dnkey

Cascade

No Action

 

Immediate

 

cfk_tbadviezen_codemedew

dvcodemedewerkers

public.tbmedewerkers

dvcode

No Action

No Action

 

Immediate

 

cfk_tbadviezen_keyadvcat

dnkeyadvcat

public.tbadvcatadvinstnn

dnkey

No Action

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

chk_adviezen_adviespos

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

 

chk_tbadviezen_dlisindmsverw

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

 

cnn_adviezen_dladvpos

dladviespositief IS NOT NULL

 

cnn_adviezen_keyadvinst

dvcodeadviesinstanties IS NOT NULL

 

cnn_adviezen_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 (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 (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 (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 (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 (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 (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 (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 (dnkeyomgvergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL))

 

cnn_tbadviezen_dlisindmsverw

dlisindmsverwijderd IS NOT NULL

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbadviezen

btree

 

dnkey

 

idx_advies_codeadviesinstantie

btree

 

dvcodeadviesinstanties

 

 

 

idx_advies_keybouwvergunningen

btree

 

dnkeybouwvergunningen

 

 

 

idx_advies_keyhandhaving

btree

 

dnkeyhandhavingen

 

 

 

idx_advies_keyovvergunningen

btree

 

dnkeyovvergunningen

 

 

 

idx_adviezen_aanvraagdatum

btree

 

ddaanvraagdatum

 

 

 

idx_adviezen_adviesdatum

btree

 

ddadviesdatum

 

 

 

idx_adviezen_adviespositief

btree

 

dladviespositief

 

 

 

idx_adviezen_codemedew

btree

 

dvcodemedewerkers

 

 

 

idx_adviezen_datering

btree

 

dddateringadvies

 

 

 

idx_adviezen_ddvervallen

btree

 

ddvervallen

 

 

 

idx_adviezen_horecaverg

btree

 

dnkeyhorecavergunningen

 

 

 

idx_adviezen_keybestplan

btree

 

dnkeybestemmingsplannen

 

 

 

idx_adviezen_keyinfo

btree

 

dnkeyinfoaanvraag

 

 

 

idx_adviezen_keymilverg

btree

 

dnkeymilvergunningen

 

 

 

idx_adviezen_keyomgverg

btree

 

dnkeyomgvergunningen

 

 

 

idx_adviezen_rappeldatum

btree

 

ddrappeldatum

 

 

 

idx_adviezen_retour

btree

 

dnkeyretouradvies

 

 

 

 

Triggers

There are no triggers for table tbadviezen

 

Rules

There are no rules for table tbadviezen

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

tbadvieswelstand

public

cfk_tbadvieswelst_tbadviezen

dnkeyadviezen

public.tbadviezen

dnkey

Cascade

No Action

 

Immediate

 

tbcorrespondentie

public

cfk_tbcorresp_keyadviezen

dnkeyadviezen

public.tbadviezen

dnkey

No Action

No Action

 

Immediate

 

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.tbadviezen (
 dnkey SERIAL,
 dnkeyhandhavingen INTEGER,
 dnkeybouwvergunningen INTEGER,
 dnkeyovvergunningen INTEGER,
 dvcodeadviesinstanties CHAR(4),
 dvomschrijving VARCHAR(40),
 ddaanvraagdatum TIMESTAMP WITHOUT TIME ZONE,
 ddrappeldatum TIMESTAMP WITHOUT TIME ZONE,
 ddadviesdatum TIMESTAMP WITHOUT TIME ZONE,
 dladviespositief CHAR(1) DEFAULT 'N'::bpchar,
 dvmemo VARCHAR(2000),
 dnkeyhorecavergunningen INTEGER,
 dnkeybestemmingsplannen INTEGER,
 dnkeyinfoaanvraag INTEGER,
 dnkeyretouradvies INTEGER,
 dddateringadvies TIMESTAMP WITHOUT TIME ZONE,
 dvdocfilenaam VARCHAR(255),
 dvcodemedewerkers CHAR(5),
 dnkeymilvergunningen INTEGER,
 dnkeyomgvergunningen INTEGER,
 ddvervallen TIMESTAMP WITHOUT TIME ZONE,
 dnkeyadvcat INTEGER,
 dvintzaakcode VARCHAR(40),
 dvdmszaakcode VARCHAR(40),
 dlisindmsverwijderd CHAR(1) DEFAULT 'F'::bpchar,
 ddaanvraagverstuurd TIMESTAMP WITHOUT TIME ZONE,
 dvuploadlog VARCHAR(4000),
 dvwavezaakcode VARCHAR(40),
 ddstatus_lk01 TIMESTAMP WITHOUT TIME ZONE,
 dvstatus_lk01 VARCHAR(20),
 CONSTRAINT cpk_tbadviezen PRIMARY KEY(dnkey),
 CONSTRAINT chk_adviezen_adviespos CHECK (dladviespositief = ANY (ARRAY['T'::bpchar, 'F'::bpchar, 'N'::bpchar])),
 CONSTRAINT chk_tbadviezen_dlisindmsverw CHECK (dlisindmsverwijderd = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT cnn_adviezen_dladvpos CHECK (dladviespositief IS NOT NULL),
 CONSTRAINT cnn_adviezen_keyadvinst CHECK (dvcodeadviesinstanties IS NOT NULL),
 CONSTRAINT cnn_adviezen_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 (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 (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 (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 (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 (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 (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 (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 (dnkeyomgvergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL))),
 CONSTRAINT cnn_tbadviezen_dlisindmsverw CHECK (dlisindmsverwijderd IS NOT NULL),
 CONSTRAINT cfk_adviezen_adviesinst FOREIGN KEY (dvcodeadviesinstanties)
   REFERENCES public.tbadviesinstanties(dvcode)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_adviezen_bestplan FOREIGN KEY (dnkeybestemmingsplannen)
   REFERENCES public.tbbestemmingsplannen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_adviezen_bouwverg FOREIGN KEY (dnkeybouwvergunningen)
   REFERENCES public.tbbouwvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_adviezen_handhavingen FOREIGN KEY (dnkeyhandhavingen)
   REFERENCES public.tbhandhavingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_adviezen_horecaverg FOREIGN KEY (dnkeyhorecavergunningen)
   REFERENCES public.tbhorecavergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_adviezen_info FOREIGN KEY (dnkeyinfoaanvraag)
   REFERENCES public.tbinfoaanvragen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_adviezen_milverg FOREIGN KEY (dnkeymilvergunningen)
   REFERENCES public.tbmilvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_adviezen_omgverg FOREIGN KEY (dnkeyomgvergunningen)
   REFERENCES public.tbomgvergunning(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_adviezen_ovverg FOREIGN KEY (dnkeyovvergunningen)
   REFERENCES public.tbovvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_adviezen_retour FOREIGN KEY (dnkeyretouradvies)
   REFERENCES public.tbretouradvies(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_tbadviezen_codemedew FOREIGN KEY (dvcodemedewerkers)
   REFERENCES public.tbmedewerkers(dvcode)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_tbadviezen_keyadvcat FOREIGN KEY (dnkeyadvcat)
   REFERENCES public.tbadvcatadvinstnn(dnkey)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE
)
WITH (oids = false);

COMMENT ON TABLE public.tbadviezen
IS 'Tabel met adviezen gekoppeld aan vergunningsaanvragen';

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

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

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

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

COMMENT ON COLUMN public.tbadviezen.dvcodeadviesinstanties
IS 'Foreign key naar TbAdviesdInstanties.';

COMMENT ON COLUMN public.tbadviezen.dvomschrijving
IS 'Omschrijving van het gevraagde advies.';

COMMENT ON COLUMN public.tbadviezen.ddaanvraagdatum
IS 'Datum waarop advies is aangevraagd.';

COMMENT ON COLUMN public.tbadviezen.ddrappeldatum
IS 'Datum waarop advies binnen had moeten zijn. Wordt default berekend uit DdAanvraagdatum + TbAdviesinstanties.Dn-Rappeldagen.';

COMMENT ON COLUMN public.tbadviezen.ddadviesdatum
IS 'Datum waarop advies is uitgebracht.';

COMMENT ON COLUMN public.tbadviezen.dladviespositief
IS 'T of F of N. Indien de waarde T dan is het advies positief. N wil zeggen nog niet bekend';

COMMENT ON COLUMN public.tbadviezen.dvmemo
IS 'Eventueel inhoudelijk beschrijving van het advies.';

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

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

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

COMMENT ON COLUMN public.tbadviezen.dnkeyretouradvies
IS 'Foreign key naar tabel TbRetourAdvies.';

COMMENT ON COLUMN public.tbadviezen.dddateringadvies
IS 'Datering van het afgegeven advies.';

COMMENT ON COLUMN public.tbadviezen.dvdocfilenaam
IS 'Verwijzing naar een opgeslagen document bij een advies.';

COMMENT ON COLUMN public.tbadviezen.dvcodemedewerkers
IS 'Foreign key naar Tbmedewerkers. De interne medewerker die verantwoordelijk is voor het advies';

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

COMMENT ON COLUMN public.tbadviezen.dnkeyomgvergunningen
IS 'Foreign key naar TbOmgVergunningen.';

COMMENT ON COLUMN public.tbadviezen.ddvervallen
IS 'Datum dat adviesaanvraag is komen te vervallen.';

COMMENT ON COLUMN public.tbadviezen.dnkeyadvcat
IS 'Foreign key naar tbadvcatadvinstnn.dnkey (adviescategorieen).';

COMMENT ON COLUMN public.tbadviezen.dvintzaakcode
IS 'Integrale landelijke zaakidentificatiecode van het advies.';

COMMENT ON COLUMN public.tbadviezen.dvdmszaakcode
IS 'Zaakcode waaronder het advies in het DMS en/of zaaksysteem bekend is';

COMMENT ON COLUMN public.tbadviezen.dlisindmsverwijderd
IS 'T of F. Indien T dan is dit een indicatie dat de overeenkomstige zaak in het externe zaaksysteem waarschijnlijk is verwijderd.';

COMMENT ON COLUMN public.tbadviezen.ddaanvraagverstuurd
IS 'Datum waarop attendering is verstuurd (mail) naar behandelende instantie.';

COMMENT ON COLUMN public.tbadviezen.dvuploadlog
IS 'Log van datum, adviseur en bestandsnaam van geuploade files (naar fileshare of dms).';

COMMENT ON COLUMN public.tbadviezen.dvwavezaakcode
IS 'Berekende kolom year(ddadviesaanvraag) + ADV + de dnkey)';

COMMENT ON COLUMN public.tbadviezen.ddstatus_lk01
IS 'Datum dat status van zaak id doorgegeven aan extern systeem met zaak/dms koppeling.';

COMMENT ON COLUMN public.tbadviezen.dvstatus_lk01
IS 'De externe statuscode (zie tbzaakstatus) die op ddstatus_lk01 is doorgegeven aan externe zaaksysteem.';

CREATE INDEX idx_advies_codeadviesinstantie ON public.tbadviezen
 USING btree (dvcodeadviesinstanties COLLATE pg_catalog."default");

CREATE INDEX idx_advies_keybouwvergunningen ON public.tbadviezen
 USING btree (dnkeybouwvergunningen);

CREATE INDEX idx_advies_keyhandhaving ON public.tbadviezen
 USING btree (dnkeyhandhavingen);

CREATE INDEX idx_advies_keyovvergunningen ON public.tbadviezen
 USING btree (dnkeyovvergunningen);

CREATE INDEX idx_adviezen_aanvraagdatum ON public.tbadviezen
 USING btree (ddaanvraagdatum);

CREATE INDEX idx_adviezen_adviesdatum ON public.tbadviezen
 USING btree (ddadviesdatum);

CREATE INDEX idx_adviezen_adviespositief ON public.tbadviezen
 USING btree (dladviespositief COLLATE pg_catalog."default");

CREATE INDEX idx_adviezen_codemedew ON public.tbadviezen
 USING btree (dvcodemedewerkers COLLATE pg_catalog."default");

CREATE INDEX idx_adviezen_datering ON public.tbadviezen
 USING btree (dddateringadvies);

CREATE INDEX idx_adviezen_ddvervallen ON public.tbadviezen
 USING btree (ddvervallen);

CREATE INDEX idx_adviezen_horecaverg ON public.tbadviezen
 USING btree (dnkeyhorecavergunningen);

CREATE INDEX idx_adviezen_keybestplan ON public.tbadviezen
 USING btree (dnkeybestemmingsplannen);

CREATE INDEX idx_adviezen_keyinfo ON public.tbadviezen
 USING btree (dnkeyinfoaanvraag);

CREATE INDEX idx_adviezen_keymilverg ON public.tbadviezen
 USING btree (dnkeymilvergunningen);

CREATE INDEX idx_adviezen_keyomgverg ON public.tbadviezen
 USING btree (dnkeyomgvergunningen);

CREATE INDEX idx_adviezen_rappeldatum ON public.tbadviezen
 USING btree (ddrappeldatum);

CREATE INDEX idx_adviezen_retour ON public.tbadviezen
 USING btree (dnkeyretouradvies); 


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