Datadictionary OpenWave 3.1.11

Table: tbrechten

Schema

public

Owner

waveuser005

Tablespace

(default)

Descriptions

Rechtentabel voor de module bouw/sloop en voor moduleoverstijgende rechten

Fields

Foreign Keys

There are no foreign keys for table tbrechten

Check Constraints

Indices

Triggers

There are no triggers for table tbrechten

Rules

There are no rules for table tbrechten

Referenced

Properties

Definition

CREATE TABLE public.tbrechten (
 dnkey SERIAL,
 dvgroep VARCHAR(20),
 dvgroepoms VARCHAR(100),
 ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
 dnrapportageniveau INTEGER,
 dlabwvvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlaovvvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlahahvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlahorvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlabplvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlaextvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlainfovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlaadrvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlamnuvergvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlamnuzoekvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlamnuafdrvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlamnuinstvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlamnubeeldvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlamldavsb CHAR(1) DEFAULT 'F'::bpchar,
 dlamldivsb CHAR(1) DEFAULT 'F'::bpchar,
 dlaspvvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlaexpvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvins CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvblokkedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvverzledt CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvgroepedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvmemovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvverspr CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvsnelins CHAR(1) DEFAULT 'T'::bpchar,
 dlbbwvabedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvkopie CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvmemoedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvverplaats CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvodedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvibbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvibbedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvibbins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvprovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvproedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvproins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvprodel CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvbspvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvbspedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvbspins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvbspdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvadvvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvadvedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvadvins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvadvdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvinsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvinsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvinsins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvinsdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvcorvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvcoredt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvcorins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvcordel CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvcadvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvcadins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvcaddel CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvlegvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvlegedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvlegins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvlegdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvcinvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvcinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvcinins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvcindel CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvcompr CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvproahn CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvprovdg CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvadvinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvlegexpnot CHAR(1) DEFAULT 'F'::bpchar,
 dlcextcbs11vsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcextcbs11edt CHAR(1) DEFAULT 'F'::bpchar,
 dlcextcbs11ins CHAR(1) DEFAULT 'F'::bpchar,
 dlcextcbs11del CHAR(1) DEFAULT 'F'::bpchar,
 dlcextcbs11disk CHAR(1) DEFAULT 'F'::bpchar,
 dlcextcbs15vsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcextcbs15edt CHAR(1) DEFAULT 'F'::bpchar,
 dlcextcbs15ins CHAR(1) DEFAULT 'F'::bpchar,
 dlcextcbs15del CHAR(1) DEFAULT 'F'::bpchar,
 dlcextcbs15disk CHAR(1) DEFAULT 'F'::bpchar,
 dlcextcbs55vsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcextcbs55edt CHAR(1) DEFAULT 'F'::bpchar,
 dlcextcbs55ins CHAR(1) DEFAULT 'F'::bpchar,
 dlcextcbs55del CHAR(1) DEFAULT 'F'::bpchar,
 dlcextcbs55disk CHAR(1) DEFAULT 'F'::bpchar,
 dlcextfisimp CHAR(1) DEFAULT 'F'::bpchar,
 dlcextfisexp CHAR(1) DEFAULT 'F'::bpchar,
 dldvgdedt CHAR(1) DEFAULT 'F'::bpchar,
 dldpcledt CHAR(1) DEFAULT 'F'::bpchar,
 dldcadins CHAR(1) DEFAULT 'F'::bpchar,
 dldcadedt CHAR(1) DEFAULT 'F'::bpchar,
 dldcaddel CHAR(1) DEFAULT 'F'::bpchar,
 dldpclins CHAR(1) DEFAULT 'F'::bpchar,
 dldpcldel CHAR(1) DEFAULT 'F'::bpchar,
 dlerapbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlerapovsb CHAR(1) DEFAULT 'F'::bpchar,
 dleraphvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlerapavsb CHAR(1) DEFAULT 'F'::bpchar,
 dlerapcvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlerapsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlerapmvsb CHAR(1) DEFAULT 'F'::bpchar,
 dledocavsb CHAR(1) DEFAULT 'F'::bpchar,
 dledocovsb CHAR(1) DEFAULT 'F'::bpchar,
 dledocbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dledochvsb CHAR(1) DEFAULT 'F'::bpchar,
 dledoccvsb CHAR(1) DEFAULT 'F'::bpchar,
 dledocmvsb CHAR(1) DEFAULT 'F'::bpchar,
 dledocsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlerapivsb CHAR(1) DEFAULT 'F'::bpchar,
 dledocivsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvadvdatedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvwelstandvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvwelstandedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvwelstanddel CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvwelstandins CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvwelsttabvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvwelsttabedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvmdedt CHAR(1) DEFAULT 'T'::bpchar,
 dlamilvsb CHAR(1) DEFAULT 'F'::bpchar,
 dleraplvsb CHAR(1) DEFAULT 'F'::bpchar,
 dledoclvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvvhbedt CHAR(1) DEFAULT 'F'::bpchar,
 dlaomgvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlerapwvsb CHAR(1) DEFAULT 'F'::bpchar,
 dledocwvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlamldgvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlakritlijstadv CHAR(1) DEFAULT 'F'::bpchar,
 dlakritlijstfat CHAR(1) DEFAULT 'F'::bpchar,
 dlakritlijstins CHAR(1) DEFAULT 'F'::bpchar,
 dlakritlijstinv CHAR(1) DEFAULT 'F'::bpchar,
 dlakritlijstkla CHAR(1) DEFAULT 'F'::bpchar,
 dlakritlijstlog CHAR(1) DEFAULT 'F'::bpchar,
 dlakritlijstvlp CHAR(1) DEFAULT 'F'::bpchar,
 dnakritlijstperv INTEGER DEFAULT 15,
 dnakritlijstpera INTEGER DEFAULT 15,
 dlakritlijstprs CHAR(1) DEFAULT 'F'::bpchar,
 dlakritlijstavp CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvbrwvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvbrwedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvbrwins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvbrwdel CHAR(1) DEFAULT 'F'::bpchar,
 dldpclbag CHAR(1) DEFAULT 'F'::bpchar,
 dldcadbra CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvcordms CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvcorodt CHAR(1) DEFAULT 'F'::bpchar,
 dldcasam CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvinsdms CHAR(1) DEFAULT 'F'::bpchar,
 dlcbwvadvdms CHAR(1) DEFAULT 'F'::bpchar,
 dlbbwvhlink CHAR(1) DEFAULT 'F'::bpchar,
 dlaispubliekgroep CHAR(1) DEFAULT 'F'::bpchar,
 dlamilvergvsb CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tbrechten PRIMARY KEY(dnkey),
 CONSTRAINT chk_rechten_akritlijstadv CHECK (dlakritlijstadv = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_akritlijstfat CHECK (dlakritlijstfat = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_akritlijstins CHECK (dlakritlijstins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_akritlijstinv CHECK (dlakritlijstinv = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_akritlijstkla CHECK (dlakritlijstkla = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_akritlijstlog CHECK (dlakritlijstlog = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_akritlijstprs CHECK (dlakritlijstprs = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_akritlijstvlp CHECK (dlakritlijstvlp = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_bwvadvdatedt CHECK (dlcbwvadvdatedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlaadrvsb CHECK (dlaadrvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlabplvsb CHECK (dlabplvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlabwvvsb CHECK (dlabwvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlaexpvsb CHECK (dlaexpvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlaextvsb CHECK (dlaextvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlahahvsb CHECK (dlahahvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlahorvsb CHECK (dlahorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlainfovsb CHECK (dlainfovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlaispubliekgroep CHECK (dlaispubliekgroep = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_rechten_dlakritlijstavp CHECK (dlakritlijstavp = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlamilvergvsb CHECK (dlamilvergvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_rechten_dlamilvsb CHECK (dlamilvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlamldavsb CHECK (dlamldavsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlamldgvsb CHECK (dlamldgvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlamldivsb CHECK (dlamldivsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlamnuafdrvsb CHECK (dlamnuafdrvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlamnubeeldvsb CHECK (dlamnubeeldvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlamnuinstvsb CHECK (dlamnuinstvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlamnuvergvsb CHECK (dlamnuvergvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlamnuzoekvsb CHECK (dlamnuzoekvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlaomgvsb CHECK (dlaomgvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlaovvvsb CHECK (dlaovvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlaspvvsb CHECK (dlaspvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlbbwvabedt CHECK (dlbbwvabedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlbbwvblokkedt CHECK (dlbbwvblokkedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlbbwvdel CHECK (dlbbwvdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlbbwvedt CHECK (dlbbwvedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlbbwvgroepedt CHECK (dlbbwvgroepedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlbbwvins CHECK (dlbbwvins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlbbwvkopie CHECK (dlbbwvkopie = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlbbwvmdedt CHECK (dlbbwvmdedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlbbwvmemoedt CHECK (dlbbwvmemoedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlbbwvmemovsb CHECK (dlbbwvmemovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlbbwvodedt CHECK (dlbbwvodedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlbbwvsnelins CHECK (dlbbwvsnelins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlbbwvverplaats CHECK (dlbbwvverplaats = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlbbwvverspr CHECK (dlbbwvverspr = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlbbwvverzledt CHECK (dlbbwvverzledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlbbwvvhbedt CHECK (dlbbwvvhbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvadvdel CHECK (dlcbwvadvdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvadvedt CHECK (dlcbwvadvedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvadvinedt CHECK (dlcbwvadvinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvadvins CHECK (dlcbwvadvins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvadvvsb CHECK (dlcbwvadvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvbrwdel CHECK (dlcbwvbrwdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvbrwedt CHECK (dlcbwvbrwedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvbrwins CHECK (dlcbwvbrwins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvbrwvsb CHECK (dlcbwvbrwvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvbspdel CHECK (dlcbwvbspdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvbspedt CHECK (dlcbwvbspedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvbspins CHECK (dlcbwvbspins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvbspvsb CHECK (dlcbwvbspvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvcaddel CHECK (dlcbwvcaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvcadins CHECK (dlcbwvcadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvcadvsb CHECK (dlcbwvcadvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvcindel CHECK (dlcbwvcindel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvcinedt CHECK (dlcbwvcinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvcinins CHECK (dlcbwvcinins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvcinvsb CHECK (dlcbwvcinvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvcompr CHECK (dlcbwvcompr = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvcordel CHECK (dlcbwvcordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvcordms CHECK (dlcbwvcordms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvcoredt CHECK (dlcbwvcoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvcorins CHECK (dlcbwvcorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvcorodt CHECK (dlcbwvcorodt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvcorvsb CHECK (dlcbwvcorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvibbedt CHECK (dlcbwvibbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvibbins CHECK (dlcbwvibbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvibbvsb CHECK (dlcbwvibbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvinsdel CHECK (dlcbwvinsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvinsedt CHECK (dlcbwvinsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvinsins CHECK (dlcbwvinsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvinsvsb CHECK (dlcbwvinsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvlegdel CHECK (dlcbwvlegdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvlegedt CHECK (dlcbwvlegedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvlegexpnot CHECK (dlcbwvlegexpnot = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvlegins CHECK (dlcbwvlegins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvlegvsb CHECK (dlcbwvlegvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvproahn CHECK (dlcbwvproahn = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvprodel CHECK (dlcbwvprodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvproedt CHECK (dlcbwvproedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvproins CHECK (dlcbwvproins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvprovdg CHECK (dlcbwvprovdg = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcbwvprovsb CHECK (dlcbwvprovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextcbs11del CHECK (dlcextcbs11del = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextcbs11disk CHECK (dlcextcbs11disk = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextcbs11edt CHECK (dlcextcbs11edt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextcbs11ins CHECK (dlcextcbs11ins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextcbs11vsb CHECK (dlcextcbs11vsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextcbs15del CHECK (dlcextcbs15del = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextcbs15disk CHECK (dlcextcbs15disk = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextcbs15edt CHECK (dlcextcbs15edt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextcbs15ins CHECK (dlcextcbs15ins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextcbs15vsb CHECK (dlcextcbs15vsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextcbs55del CHECK (dlcextcbs55del = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextcbs55disk CHECK (dlcextcbs55disk = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextcbs55edt CHECK (dlcextcbs55edt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextcbs55ins CHECK (dlcextcbs55ins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextcbs55vsb CHECK (dlcextcbs55vsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextfisexp CHECK (dlcextfisexp = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlcextfisimp CHECK (dlcextfisimp = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dldcadbra CHECK (dldcadbra = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dldcaddel CHECK (dldcaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dldcadedt CHECK (dldcadedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dldcadins CHECK (dldcadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dldcasam CHECK (dldcasam = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dldpclbag CHECK (dldpclbag = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dldpcldel CHECK (dldpcldel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dldpcledt CHECK (dldpcledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dldpclins CHECK (dldpclins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dldvgdedt CHECK (dldvgdedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dledocavsb CHECK (dledocavsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dledocbvsb CHECK (dledocbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dledoccvsb CHECK (dledoccvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dledochvsb CHECK (dledochvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dledocivsb CHECK (dledocivsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dledoclvsb CHECK (dledoclvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dledocmvsb CHECK (dledocmvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dledocovsb CHECK (dledocovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dledocsvsb CHECK (dledocsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dledocwvsb CHECK (dledocwvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlerapavsb CHECK (dlerapavsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlerapbvsb CHECK (dlerapbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlerapcvsb CHECK (dlerapcvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dleraphvsb CHECK (dleraphvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlerapivsb CHECK (dlerapivsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dleraplvsb CHECK (dleraplvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlerapmvsb CHECK (dlerapmvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlerapovsb CHECK (dlerapovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlerapsvsb CHECK (dlerapsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_dlerapwvsb CHECK (dlerapwvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_welstdel CHECK (dlcbwvwelstanddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_welstedt CHECK (dlcbwvwelstandedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_welstins CHECK (dlcbwvwelstandins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_welsttabedt CHECK (dlbbwvwelsttabedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_welsttabvsb CHECK (dlbbwvwelsttabvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_rechten_welstvsb CHECK (dlcbwvwelstandvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbrechten_dlbbwvhlink CHECK (dlbbwvhlink = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbrechten_dlcbwvadvdms CHECK (dlcbwvadvdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbrechten_dlcbwvinsdms CHECK (dlcbwvinsdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT cnn_rechten_dlaispubliekgroep CHECK (dlaispubliekgroep IS NOT NULL),
 CONSTRAINT cnn_rechten_dlamilvergvsb CHECK (dlamilvergvsb IS NOT NULL),
 CONSTRAINT cnn_rechten_dlcbwvcordms CHECK (dlcbwvcordms IS NOT NULL),
 CONSTRAINT cnn_rechten_dlcbwvcorodt CHECK (dlcbwvcorodt IS NOT NULL),
 CONSTRAINT cnn_rechten_groep CHECK (dvgroep IS NOT NULL),
 CONSTRAINT cnn_tbrechten_dlbbwvhlink CHECK (dlbbwvhlink IS NOT NULL)
)
WITH (oids = false);

COMMENT ON TABLE public.tbrechten
IS 'Rechtentabel voor de module bouw/sloop en voor moduleoverstijgende rechten';

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

COMMENT ON COLUMN public.tbrechten.dvgroep
IS 'Groepsaanduiding. Uniek.';

COMMENT ON COLUMN public.tbrechten.dvgroepoms
IS 'Groepsomschrijving.';

COMMENT ON COLUMN public.tbrechten.ddvervaldatum
IS 'Vervaldatum.';

COMMENT ON COLUMN public.tbrechten.dnrapportageniveau
IS 'Rapportageniveau. Wordt niet meer gebruikt. Zie tbmedewerkers';

COMMENT ON COLUMN public.tbrechten.dlabwvvsb
IS 'Niveau A Bouwvergunningen. Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlaovvvsb
IS 'Niveau A OverigeVergunningen. Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlahahvsb
IS 'Niveau A Handhavingen. Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlahorvsb
IS 'Niveau A HorecaVergunningen. Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlabplvsb
IS 'Niveau A Bestemmingsplannen. Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlaextvsb
IS 'Niveau A Externe koppelingen. Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlainfovsb
IS 'Niveau A Infovergunningen zichtbaar (Tof F).';

COMMENT ON COLUMN public.tbrechten.dlaadrvsb
IS 'Niveau A. Adresboek zichtbaar (Tof F).';

COMMENT ON COLUMN public.tbrechten.dlamnuvergvsb
IS 'Niveau A. Menublok vergunningen zichtbaar (Tof F).';

COMMENT ON COLUMN public.tbrechten.dlamnuzoekvsb
IS 'Niveau A. Menublok zoeken zichtbaar (Tof F).';

COMMENT ON COLUMN public.tbrechten.dlamnuafdrvsb
IS 'Niveau A. Menublok afdrukken zichtbaar (Tof F).';

COMMENT ON COLUMN public.tbrechten.dlamnuinstvsb
IS 'Niveau A. Menublok instellingen zichtbaar (Tof F).';

COMMENT ON COLUMN public.tbrechten.dlamnubeeldvsb
IS 'Niveau A. Menublok beeld zichtbaar (Tof F).';

COMMENT ON COLUMN public.tbrechten.dlamldavsb
IS 'Niveau A Recht op takenlijst Allen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlamldivsb
IS 'Niveau A Recht op takenlijst Individueel (T  of F).';

COMMENT ON COLUMN public.tbrechten.dlaspvvsb
IS 'Niveau A (Modulebar). Lokatieadressen zichtbaar.';

COMMENT ON COLUMN public.tbrechten.dlaexpvsb
IS 'Niveau A Exporteren Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvedt
IS 'Niveau B BouwVerg Wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvins
IS 'Niveau B BouwVerg Nieuwrecht (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvdel
IS 'Niveau B BouwVerg Verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvblokkedt
IS 'Niveau B BouwVerg Verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvverzledt
IS 'Niveau B BouwVerg. Verzendlijst maken  (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvgroepedt
IS 'Niveau B BouwVerg. Groepvergunigen maken  (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvmemovsb
IS 'Niveau B Bouwverg. Memo (notiteis) zichtbaar  (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvverspr
IS 'Niveau B Bouwvergunningen. Mag (Complex) verspreiden (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvsnelins
IS 'Niveau B Bouwvergunningen Mag kolom dvdmscode wijzigen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvabedt
IS 'Niveau B Bouwvergunningen. Mag aard besluit en besluitdatum muteren. (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvkopie
IS 'Niveau B Bouw/sloop vergunningen. Kopieerrecht (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvmemoedt
IS 'Niveau B. Bouwvergunningen. Memo (notities) wijzigen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvverplaats
IS 'Niveau B. Bouwvergunningen. Mag vergunning verplaatsen naar ander adres (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvodedt
IS 'Niveau B. Bouw/sloop vergunningen. Ontvangsdatum en soort vergunning en vergunningsnummer wijzigbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvibbvsb
IS 'Niveau C bouwvergunning Ibb zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvibbedt
IS 'Niveau C bouwvergunning Ibb wijzigen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvibbins
IS 'Niveau C bouwvergunning Ibb nieuw (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvprovsb
IS 'Niveau C bouwvergunning Procedures zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvproedt
IS 'Niveau C bouwvergunning Procedures wijzigen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvproins
IS 'Niveau C bouwvergunning Procedures nieuw (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvprodel
IS 'Niveau C bouwvergunning Procedures verwijderen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvbspvsb
IS 'Niveau C bouwvergunning Bestemmingsplannen (afw en vrijst) zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvbspedt
IS 'Niveau C bouwvergunning Bestemmingsplannen (afw en vrijst) wijzigen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvbspins
IS 'Niveau C bouwvergunning Bestemminghsplannen (afw en vrijst) nieuw (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvbspdel
IS 'Niveau C bouwvergunning Bestemmingsplan (afw en vrijst) verwijderen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvadvvsb
IS 'Niveau C bouwvergunning Adviezen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvadvedt
IS 'Niveau C bouwvergunning Adviezen wijzigen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvadvins
IS 'Niveau C bouwvergunning Adviezen nieuw (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvadvdel
IS 'Niveau C bouwvergunning Adviezen verwijderen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvinsvsb
IS 'Niveau C bouwvergunning Inspecties zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvinsedt
IS 'Niveau C bouwvergunning Inspecties wijzigen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvinsins
IS 'Niveau C bouwvergunning Inspecties nieuw (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvinsdel
IS 'Niveau C bouwvergunning Inspecties verwijderen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvcorvsb
IS 'Niveau C bouwvergunning correspondentie zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvcoredt
IS 'Niveau C bouwvergunning correspondentie wijzigen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvcorins
IS 'Niveau C bouwvergunning correspondentie nieuw (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvcordel
IS 'Niveau C bouwvergunning correspondentie verwijderen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvcadvsb
IS 'Niveau C bouwvergunning contactadressen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvcadins
IS 'Niveau C bouwvergunning contactadressen koppeling maken (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvcaddel
IS 'Niveau C bouwvergunning contactadressen koppeling verwijderen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvlegvsb
IS 'Niveau C bouwvergunning Leges zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvlegedt
IS 'Niveau C bouwvergunning Leges wijzigen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvlegins
IS 'Niveau C bouwvergunning Leges nieuw (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvlegdel
IS 'Niveau C bouwvergunning Leges verwijderen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvcinvsb
IS 'Niveau C Bouw/sloop vergunningen Correspondentie Binnen Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvcinedt
IS 'Niveau C Bouw/sloop vergunningen Correspondentie Binnen Wijzigen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvcinins
IS 'Niveau C Bouw/sloop vergunningen Correspondentie Binnen Nieuw (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvcindel
IS 'Niveau C Bouw/sloop vergunningen Correspondentie Binnen Verwijderen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvcompr
IS '(Niveau C Bouw/sloop vergunningen Compressie Termijnbewaking.) Wordt niet gebruikt.';

COMMENT ON COLUMN public.tbrechten.dlcbwvproahn
IS 'Niveau C bouwvergunning Procedures aanhouden en termijn van orde (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvprovdg
IS 'Niveau C bouwvergunning Procedures  verdagen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvadvinedt
IS 'Niveau C. Bouw/sloop vergunningen. Adviesinstantie wijzigbaar.';

COMMENT ON COLUMN public.tbrechten.dlcbwvlegexpnot
IS 'Niveau C. Bouwvergunningen Leges Notanummer en Exportdatum muteerbaar.';

COMMENT ON COLUMN public.tbrechten.dlcextcbs11vsb
IS 'Niveau C CBS-11 Inzien (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcextcbs11edt
IS 'Niveau C CBS-11 wijzigen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcextcbs11ins
IS 'Niveau C CBS-11  nieuw (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcextcbs11del
IS 'Niveau C CBS-11 verwijderen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcextcbs11disk
IS 'Niveau C CBS-11 maken diskette recht (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcextcbs15vsb
IS 'Niveau C CBS-11. Inzien (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcextcbs15edt
IS 'Niveau C CBS-11 wijzigen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcextcbs15ins
IS 'Niveau C CBS-11 nieuw (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcextcbs15del
IS 'Niveau C CBS-11 verwijderen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcextcbs15disk
IS 'Niveau C CBS-11 maken diskette recht (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcextcbs55vsb
IS 'Niveau C CBS-55. Inzien (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcextcbs55edt
IS 'Niveau C CBS-55 wijzigen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcextcbs55ins
IS 'Niveau C CBS-55 nieuw (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcextcbs55del
IS 'Niveau C CBS-55 verwijderen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcextcbs55disk
IS 'Niveau C CBS-55 maken diskette recht (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcextfisimp
IS 'Niveau C FIS Import (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcextfisexp
IS 'Niveau C FIS Export (T of F).';

COMMENT ON COLUMN public.tbrechten.dldvgdedt
IS 'Niveau D. Perceeladressen samenvoegen (T of F).';

COMMENT ON COLUMN public.tbrechten.dldpcledt
IS 'Niveau D Perceeladres wijzigen (T of F).';

COMMENT ON COLUMN public.tbrechten.dldcadins
IS 'Niveau D Contactadres nieuw (T of F).';

COMMENT ON COLUMN public.tbrechten.dldcadedt
IS 'Niveau D Contactadres wijzig (T of F).';

COMMENT ON COLUMN public.tbrechten.dldcaddel
IS 'Niveau D Contactadres vervallen (T of F)';

COMMENT ON COLUMN public.tbrechten.dldpclins
IS 'Niveau D Perceeladres toevoegen (T of F).';

COMMENT ON COLUMN public.tbrechten.dldpcldel
IS 'Niveau D Perceeladres Vervallen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlerapbvsb
IS 'Niveau E Rapportages Bouwvergunning Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlerapovsb
IS 'Niveau E Rapportages Overige vergunning Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dleraphvsb
IS 'Niveau E Rapportages Handhaving Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlerapavsb
IS 'Niveau E Rapportages Algemeen Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlerapcvsb
IS 'Niveau E Rapportages Horeca Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlerapsvsb
IS 'Niveau E Rapportages Bestemmingsplan Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlerapmvsb
IS 'Niveau E Rapportages Management Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dledocavsb
IS 'Niveau E. Trekmenu Algemene Documenten Algemeen Zichtbaar (T of F). (Zie TbDocumentsoorten kolom DvInDElenIn).';

COMMENT ON COLUMN public.tbrechten.dledocovsb
IS 'Niveau E. Trekmenu Algemene Documenten Overige Zichtbaar (T of F). (Zie TbDocumentsoorten kolom DvInDElenIn).';

COMMENT ON COLUMN public.tbrechten.dledocbvsb
IS 'Niveau E. Trekmenu Algemene Documenten Bouw/sloop Zichtbaar (T of F). (Zie TbDocumentsoorten kolom DvInDElenIn).';

COMMENT ON COLUMN public.tbrechten.dledochvsb
IS 'Niveau E. Trekmenu Algemene Documenten Handhavingen Zichtbaar (T of F). (Zie TbDocumentsoorten kolom DvInDElenIn).';

COMMENT ON COLUMN public.tbrechten.dledoccvsb
IS 'Niveau E. Trekmenu Algemene Documenten Horeca Zichtbaar (T of F). (Zie TbDocumentsoorten kolom DvInDElenIn).';

COMMENT ON COLUMN public.tbrechten.dledocmvsb
IS 'Niveau E.  Trekmenu Algemene Documenten Management Zichtbaar (T of F). (Zie TbDocumentsoorten kolom DvInDElenIn)';

COMMENT ON COLUMN public.tbrechten.dledocsvsb
IS 'Niveau E.  Trekmenu Algemene Documenten Bestemmingsplan Zichtbaar (T of F). (Zie TbDocumentsoorten kolom DvInDElenIn)';

COMMENT ON COLUMN public.tbrechten.dlerapivsb
IS 'Niveau E Rapportages Infomodule Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dledocivsb
IS 'Niveau E Algemene documenten InfoModule zichtbaar of niet (T of F). (Zie TbDocumentsoorten kolom DvInDElenIn)';

COMMENT ON COLUMN public.tbrechten.dlcbwvadvdatedt
IS 'Niveau C. Adviezen. Wijzigrecht kolom DdDateringadvies van tabel TbAdviezen bij bouw/sloop (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvwelstandvsb
IS 'Niveau C. kolommen op subtabblad Welstandadviezen bij adviezen. Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvwelstandedt
IS 'Niveau C. kolommen op subtabblad Welstandadviezen bij adviezen muteerbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvwelstanddel
IS 'Niveau C. kolommen op subtabblad Welstandadviezen bij adviezen verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvwelstandins
IS 'Niveau C. kolommen op subtabblad Welstandadviezen bij adviezen. Nieuw maken  (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvwelsttabvsb
IS 'Niveau B. tabbald van detailscherm met de welstandskolommen van Tbbouwverg. Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvwelsttabedt
IS 'Niveau B. tabbald van detailscherm met de welstandskolommen van Tbbouwverg. Muteerbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlbbwvmdedt
IS 'Niveau B. Bouw/sloop vergunningen. Meetdatum wijzigbaar (en mag termijnbewaking herberekenen) (T of F).';

COMMENT ON COLUMN public.tbrechten.dlamilvsb
IS 'Milieuinrichtingen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dleraplvsb
IS 'Niveau E Rapportgaes. Milieumodule zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dledoclvsb
IS 'Niveau E Trekmenu Algemene documenten Milieumodule zichtbaar (T of F) (zie tbdocumentsoorten kolom DvIndelenIn).';

COMMENT ON COLUMN public.tbrechten.dlbbwvvhbedt
IS 'Niveau B. Bouwvergunningen. Mag vastgestelde en herziene bouwkosten muteren (T of F).';

COMMENT ON COLUMN public.tbrechten.dlaomgvsb
IS 'Omgevingsvergunning zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlerapwvsb
IS 'Niveau E Rapportages omgevinsgsmodule Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dledocwvsb
IS 'Niveau E. Trekmenu Algemene Documenten Omgevinsgvergunning Zichtbaar (T of F). (Zie TbDocumentsoorten kolom DvInDElenIn).';

COMMENT ON COLUMN public.tbrechten.dlamldgvsb
IS 'Niveau A Recht op Kritieke datumslijst Rechtengroep (T of F).';

COMMENT ON COLUMN public.tbrechten.dlakritlijstadv
IS 'Niveau A. Kritieke termijnlijst default. Type Rappeldatums adviezen aangevinkt.';

COMMENT ON COLUMN public.tbrechten.dlakritlijstfat
IS 'Niveau A. Kritieke termijnlijst default. Type Deadline afhandeling beschikking beschikking aangevinkt.';

COMMENT ON COLUMN public.tbrechten.dlakritlijstins
IS 'Niveau A. Kritieke termijnlijst default. Type Geplande inspectiedatum aangevinkt.';

COMMENT ON COLUMN public.tbrechten.dlakritlijstinv
IS 'Niveau A. Kritieke termijnlijst default. Type Openstaande invorderingen aangevinkt.';

COMMENT ON COLUMN public.tbrechten.dlakritlijstkla
IS 'Niveau A. Kritieke termijnlijst default. Type Niet afgehandelde klachten aangevinkt.';

COMMENT ON COLUMN public.tbrechten.dlakritlijstlog
IS 'Niveau A. Kritieke termijnlijst default. Type Logboekmeldingen.';

COMMENT ON COLUMN public.tbrechten.dlakritlijstvlp
IS 'Niveau A. Kritieke termijnlijst default. Type Verloopdatums tijd. vergunning aangevinkt.';

COMMENT ON COLUMN public.tbrechten.dnakritlijstperv
IS 'Niveau A. Kritieke termijnlijst periode Aantal dagen dat vanaf de systeemdatum vooruit gekeken dient te worden.';

COMMENT ON COLUMN public.tbrechten.dnakritlijstpera
IS 'Niveau A. Kritieke termijnlijst periode Aantal dagen dat vanaf de systeemdatum achterruit gekeken dient te worden.';

COMMENT ON COLUMN public.tbrechten.dlakritlijstprs
IS 'Niveau A. Kritieke termijnlijst default. Type Streefdatums processtappen aangevinkt.';

COMMENT ON COLUMN public.tbrechten.dlakritlijstavp
IS 'Niveau A. Kritieke termijnlijst default. Type rappelddatums aanvalsplannen aangevinkt.';

COMMENT ON COLUMN public.tbrechten.dlcbwvbrwvsb
IS 'Niveau C bouw/sloopvergunningen Brandweer (Preparaties en installaties zichtbaar (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvbrwedt
IS 'Niveau C bouw/sloopvergunningen Brandweer (Preparaties en installaties) wijzigen (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvbrwins
IS 'Niveau C bouw/sloopvergunningen Brandweer (Preparaties en installaties) nieuw (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvbrwdel
IS 'Niveau C bouw/sloopvergunningen Brandweer (Preparaties en installaties) verwijderen (T of F).';

COMMENT ON COLUMN public.tbrechten.dldpclbag
IS 'Niveau D Perceeladressen BAG (basisreg Adressen/gebouwen Ophaalrechten (T of F).';

COMMENT ON COLUMN public.tbrechten.dldcadbra
IS 'Niveau D Contactadressen BRA (basisreg. Adressen) Ophaalrechten (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvcordms
IS 'Niveau C. Bouw/sloop. Correspondentie. DMS-kolom muteerbaar';

COMMENT ON COLUMN public.tbrechten.dlcbwvcorodt
IS 'Niveau C. Bouw/sloop. Correspondentie. Opgeslagen document-kolom muteerbaar.';

COMMENT ON COLUMN public.tbrechten.dldcasam
IS 'Niveau D Contactadressen Samenvoegrecht (T of F).';

COMMENT ON COLUMN public.tbrechten.dlcbwvinsdms
IS 'Niveau C. bouwvergunningen. Inspecties. Dmscode muteren (T of F). ';

COMMENT ON COLUMN public.tbrechten.dlcbwvadvdms
IS 'Niveau C. bouwvergunningen. Adviezen. Dmscode muteren (T of F). ';

COMMENT ON COLUMN public.tbrechten.dlbbwvhlink
IS 'Niveau B. bouwvergunningen. Mag hyperlink starten vanuit powerportal bouwsloopdetail.';

COMMENT ON COLUMN public.tbrechten.dlaispubliekgroep
IS 'Niveau A. De rechtengroep is bedoeld voor publieksfuncties (privacygevoelige gegevens niet zichtbaar).';

COMMENT ON COLUMN public.tbrechten.dlamilvergvsb
IS 'Niveau A milieu.gebruiksvergunningen. Zichtbaar (T of F).';