Datadictionary OpenWave 3.1.11
 Previous topic Chapter index Next topic

Table: tbmilvergrechten

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Rechtentabel voor de module inrichtingen (rechten op de milieu- en gebruiksvergunningen)

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbmilvergrechten_dnkey_seq'::regclass)

Primary.

 

dnkeyrechten

integer

 

 

 

Foreign Key naar TbRechten.DnKey. Op deze kolom staat een unieke index.

 

 

dlbmilvergedt

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu vergunning Wijzigrecht (T of F).

 

 

dlbmilvergins

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu vergunning Nieuwrecht (T of F).

 

 

dlbmilvergdel

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu vergunning Verwijderrecht (T of F).

 

 

dlbmilvergblokkedt

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu vergunning Blokkeerrecht (T of F).

 

 

dlbmilverggroepedt

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu vergunning (T of F) Groepvergunnigen maken.

 

 

dlbmilvergmemovsb

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu vergunning Memo zichtbaar (T of F).

 

 

dlbmilvergkopie

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu vergunning. Kopieerrecht.

 

 

dlbmilvergmemoedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Milieu vergunning. Memo wijzigen.

 

 

dlcmilvergwetvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Wetten zichtbaar (T of F).

 

 

dlcmilvergwetedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Wetten wijzigen (T of F).

 

 

dlcmilvergwetins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Wetten nieuw (T of F).

 

 

dlcmilvergwetdel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Wetten verwijderen (T of F).

 

 

dlcmilvergcorvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning correspondentie zichtbaar (T of F).

 

 

dlcmilvergcoredt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning correspondentie wijzigen (T of F).

 

 

dlcmilvergcorins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning correspondentie nieuw (T of F).

 

 

dlcmilvergcordel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning correspondentie verwijderen (T of F).

 

 

dlcmilvergcadvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning contactadressen zichtbaar (T of F).

 

 

dlcmilvergcadins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning contactadressen koppeling maken (T of F).

 

 

dlcmilvergcaddel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning contactadressen koppeling verwijderen (T of F).

 

 

dlcmilvergadvvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning adviezen zichtbaar (T of F).

 

 

dlcmilvergadvedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning adviezen wijzigen (T of F).

 

 

dlcmilvergadvins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Adviezen nieuw (T of F).

 

 

dlcmilvergadvdel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning adviezen verwijderen (T of F).

 

 

dlcmilvergcinvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Correspondentie Binnen Zichtbaar (T of F).

 

 

dlcmilvergcinedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Correspondentie Binnen Wijzigen (T of F).

 

 

dlcmilvergcinins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Correspondentie Binnen Nieuw (T of F).

 

 

dlcmilvergcindel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Correspondentie Binnen Verwijderen (T of F).

 

 

dlcmilvergibbvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning in behandeling bij zichtbaar (T of F).

 

 

dlcmilvergibbedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning in behandeling bij wijzigen (T of F).

 

 

dlcmilvergibbins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning in behandeling bij nieuw (T of F).

 

 

dlcmilvergprovsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Procedures zichtbaar (T of F).

 

 

dlcmilvergproedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Procedures wijzigen (T of F).

 

 

dlcmilvergproins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Procedures nieuw (T of F).

 

 

dlcmilvergprodel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning procedures verwijderen (T of F).

 

 

dlcmilvergproahn

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt

 

 

dlcmilvergprovdg

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt

 

 

dlcmilvergadvdatedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Adviezen. Wijzigrecht kolom DdDateringadvies van tabel TbAdviezen bij milieuvergunningen (T of F).

 

 

dlcmilvergadvinedt

char(1)

 

 

 

'T'::bpchar

Niveau C. Milieuvergunningen. Adviesinstantie wijzigbaar bij adviezen.

 

 

dlbmilvergverzledt

char(1)

 

 

 

'F'::bpchar

Niveau B milieu vergunning Verzendlijst maken (T of F).

 

 

dlcmilvergbrwvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieuvergunningen Brandweer (Preparaties en installaties) zichtbaar (T of F).

 

 

dlcmilvergbrwedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieuvergunningen Brandweer (Preparaties en installaties) wijzigen (T of F).

 

 

dlcmilvergbrwins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieuvergunningen Brandweer (Preparaties en installaties) nieuw (T of F).

 

 

dlcmilvergbrwdel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieuvergunningen Brandweer (Preparaties en installaties) verwijderen (T of F).

 

 

dlbmilvergbcc

char(1)

 

 

 

'F'::bpchar

 

 

 

dlcmilvergcordms

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieuvergunnningen. Correspondentie. DMS-kolom muteerbaar

 

 

dlcmilvergcorodt

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieuvergunningen. Correspondentie. Opgeslagen document-kolom muteerbaar.

 

 

dlbmilvergsnelins

char(1)

 

 

 

'T'::bpchar

Niveau B. Milieuvergunningen. Mag externe zaakcode wijzigen.

 

 

dlcmilvergolovsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning oloberichten zichtbaar (T of F).

 

 

dlcmilvergoloedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning oloberichten wijzigen (T of F).

 

 

dlcmilvergoloins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning oloberichten nieuw (T of F).

 

 

dlcmilvergolodel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning oloberichten verwijderen (T of F).

 

 

dlcmilvergadvdms

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieu vergunning. Adviezen. Dmscode muteren (T of F).

 

 

dlbmilvergodedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Milieu/gebruik. Wavezaakcode (dvvergnummer),Ontvangsdatum en soort vergunning wijzigbaar. T of F

 

 

dlbmilverghlink

char(1)

 

 

 

'F'::bpchar

Niveau B. Milieu/gebruik. Mag hyperlink starten vanuit powerportal milieu/gebruikdetail.

 

 

dlbmilvergverplaats

char(1)

 

 

 

'F'::bpchar

Niveau B. Milieu/gebruik. Mag zaak verlaatsen naar ander locatieadres

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

cfk_tbmilvergrecht_keyrechten

dnkeyrechten

public.tbrechten

dnkey

Cascade

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

chk_milvergr_dlbmilverghlink

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

 

chk_milvergr_dlbmilvergodedt

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

 

chk_milvergr_dlbmilvergverpl

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

 

chk_milvergr_dlcmilvergolodel

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

 

chk_milvergr_dlcmilvergoloedt

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

 

chk_milvergr_dlcmilvergoloins

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

 

chk_milvergr_dlcmilvergolovsb

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

 

chk_milvergrecht_dlbmilvergbcc

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

 

chk_milvergrecht_dlbmilvgblok

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

 

chk_milvergrecht_dlbmilvgdel

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

 

chk_milvergrecht_dlbmilvgedt

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

 

chk_milvergrecht_dlbmilvggpedt

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

 

chk_milvergrecht_dlbmilvgins

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

 

chk_milvergrecht_dlbmilvgkopie

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

 

chk_milvergrecht_dlbmilvgmmedt

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

 

chk_milvergrecht_dlbmilvgmmvsb

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

 

chk_milvergrecht_dlcmilbrwdel

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

 

chk_milvergrecht_dlcmilbrwedt

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

 

chk_milvergrecht_dlcmilbrwins

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

 

chk_milvergrecht_dlcmilbrwvsb

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

 

chk_milvergrecht_dlcmilvgavdel

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

 

chk_milvergrecht_dlcmilvgavdet

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

 

chk_milvergrecht_dlcmilvgavedt

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

 

chk_milvergrecht_dlcmilvgaviet

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

 

chk_milvergrecht_dlcmilvgavins

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

 

chk_milvergrecht_dlcmilvgavvsb

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

 

chk_milvergrecht_dlcmilvgcddel

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

 

chk_milvergrecht_dlcmilvgcdins

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

 

chk_milvergrecht_dlcmilvgcdvsb

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

 

chk_milvergrecht_dlcmilvgcndel

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

 

chk_milvergrecht_dlcmilvgcnedt

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

 

chk_milvergrecht_dlcmilvgcnins

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

 

chk_milvergrecht_dlcmilvgcnvsb

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

 

chk_milvergrecht_dlcmilvgcrdel

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

 

chk_milvergrecht_dlcmilvgcredt

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

 

chk_milvergrecht_dlcmilvgcrins

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

 

chk_milvergrecht_dlcmilvgcrvsb

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

 

chk_milvergrecht_dlcmilvgibedt

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

 

chk_milvergrecht_dlcmilvgibins

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

 

chk_milvergrecht_dlcmilvgibvsb

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

 

chk_milvergrecht_dlcmilvgpoahn

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

 

chk_milvergrecht_dlcmilvgpodel

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

 

chk_milvergrecht_dlcmilvgpoedt

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

 

chk_milvergrecht_dlcmilvgpoins

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

 

chk_milvergrecht_dlcmilvgpovdg

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

 

chk_milvergrecht_dlcmilvgpovsb

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

 

chk_milvergrecht_dlcmilvgwtdel

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

 

chk_milvergrecht_dlcmilvgwtedt

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

 

chk_milvergrecht_dlcmilvgwtins

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

 

chk_milvergrecht_dlcmilvgwtvsb

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

 

chk_milvergrecht_keyrechten

dnkeyrechten IS NOT NULL

 

chk_milvergrechten_dlverzendl

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

 

chk_milvgrecht_dlcmilvgcordms

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

 

chk_milvgrecht_dlcmilvgcorodt

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

 

chk_milvrechten_dlbmvsnelins

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

 

chk_tbmilverg_dlcmilvergadvdms

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

 

cnn_milvergr_dlbmilverghlink

dlbmilverghlink IS NOT NULL

 

cnn_milvergr_dlbmilvergodedt

dlbmilvergodedt IS NOT NULL

 

cnn_milvergr_dlbmilvergverpl

dlbmilvergverplaats IS NOT NULL

 

cnn_milvergrecht_dlbmilvergbcc

dlbmilvergbcc IS NOT NULL

 

cnn_milvergrechten_dlverzendl

dlbmilvergverzledt IS NOT NULL

 

cnn_milvgrecht_dlcmilvgcordms

dlcmilvergcordms IS NOT NULL

 

cnn_milvgrecht_dlcmilvgcorodt

dlcmilvergcorodt IS NOT NULL

 

cnn_milvrechten_dlbmvsnelins

dlbmilvergsnelins IS NOT NULL

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbmilvergrechten

btree

 

dnkey

 

idu_milvergrechten_keyrechten

btree

 

dnkeyrechten

 

 

 

Triggers

There are no triggers for table tbmilvergrechten

 

Rules

There are no rules for table tbmilvergrechten

 

Referenced

There are no tables referenced by table tbmilvergrechten

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.tbmilvergrechten (
 dnkey SERIAL,
 dnkeyrechten INTEGER,
 dlbmilvergedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergins CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergblokkedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilverggroepedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergmemovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergkopie CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergmemoedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergwetvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergwetedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergwetins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergwetdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcorvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcoredt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcorins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcordel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcadvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcadins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcaddel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergadvvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergadvedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergadvins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergadvdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcinvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcinins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcindel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergibbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergibbedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergibbins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergprovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergproedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergproins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergprodel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergproahn CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergprovdg CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergadvdatedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergadvinedt CHAR(1) DEFAULT 'T'::bpchar,
 dlbmilvergverzledt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergbrwvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergbrwedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergbrwins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergbrwdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergbcc CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcordms CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcorodt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergsnelins CHAR(1) DEFAULT 'T'::bpchar,
 dlcmilvergolovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergoloedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergoloins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergolodel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergadvdms CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergodedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilverghlink CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergverplaats CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tbmilvergrechten PRIMARY KEY(dnkey),
 CONSTRAINT chk_milvergr_dlbmilverghlink CHECK (dlbmilverghlink = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvergr_dlbmilvergodedt CHECK (dlbmilvergodedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvergr_dlbmilvergverpl CHECK (dlbmilvergverplaats = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvergr_dlcmilvergolodel CHECK (dlcmilvergolodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergr_dlcmilvergoloedt CHECK (dlcmilvergoloedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergr_dlcmilvergoloins CHECK (dlcmilvergoloins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergr_dlcmilvergolovsb CHECK (dlcmilvergolovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvergbcc CHECK (dlbmilvergbcc = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvgblok CHECK (dlbmilvergblokkedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvgdel CHECK (dlbmilvergdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvgedt CHECK (dlbmilvergedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvggpedt CHECK (dlbmilverggroepedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvgins CHECK (dlbmilvergins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvgkopie CHECK (dlbmilvergkopie = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvgmmedt CHECK (dlbmilvergmemoedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvgmmvsb CHECK (dlbmilvergmemovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilbrwdel CHECK (dlcmilvergbrwdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilbrwedt CHECK (dlcmilvergbrwedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilbrwins CHECK (dlcmilvergbrwins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilbrwvsb CHECK (dlcmilvergbrwvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgavdel CHECK (dlcmilvergadvdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgavdet CHECK (dlcmilvergadvdatedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgavedt CHECK (dlcmilvergadvedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgaviet CHECK (dlcmilvergadvinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgavins CHECK (dlcmilvergadvins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgavvsb CHECK (dlcmilvergadvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcddel CHECK (dlcmilvergcaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcdins CHECK (dlcmilvergcadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcdvsb CHECK (dlcmilvergcadvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcndel CHECK (dlcmilvergcindel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcnedt CHECK (dlcmilvergcinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcnins CHECK (dlcmilvergcinins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcnvsb CHECK (dlcmilvergcinvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcrdel CHECK (dlcmilvergcordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcredt CHECK (dlcmilvergcoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcrins CHECK (dlcmilvergcorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcrvsb CHECK (dlcmilvergcorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgibedt CHECK (dlcmilvergibbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgibins CHECK (dlcmilvergibbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgibvsb CHECK (dlcmilvergibbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgpoahn CHECK (dlcmilvergproahn = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgpodel CHECK (dlcmilvergprodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgpoedt CHECK (dlcmilvergproedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgpoins CHECK (dlcmilvergproins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgpovdg CHECK (dlcmilvergprovdg = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgpovsb CHECK (dlcmilvergprovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgwtdel CHECK (dlcmilvergwetdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgwtedt CHECK (dlcmilvergwetedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgwtins CHECK (dlcmilvergwetins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgwtvsb CHECK (dlcmilvergwetvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_keyrechten CHECK (dnkeyrechten IS NOT NULL),
 CONSTRAINT chk_milvergrechten_dlverzendl CHECK (dlbmilvergverzledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvgrecht_dlcmilvgcordms CHECK (dlcmilvergcordms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvgrecht_dlcmilvgcorodt CHECK (dlcmilvergcorodt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvrechten_dlbmvsnelins CHECK (dlbmilvergsnelins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbmilverg_dlcmilvergadvdms CHECK (dlcmilvergadvdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT cnn_milvergr_dlbmilverghlink CHECK (dlbmilverghlink IS NOT NULL),
 CONSTRAINT cnn_milvergr_dlbmilvergodedt CHECK (dlbmilvergodedt IS NOT NULL),
 CONSTRAINT cnn_milvergr_dlbmilvergverpl CHECK (dlbmilvergverplaats IS NOT NULL),
 CONSTRAINT cnn_milvergrecht_dlbmilvergbcc CHECK (dlbmilvergbcc IS NOT NULL),
 CONSTRAINT cnn_milvergrechten_dlverzendl CHECK (dlbmilvergverzledt IS NOT NULL),
 CONSTRAINT cnn_milvgrecht_dlcmilvgcordms CHECK (dlcmilvergcordms IS NOT NULL),
 CONSTRAINT cnn_milvgrecht_dlcmilvgcorodt CHECK (dlcmilvergcorodt IS NOT NULL),
 CONSTRAINT cnn_milvrechten_dlbmvsnelins CHECK (dlbmilvergsnelins IS NOT NULL),
 CONSTRAINT cfk_tbmilvergrecht_keyrechten FOREIGN KEY (dnkeyrechten)
   REFERENCES public.tbrechten(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
)
WITH (oids = false);

COMMENT ON TABLE public.tbmilvergrechten
IS 'Rechtentabel voor de module inrichtingen (rechten op de milieu- en gebruiksvergunningen)';

COMMENT ON COLUMN public.tbmilvergrechten.dnkey
IS 'Primary.';

COMMENT ON COLUMN public.tbmilvergrechten.dnkeyrechten
IS 'Foreign Key naar TbRechten.DnKey. Op deze kolom staat een unieke index.';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergedt
IS 'Niveau B Milieu vergunning Wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergins
IS 'Niveau B Milieu vergunning Nieuwrecht (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergdel
IS 'Niveau B Milieu vergunning Verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergblokkedt
IS 'Niveau B Milieu vergunning Blokkeerrecht (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilverggroepedt
IS 'Niveau B Milieu vergunning (T of F) Groepvergunnigen maken.';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergmemovsb
IS 'Niveau B Milieu vergunning Memo zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergkopie
IS 'Niveau B Milieu vergunning. Kopieerrecht.';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergmemoedt
IS 'Niveau B. Milieu vergunning. Memo wijzigen.';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergwetvsb
IS 'Niveau C Milieu vergunning Wetten zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergwetedt
IS 'Niveau C Milieu vergunning Wetten wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergwetins
IS 'Niveau C Milieu vergunning Wetten nieuw (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergwetdel
IS 'Niveau C Milieu vergunning Wetten verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcorvsb
IS 'Niveau C Milieu vergunning correspondentie zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcoredt
IS 'Niveau C Milieu vergunning correspondentie wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcorins
IS 'Niveau C Milieu vergunning correspondentie nieuw (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcordel
IS 'Niveau C Milieu vergunning correspondentie verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcadvsb
IS 'Niveau C Milieu vergunning contactadressen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcadins
IS 'Niveau C Milieu vergunning contactadressen koppeling maken (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcaddel
IS 'Niveau C Milieu vergunning contactadressen koppeling verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergadvvsb
IS 'Niveau C Milieu vergunning adviezen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergadvedt
IS 'Niveau C Milieu vergunning adviezen wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergadvins
IS 'Niveau C Milieu vergunning Adviezen nieuw (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergadvdel
IS 'Niveau C Milieu vergunning adviezen verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcinvsb
IS 'Niveau C Milieu vergunning Correspondentie Binnen Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcinedt
IS 'Niveau C Milieu vergunning Correspondentie Binnen Wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcinins
IS 'Niveau C Milieu vergunning Correspondentie Binnen Nieuw (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcindel
IS 'Niveau C Milieu vergunning Correspondentie Binnen Verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergibbvsb
IS 'Niveau C Milieu vergunning in behandeling bij zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergibbedt
IS 'Niveau C Milieu vergunning in behandeling bij  wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergibbins
IS 'Niveau C Milieu vergunning in behandeling bij nieuw (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergprovsb
IS 'Niveau C Milieu vergunning Procedures zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergproedt
IS 'Niveau C Milieu vergunning Procedures wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergproins
IS 'Niveau C Milieu vergunning Procedures nieuw (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergprodel
IS 'Niveau C Milieu vergunning procedures verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergproahn
IS 'Wordt niet meer gebruikt';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergprovdg
IS 'Wordt niet meer gebruikt';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergadvdatedt
IS 'Niveau C. Adviezen. Wijzigrecht kolom DdDateringadvies van tabel TbAdviezen bij milieuvergunningen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergadvinedt
IS 'Niveau C. Milieuvergunningen. Adviesinstantie wijzigbaar bij adviezen.';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergverzledt
IS 'Niveau B milieu vergunning Verzendlijst maken (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergbrwvsb
IS 'Niveau C Milieuvergunningen Brandweer (Preparaties en installaties) zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergbrwedt
IS 'Niveau C Milieuvergunningen Brandweer (Preparaties en installaties) wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergbrwins
IS 'Niveau C Milieuvergunningen Brandweer (Preparaties en installaties) nieuw (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergbrwdel
IS 'Niveau C Milieuvergunningen Brandweer (Preparaties en installaties) verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcordms
IS 'Niveau C. Milieuvergunnningen. Correspondentie. DMS-kolom muteerbaar';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcorodt
IS 'Niveau C. Milieuvergunningen. Correspondentie. Opgeslagen document-kolom muteerbaar.';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergsnelins
IS 'Niveau B. Milieuvergunningen. Mag externe zaakcode wijzigen.';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergolovsb
IS 'Niveau C Milieu vergunning oloberichten zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergoloedt
IS 'Niveau C Milieu vergunning oloberichten wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergoloins
IS 'Niveau C Milieu vergunning oloberichten nieuw (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergolodel
IS 'Niveau C Milieu vergunning oloberichten verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergadvdms
IS 'Niveau C. Milieu vergunning. Adviezen. Dmscode muteren (T of F). ';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergodedt
IS 'Niveau B. Milieu/gebruik. Wavezaakcode (dvvergnummer),Ontvangsdatum en soort vergunning wijzigbaar. T of F';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilverghlink
IS 'Niveau B. Milieu/gebruik. Mag hyperlink starten vanuit powerportal milieu/gebruikdetail.';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergverplaats
IS 'Niveau B. Milieu/gebruik. Mag zaak verlaatsen naar ander locatieadres';

CREATE UNIQUE INDEX idu_milvergrechten_keyrechten ON public.tbmilvergrechten
 USING btree (dnkeyrechten); 


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