Datadictionary OpenWave 3.1.32

Table: tbomgrechten

Schema

public

Owner

waveuser005

Tablespace

(default)

Descriptions

Rechtentabel voor de module omgevingsvergunning

Fields

Foreign Keys

Check Constraints

Indices

Triggers

There are no triggers for table tbomgrechten

Rules

There are no rules for table tbomgrechten

Policies

There are no policies for table tbomgrechten

Referenced

There are no tables referenced by table tbomgrechten

Properties

Definition

CREATE TABLE public.tbomgrechten (
 dnkey SERIAL,
 dnkeyrechten INTEGER,
 dlbomgedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgins CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgverplaats CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgblokkedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgmemovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgmemoedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomginsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomginsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomginsins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomginsdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorvsb CHAR(1) DEFAULT 'T'::bpchar,
 dlcomgcoredt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcordel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcadvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcadins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcaddel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgadvvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgadvedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgadvins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgadvdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcinvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcinins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcindel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgibbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgibbedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgibbins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgprovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgproedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgproins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgprodel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgproahn CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgprovdg CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgadvdatedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgadvinedt CHAR(1) DEFAULT 'T'::bpchar,
 dlcomgtstvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgtstedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgtstins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgtstdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomglegvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomglegedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomglegins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomglegdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomglegexpnot CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgwelstandvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgwelstandins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgwelstanddel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgwelstandedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgverzledt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbtcvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbtcedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbtcins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbtcdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbrwvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbrwedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbrwins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbrwdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgolovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgoloedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgoloins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgolodel CHAR(1) DEFAULT 'F'::bpchar,
 dlbomggroepedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgverspr CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgtstbcc CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcordms CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorodt CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgsnelins CHAR(1) DEFAULT 'T'::bpchar,
 dlcomginsdms CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgadvdms CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgodedt CHAR(1) DEFAULT 'T'::bpchar,
 dlbomghlink CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbezwvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbezwedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbezwins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbezwdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbezwdms CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgzkpins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgzkpvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgzkpedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgzkpdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomguurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomguurins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomguurdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomguuredt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomginsuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbezwuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgadvuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgafsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbguiins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbguiedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbguidel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbguivsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorregvsb CHAR(1) DEFAULT 'T'::bpchar,
 dlcomgcorregdwl CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcordocdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorwmo CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorreghnm CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgprdedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomginsovbzdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgswfins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgswfedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgswfdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgswfvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgswfafs CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgprdins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgprddel CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgwznedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgztedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorregtent CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgzkphoofdedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorupload CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorverplaats CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgbevgezedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgdocbevgez CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgprodatdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgdwsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgdwsins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgdwsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgdwsdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomginvvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomginvins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomginvedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomginvdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgdsoprojins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgdsoprojdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorddverstuurd CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgroebins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgroebvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgroebedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgroebdel CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tbomgrechten PRIMARY KEY(dnkey),
 CONSTRAINT chk_omgrecht_dlbomgafsedt CHECK (dlbomgafsedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgblok CHECK (dlbomgblokkedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgdel CHECK (dlbomgdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgedt CHECK (dlbomgedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgins CHECK (dlbomgins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgmmedt CHECK (dlbomgmemoedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgmmvsb CHECK (dlbomgmemovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgverzledt CHECK (dlbomgverzledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgvpl CHECK (dlbomgverplaats = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgwznedt CHECK (dlbomgwznedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgztedt CHECK (dlbomgztedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgavdel CHECK (dlcomgadvdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgavdet CHECK (dlcomgadvdatedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgavedt CHECK (dlcomgadvedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgaviet CHECK (dlcomgadvinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgavins CHECK (dlcomgadvins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgavvsb CHECK (dlcomgadvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgbguidel CHECK (dlcomgbguidel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgbguiedt CHECK (dlcomgbguiedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgbguiins CHECK (dlcomgbguiins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgbguivsb CHECK (dlcomgbguivsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgbtcdel CHECK (dlcomgbtcdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgbtcedt CHECK (dlcomgbtcedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgbtcins CHECK (dlcomgbtcins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgbtcvsb CHECK (dlcomgbtcvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcddel CHECK (dlcomgcaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcdins CHECK (dlcomgcadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcdvsb CHECK (dlcomgcadvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcndel CHECK (dlcomgcindel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcnedt CHECK (dlcomgcinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcnins CHECK (dlcomgcinins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcnvsb CHECK (dlcomgcinvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcorddverstuurd CHECK (dlcomgcorddverstuurd = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcordocdel CHECK (dlcomgcordocdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcorregdwl CHECK (dlcomgcorregdwl = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcorregtent CHECK (dlcomgcorregtent = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcorregvsb CHECK (dlcomgcorregvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcorverplaats CHECK (dlcomgcorverplaats = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcrdel CHECK (dlcomgcordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcredt CHECK (dlcomgcoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcrins CHECK (dlcomgcorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcrvsb CHECK (dlcomgcorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgdocbevgez CHECK (dlcomgdocbevgez = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgdsoprojdel CHECK (dlcomgdsoprojdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgdsoprojins CHECK (dlcomgdsoprojins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgibedt CHECK (dlcomgibbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgibins CHECK (dlcomgibbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgibvsb CHECK (dlcomgibbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomginsdel CHECK (dlcomginsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomginsedt CHECK (dlcomginsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomginsins CHECK (dlcomginsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomginsovbzdel CHECK (dlcomginsovbzdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomginsvsb CHECK (dlcomginsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomglegexpnot CHECK (dlcomglegexpnot = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomglgdel CHECK (dlcomglegdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomglgedt CHECK (dlcomglegedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomglgins CHECK (dlcomglegins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomglgvsb CHECK (dlcomglegvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgolodel CHECK (dlcomgolodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgoloedt CHECK (dlcomgoloedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgoloins CHECK (dlcomgoloins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgolovsb CHECK (dlcomgolovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgpoahn CHECK (dlcomgproahn = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgpodel CHECK (dlcomgprodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgpoedt CHECK (dlcomgproedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgpoins CHECK (dlcomgproins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgpovdg CHECK (dlcomgprovdg = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgpovsb CHECK (dlcomgprovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgprddel CHECK (dlcomgprddel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgprdedt CHECK (dlcomgprdedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgprdins CHECK (dlcomgprdins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgprodatdel CHECK (dlcomgprodatdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgroebdel CHECK (dlcomgroebdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgroebedt CHECK (dlcomgroebedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgroebins CHECK (dlcomgroebins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgroebvsb CHECK (dlcomgroebvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgtsdel CHECK (dlcomgtstdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgtsedt CHECK (dlcomgtstedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgtsins CHECK (dlcomgtstins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgtsvsb CHECK (dlcomgtstvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgwelstanddel CHECK (dlcomgwelstanddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgwelstandedt CHECK (dlcomgwelstandedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgwelstandins CHECK (dlcomgwelstandins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgwelstandvsb CHECK (dlcomgwelstandvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgzkpdel CHECK (dlcomgzkpdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgzkpedt CHECK (dlcomgzkpedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgzkphoofdedt CHECK (dlcomgzkphoofdedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgzkpins CHECK (dlcomgzkpins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgzkpvsb CHECK (dlcomgzkpvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrechten_dlbomggroepedt CHECK (dlbomggroepedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlbomgsnelins CHECK (dlbomgsnelins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlbomgverspr CHECK (dlbomgverspr = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbezwdel CHECK (dlcomgbezwdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbezwdms CHECK (dlcomgbezwdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbezwedt CHECK (dlcomgbezwedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbezwins CHECK (dlcomgbezwins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbezwvsb CHECK (dlcomgbezwvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbrwdel CHECK (dlcomgbrwdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbrwedt CHECK (dlcomgbrwedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbrwins CHECK (dlcomgbrwins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbrwvsb CHECK (dlcomgbrwvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgcordms CHECK (dlcomgcordms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgcorodt CHECK (dlcomgcorodt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgcorreghnm CHECK (dlcomgcorreghnm = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgcorwmo CHECK (dlcomgcorwmo = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgswfafs CHECK (dlcomgswfafs = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgswfdel CHECK (dlcomgswfdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgswfedt CHECK (dlcomgswfedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgswfins CHECK (dlcomgswfins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgswfvsb CHECK (dlcomgswfvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgtstbcc CHECK (dlcomgtstbcc = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechtenn_dlbomgbevgezedt CHECK (dlbomgbevgezedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omrechten_dlcomgadvuurvsb CHECK (dlcomgadvuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omrechten_dlcomgbezwuurvsb CHECK (dlcomgbezwuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omrechten_dlcomginsuurvsb CHECK (dlcomginsuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omrechten_dlcomguurdel CHECK (dlcomguurdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omrechten_dlcomguuredt CHECK (dlcomguuredt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omrechten_dlcomguurins CHECK (dlcomguurins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omrechten_dlcomguurvsb CHECK (dlcomguurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlbomghlink CHECK (dlbomghlink = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlbomgodedt CHECK (dlbomgodedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlcomgadvdms CHECK (dlcomgadvdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlcomgcorupload CHECK (dlcomgcorupload = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlcomgdwsdel CHECK (dlcomgdwsdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlcomgdwsedt CHECK (dlcomgdwsedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlcomgdwsins CHECK (dlcomgdwsins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlcomgdwsvsb CHECK (dlcomgdwsvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlcomginsdms CHECK (dlcomginsdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlcomginvdel CHECK (dlcomginvdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlcomginvedt CHECK (dlcomginvedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlcomginvins CHECK (dlcomginvins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlcomginvvsb CHECK (dlcomginvvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT cnn_omgrecht_dlbomgafsedt CHECK (dlbomgafsedt IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlbomgwznedt CHECK (dlbomgwznedt IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlbomgztedt CHECK (dlbomgztedt IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgbguidel CHECK (dlcomgbguidel IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgbguiedt CHECK (dlcomgbguiedt IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgbguiins CHECK (dlcomgbguiins IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgbguivsb CHECK (dlcomgbguivsb IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgcorddverstuurd CHECK (dlcomgcorddverstuurd IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgcordocdel CHECK (dlcomgcordocdel IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgcorregdwl CHECK (dlcomgcorregdwl IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgcorregtent CHECK (dlcomgcorregtent IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgcorregvsb CHECK (dlcomgcorregvsb IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgcorverplaats CHECK (dlcomgcorverplaats IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgdocbevgez CHECK (dlcomgdocbevgez IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgdsoprojdel CHECK (dlcomgdsoprojdel IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgdsoprojins CHECK (dlcomgdsoprojins IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgprddel CHECK (dlcomgprddel IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgprdedt CHECK (dlcomgprdedt IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgprdins CHECK (dlcomgprdins IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgprodatdel CHECK (dlcomgprodatdel IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgroebdel CHECK (dlcomgroebdel IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgroebedt CHECK (dlcomgroebedt IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgroebins CHECK (dlcomgroebins IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgroebvsb CHECK (dlcomgroebvsb IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgzkpdel CHECK (dlcomgzkpdel IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgzkpedt CHECK (dlcomgzkpedt IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgzkphoofdedt CHECK (dlcomgzkphoofdedt IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgzkpins CHECK (dlcomgzkpins IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgzkpvsb CHECK (dlcomgzkpvsb IS NOT NULL),
 CONSTRAINT cnn_omgrecht_keyrechten CHECK (dnkeyrechten IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlbomgbevgezedt CHECK (dlbomgbevgezedt IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlbomggroepedt CHECK (dlbomggroepedt IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlbomgsnelins CHECK (dlbomgsnelins IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlbomgverspr CHECK (dlbomgverspr IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgbezwdel CHECK (dlcomgbezwdel IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgbezwdms CHECK (dlcomgbezwdms IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgbezwedt CHECK (dlcomgbezwedt IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgbezwins CHECK (dlcomgbezwins IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgbezwvsb CHECK (dlcomgbezwvsb IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgcordms CHECK (dlcomgcordms IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgcorodt CHECK (dlcomgcorodt IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgcorreghnm CHECK (dlcomgcorreghnm IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgcorwmo CHECK (dlcomgcorwmo IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomginsovbzdel CHECK (dlcomginsovbzdel IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgswfafs CHECK (dlcomgswfafs IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgswfdel CHECK (dlcomgswfdel IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgswfedt CHECK (dlcomgswfedt IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgswfins CHECK (dlcomgswfins IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgswfvsb CHECK (dlcomgswfvsb IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgtstbcc CHECK (dlcomgtstbcc IS NOT NULL),
 CONSTRAINT cnn_omrechten_dlcomgadvuurvsb CHECK (dlcomgadvuurvsb IS NOT NULL),
 CONSTRAINT cnn_omrechten_dlcomgbezwuurvsb CHECK (dlcomgbezwuurvsb IS NOT NULL),
 CONSTRAINT cnn_omrechten_dlcomginsuurvsb CHECK (dlcomginsuurvsb IS NOT NULL),
 CONSTRAINT cnn_omrechten_dlcomguurdel CHECK (dlcomguurdel IS NOT NULL),
 CONSTRAINT cnn_omrechten_dlcomguuredt CHECK (dlcomguuredt IS NOT NULL),
 CONSTRAINT cnn_omrechten_dlcomguurins CHECK (dlcomguurins IS NOT NULL),
 CONSTRAINT cnn_omrechten_dlcomguurvsb CHECK (dlcomguurvsb IS NOT NULL),
 CONSTRAINT cnn_tbomgrechten_dlbomghlink CHECK (dlbomghlink IS NOT NULL),
 CONSTRAINT cnn_tbomgrechten_dlbomgodedt CHECK (dlbomgodedt IS NOT NULL),
 CONSTRAINT cnn_tbomgrechten_dlcomgcorupload CHECK (dlcomgcorupload IS NOT NULL),
 CONSTRAINT cnn_tbomgrechten_dlcomgdwsdel CHECK (dlcomgdwsdel IS NOT NULL),
 CONSTRAINT cnn_tbomgrechten_dlcomgdwsedt CHECK (dlcomgdwsedt IS NOT NULL),
 CONSTRAINT cnn_tbomgrechten_dlcomgdwsins CHECK (dlcomgdwsins IS NOT NULL),
 CONSTRAINT cnn_tbomgrechten_dlcomgdwsvsb CHECK (dlcomgdwsvsb IS NOT NULL),
 CONSTRAINT cnn_tbomgrechten_dlcomginvdel CHECK (dlcomginvdel IS NOT NULL),
 CONSTRAINT cnn_tbomgrechten_dlcomginvedt CHECK (dlcomginvedt IS NOT NULL),
 CONSTRAINT cnn_tbomgrechten_dlcomginvins CHECK (dlcomginvins IS NOT NULL),
 CONSTRAINT cnn_tbomgrechten_dlcomginvvsb CHECK (dlcomginvvsb IS NOT NULL),
 CONSTRAINT cfk_tbomgrechten_keyrechten FOREIGN KEY (dnkeyrechten)
   REFERENCES public.tbrechten(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) ;

COMMENT ON TABLE public.tbomgrechten
IS 'Rechtentabel voor de module omgevingsvergunning';

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

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

COMMENT ON COLUMN public.tbomgrechten.dlbomgedt
IS 'Niveau B Omgevingsvergunning Wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgins
IS 'Niveau B Omgevingsvergunning Nieuwrecht (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgdel
IS 'Niveau B Omgevingsvergunning Verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgverplaats
IS 'Niveau B Omgevingsvergunning Verplaatsrecht.';

COMMENT ON COLUMN public.tbomgrechten.dlbomgblokkedt
IS 'Niveau B Omgevingsvergunning Blokkeerrecht (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgmemovsb
IS 'Niveau B Omgevingsvergunning Memo zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgmemoedt
IS 'Niveau B. Omgevingsvergunning. Memo wijzigen.';

COMMENT ON COLUMN public.tbomgrechten.dlcomginsvsb
IS 'Niveau C Omgevingsvergunning Inspecties zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomginsedt
IS 'Niveau C Omgevingsvergunning Inspecties wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomginsins
IS 'Niveau C Omgevingsvergunning Inspecties nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomginsdel
IS 'Niveau C Omgevingsvergunning Inspecties verwijderrecht (trajecten, overtredingen en bezoeken) (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorvsb
IS 'Niveau C Omgevingsvergunning alle correspondentie zichtbaar (T of F). Default T';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcoredt
IS 'Niveau C Omgevingsvergunning Registreren van documenten en geregistreerde correspondentie wijzigen metadata(T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorins
IS 'Niveau C Omgevingsvergunning correspondentie creeren van document (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcordel
IS 'Niveau C Omgevingsvergunning correspondentie geregisteerde correspondentie verwijderen metadata (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcadvsb
IS 'Niveau C Omgevingsvergunning contactadressen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcadins
IS 'Niveau C Omgevingsvergunning contactadressen koppeling maken (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcaddel
IS 'Niveau C Omgevingsvergunning contactadressen koppeling verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgadvvsb
IS 'Niveau C Omgevingsvergunning adviezen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgadvedt
IS 'Niveau C Omgevingsvergunning adviezen wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgadvins
IS 'Niveau C Omgevingsvergunning adviezen nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgadvdel
IS 'Niveau C Omgevingsvergunning adviezen verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcinvsb
IS 'Niveau C Omgevingsvergunning Correspondentie Binnen Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcinedt
IS 'Niveau C Omgevingsvergunning Correspondentie Binnen Wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcinins
IS 'Niveau C Omgevingsvergunning Correspondentie Binnen Nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcindel
IS 'Niveau C Omgevingsvergunning Correspondentie Binnen Verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgibbvsb
IS 'Niveau C Omgevingsvergunning in behandeling bij zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgibbedt
IS 'Niveau C Omgevingsvergunning in behandeling bij wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgibbins
IS 'Niveau C Omgevingsvergunning in behandeling bij nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgprovsb
IS 'Niveau C Omgevingsvergunning Procedures zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgproedt
IS 'Niveau C Omgevingsvergunning Procedures zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgproins
IS 'Niveau C Omgevingsvergunning Procedures nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgprodel
IS 'Niveau C Omgevingsvergunning procedures verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgproahn
IS 'Niveau C Omgevingsvergunning procedures aanhouden en termijn van orde (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgprovdg
IS 'Niveau C Omgevingsvergunning procedures verdagen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgadvdatedt
IS 'Niveau C. Adviezen. Wijzigrecht kolom DdDateringadvies van tabel TbAdviezen bij Omgevings vergunning (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgadvinedt
IS 'Niveau C. Omgevingsvergunning Adviesinstantie wijzigbaar bij adviezen.';

COMMENT ON COLUMN public.tbomgrechten.dlcomgtstvsb
IS 'Niveau C Omgevingsvergunning Toestemmingen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgtstedt
IS 'Niveau C Omgevingsvergunning Toestemmingen wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgtstins
IS 'Niveau C Omgevingsvergunning Toestemmingen nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgtstdel
IS 'Niveau C Omgevingsvergunning toestemmingen verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomglegvsb
IS 'Niveau C Omgevingsvergunning leges zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomglegedt
IS 'Niveau C Omgevingsvergunning leges wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomglegins
IS 'Niveau C Omgevingsvergunning leges nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomglegdel
IS 'Niveau C Omgevingsvergunning leges verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomglegexpnot
IS 'Niveau C Omgevingsvergunning recht om exportdatum leges te wijzigen n (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgwelstandvsb
IS 'Niveau C Omgevingsvergunning recht om welstandaviezen in te zien (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgwelstandins
IS 'Niveau C Omgevingsvergunning recht om welstandaviezen aan te maken (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgwelstanddel
IS 'Niveau C Omgevingsvergunning recht om welstandaviezen te verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgwelstandedt
IS 'Niveau C Omgevingsvergunning recht om welstandaviezen te muteren (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgverzledt
IS 'Niveau B omg vergunning Verzendlijst maken (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbtcvsb
IS 'Niveau C Omgevingsvergunning Bestemminsplannen toestingscriteria zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbtcedt
IS 'Niveau C Omgevingsvergunning Bestemminsplannen toestingscriteria wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbtcins
IS 'Niveau C Omgevingsvergunning Bestemminsplannen toestingscriteria nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbtcdel
IS 'Niveau C Omgevingsvergunning Bestemminsplannen toestingscriteria verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbrwvsb
IS 'Niveau C Omgevingsvergunning Brandweer (Preparaties en installaties) zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbrwedt
IS 'Niveau C Omgevingsvergunning Brandweer (Preparaties en installaties) wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbrwins
IS 'Niveau C Omgevingsvergunning Brandweer (Preparaties en installaties) nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbrwdel
IS 'Niveau C Omgevingsvergunning Brandweer (Preparaties en installaties) verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgolovsb
IS 'Niveau C Omgevingsvergunning OLO/DSO-Berichten zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgoloedt
IS 'Niveau C Omgevingsvergunning OLO/DSO-Berichten wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgoloins
IS 'Niveau C Omgevingsvergunning OLO/DSO-Berichten nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgolodel
IS 'Niveau C Omgevingsvergunning OLO/DSO-Berichten verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomggroepedt
IS 'Niveau B Omgevingsvergunning. Groepvergunnig maken (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgverspr
IS 'Niveau B Omgevingsvergunning. Mag Complex verspreiden (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgtstbcc
IS 'Niveau C Omgevingsvergunning. Toestemmingen. Mag brandweer cyclische controles maken (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcordms
IS 'Niveau C. Omgevingsvergunning. Correspondentie. DMS-kolom muteerbaar.';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorodt
IS 'Niveau C. Omgevingsvergunning. Correspondentie. Opgeslagen document-kolom muteerbaar.';

COMMENT ON COLUMN public.tbomgrechten.dlbomgsnelins
IS 'Niveau B. Omgevingsvergunning. Mag externe zaaknummers wijzigen (OLO/DSO-nummer, dvintzaakcode en dvzaaknrbevgezag) T of F.';

COMMENT ON COLUMN public.tbomgrechten.dlcomginsdms
IS 'Niveau C. Omgevingsvergunning. Inspecties. Mag externe inspecties-zaaknummers wijzigen:  dvdmszaakcode, dvintzaakcode (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgadvdms
IS 'Niveau C. Omgevingsvergunning. Adviezen. Mag externe advies-zaaknummers wijzigen: dvdmszaakcode, dvintzaakcode (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgodedt
IS 'Niveau B. Omgevingsvergunning. Mag ontvangstdatum wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomghlink
IS 'Niveau B. Omgevingsverunning. Mag hyperlink starten vanuit powerportal omgevingdetail.';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbezwvsb
IS 'Niveau C. Omgevingsverunning. Bezwaar/beroep inzien (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbezwedt
IS 'Niveau C. Omgevingsverunning. Bezwaar/beroep wijzgen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbezwins
IS 'Niveau C. Omgevingsverunning. Bezwaar/beroep insert (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbezwdel
IS 'Niveau C. Omgevingsverunning. Bezwaar/beroep delete (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbezwdms
IS 'Niveau C. Omgevingsverunning. Bezwaar/beroep. dmscode (extern zaakidentificatie) muteren (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgzkpins
IS 'Niveau C. Omgevingsverunning. Kadastrale percelen insert (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgzkpvsb
IS 'Niveau C. Omgevingsverunning. Kadastrale percelen zichtbaar (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgzkpedt
IS 'Niveau C. Omgevingsverunning. Kadastrale percelen wijzigen (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgzkpdel
IS 'Niveau C. Omgevingsverunning. Kadastrale percelen delete (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomguurvsb
IS 'Niveau C. Omgeving. Uren inzien (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomguurins
IS 'Niveau C. Omgeving. Uren insert (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomguurdel
IS 'Niveau C. Omgeving. Uren delete (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomguuredt
IS 'Niveau C. Omgeving. Uren wijzgen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomginsuurvsb
IS 'Niveau C. inspecties bij Omgeving. Uren inzien (T of F), edit- insert- delrechten via dlcomguuredt, dlcomguurins,dlcomguurdel.';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbezwuurvsb
IS 'Niveau C. bezwaar/beroep bij Omgeving. Uren inzien (T of F), edit- insert- delrechten via dlcomguuredt, dlcomguurins,dlcomguurdel.';

COMMENT ON COLUMN public.tbomgrechten.dlcomgadvuurvsb
IS 'Niveau C. adviezen bij Omgeving. Uren inzien (T of F), edit- insert- delrechten via dlcomguuredt, dlcomguurins,dlcomguurdel.';

COMMENT ON COLUMN public.tbomgrechten.dlbomgafsedt
IS 'Niveau B  Omgeving gevulde afhandeldatum wijzigen en dit geldt ook voor gevulde externe zaak einddatum (dddmsafgehandeld) bij deelzaken advies, inspecties en bezwaarberoep die aan Omgeving zijn gekoppeld(T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbguiins
IS 'Niveau C Omgeving Insert historie bevoegdgezag/uitv inst (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbguiedt
IS 'Niveau C Omgeving wijzigen historie bevoegdgezag/uitv inst (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbguidel
IS 'Niveau C Omgeving delete historie bevoegdgezag/uitv inst (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbguivsb
IS 'Niveau C Omgeving zichtbaar historie bevoegdgezag/uitv inst (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorregvsb
IS 'Niveau C Omgeving Geregistreerde documenten zichtbaar (T of F). Default T.';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorregdwl
IS 'Niveau C Omgeving Geregistreerde documenten Mag geforceerd downloaden (T of F). Default F.';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcordocdel
IS 'Niveau C Omgeving geregisteerde correspondentie verwijderen fysiek document(T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorwmo
IS 'Niveau C Omgeving Wijzigen metadata (hernoemen filenaam) ongeregistreerde documenten (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorreghnm
IS 'Niveau C Omgeving Hernoemen geregistreerde documenten.';

COMMENT ON COLUMN public.tbomgrechten.dlcomgprdedt
IS 'Niveau C Omgevingsvergunning Product/Dienst wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomginsovbzdel
IS 'Niveau C Omgevingsvergunning. Alleen inspectiebezoeken en overtredingen verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgswfins
IS 'Niveau C. Omgeving. mag samenwerkingsruimte aanmaken (ook in SWF).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgswfedt
IS 'Niveau C. Omgeving. samenwerkingsruimte wijzgen (T of F.)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgswfdel
IS 'Niveau C. Omgeving. samenwerkingsruimte delete (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgswfvsb
IS 'Niveau C. Omgeving. samenwerkingsruimte inzien (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgswfafs
IS 'Niveau C. Omgeving. mag samenwerkingsruimte afsluiten/verwijderen in SWF.';

COMMENT ON COLUMN public.tbomgrechten.dlcomgprdins
IS 'Niveau C Omgevingsvergunning Product/Dienst toevoegen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgprddel
IS 'Niveau C Omgevingsvergunning Product/Dienst verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgwznedt
IS 'Niveau B. Omgevingsvergunning. Mag Wavezaaknummer (dvzaakcode) wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgztedt
IS 'Niveau B. Omgevingsvergunning. Mag soort aanvraag wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorregtent
IS 'Niveau C. Omgeving. wijzigrecht (externe) tbcorrespondentie.dvexttracktrace.';

COMMENT ON COLUMN public.tbomgrechten.dlcomgzkphoofdedt
IS 'Niveau C. Omgevingsvergunning. Mag hoofdprojectlocatie-indicatie wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorupload
IS 'Niveau C Omgevingsvergunning correspondentie uploaden van document (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorverplaats
IS 'Niveau C. Omgevingsvergunning. Mag document verplaatsen in documenttree (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgbevgezedt
IS 'Niveau B, Omgevingszaak, Mag bevoegd gezag of behandeldienst aanpassen.';

COMMENT ON COLUMN public.tbomgrechten.dlcomgdocbevgez
IS 'Niveau B, Omgevingszaak, Mag export straten en lijst zien van documenten behorende bij een DSO-zaak die vanaf speciale map naar bevoegdgezag moeten via zaak/dms.';

COMMENT ON COLUMN public.tbomgrechten.dlcomgprodatdel
IS 'Niveau C Omgevingsvergunning procedures gevulde Afhandeldatum wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgdwsvsb
IS 'Niveau C. Omgeving. bestuurlijke maatreg inzien (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgdwsins
IS 'Niveau C. Omgeving. mag bestuurlijke maatreg aanmaken (ook in SWF).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgdwsedt
IS 'Niveau C. Omgeving. bestuurlijke maatreg wijzgen (T of F.)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgdwsdel
IS 'Niveau C. Omgeving. bestuurlijke maatreg delete (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomginvvsb
IS 'Niveau C. Omgeving. invorderingen inzien (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomginvins
IS 'Niveau C. Omgeving. mag invorderingen aanmaken (ook in SWF).';

COMMENT ON COLUMN public.tbomgrechten.dlcomginvedt
IS 'Niveau C. Omgeving. invorderingen wijzgen (T of F.)';

COMMENT ON COLUMN public.tbomgrechten.dlcomginvdel
IS 'Niveau C. Omgeving. invorderingen delete (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgdsoprojins
IS ' Niveau C. Omgeving. Zaak koppelen aan DSO-project (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgdsoprojdel
IS ' Niveau C. Omgeving. Zaak ontkoppelen van DSO-project (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorddverstuurd
IS 'Niveau C Omgeving. Geregistreerde documenten ddverstuurd (tbcorrespondentie.ddbriefdatum) wijzigen indien verzendwijze per post (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgroebins
IS ' Niveau C. Omgeving. ROEB-regel aanmaken bij activiteit (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgroebvsb
IS ' Niveau C. Omgeving. Inzien ROEB-regels bij activiteit (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgroebedt
IS ' Niveau C. Omgeving. Wijzigen ROEB-regels bij activiteit (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgroebdel
IS ' Niveau C. Omgeving. ROEB-regel verwijderen bij activiteit (T of F).';

CREATE UNIQUE INDEX idu_omgrechten_keyrechten ON public.tbomgrechten
 USING btree (dnkeyrechten);