Datadictionary OpenWave 3.1.25

Table: tbmilrechten

Schema

public

Owner

waveuser005

Tablespace

(default)

Descriptions

Rechtentabel voor de module inrichtingen (rechten op de inrichtingen zelf)

Fields

Foreign Keys

Check Constraints

Indices

Triggers

There are no triggers for table tbmilrechten

Rules

There are no rules for table tbmilrechten

Policies

There are no policies for table tbmilrechten

Referenced

There are no tables referenced by table tbmilrechten

Properties

Definition

CREATE TABLE public.tbmilrechten (
 dnkey SERIAL,
 dnkeyrechten INTEGER,
 dlbmilinredt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrins CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrblokkedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrverplaats CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrgroepedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrmemovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrkopie CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrmemoedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrinsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrinsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrinsins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrinsdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcorvsb CHAR(1) DEFAULT 'T'::bpchar,
 dlcmilinrcoredt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcorins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcordel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcadvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcadins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcaddel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlogvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlogedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlogins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlogdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcinvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcinins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcindel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrivbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrivbedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrivbins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrivbdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrsbivsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrsbiedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrsbiins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrsbidel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrtrwvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrtrwins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrtrwedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrtrwdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrstlvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrstlins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrstledt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrstldel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinropsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinropsins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinropsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinropsdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrwatvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrwatins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrwatedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrwatdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlctvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlctins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlctedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlctdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrdivvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrdivins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrdivedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrdivdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrklavsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrklains CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrklaedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrkladel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrctfvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrctfins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrctfedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrctfdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrverzledt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinromsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinromsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinromsins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinromsdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinravpvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinravpedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinravpins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinravpdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrsamen CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcordms CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcorodt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrontvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrontedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrontins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrontdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrenevsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinreneedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinreneins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrenedel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrkladms CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrinsdms CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrhlink CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrdms CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrasbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrasbins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrasbedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrasbdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrbepdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrbepins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrbepedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrbepvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrsltdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrsltins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrsltedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrsltvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlokdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlokins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlokedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlokvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinruurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinruurins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinruurdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinruuredt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrinsuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrafsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcorregvsb CHAR(1) DEFAULT 'T'::bpchar,
 dlcmilinrcorregdwl CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcordocdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrprojvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrprojedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrprojins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrprojdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcorwmo CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrzkpvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrzkpins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrzkpedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrzkpdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcorreghnm CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrinsovbzdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcorregtent CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrzkphoofdedt CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tbmilrechten PRIMARY KEY(dnkey),
 CONSTRAINT chk_milrcht_dlcmilinrcorregdwl CHECK (dlcmilinrcorregdwl = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrcht_dlcmilinrcorregvsb CHECK (dlcmilinrcorregvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinravpdel CHECK (dlcmilinravpdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinravpedt CHECK (dlcmilinravpedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinravpins CHECK (dlcmilinravpins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinravpvsb CHECK (dlcmilinravpvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrcordms CHECK (dlcmilinrcordms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrcorodt CHECK (dlcmilinrcorodt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrcorregtent CHECK (dlcmilinrcorregtent = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrcorwmo CHECK (dlcmilinrcorwmo = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrenedel CHECK (dlcmilinrenedel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinreneedt CHECK (dlcmilinreneedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinreneins CHECK (dlcmilinreneins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrenevsb CHECK (dlcmilinrenevsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinromsdel CHECK (dlcmilinromsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinromsedt CHECK (dlcmilinromsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinromsins CHECK (dlcmilinromsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinromsvsb CHECK (dlcmilinromsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrontdel CHECK (dlcmilinrontdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrontedt CHECK (dlcmilinrontedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrontins CHECK (dlcmilinrontins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrontvsb CHECK (dlcmilinrontvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrprojdel CHECK (dlcmilinrprojdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrprojedt CHECK (dlcmilinrprojedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrprojins CHECK (dlcmilinrprojins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrprojvsb CHECK (dlcmilinrprojvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrblok CHECK (dlbmilinrblokkedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrdel CHECK (dlbmilinrdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinredt CHECK (dlbmilinredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrgrpedt CHECK (dlbmilinrgroepedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrins CHECK (dlbmilinrins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrkopie CHECK (dlbmilinrkopie = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrmmedt CHECK (dlbmilinrmemoedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrmmvsb CHECK (dlbmilinrmemovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrsamen CHECK (dlbmilinrsamen = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrverp CHECK (dlbmilinrverplaats = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrbepdel CHECK (dlcmilinrbepdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrbepedt CHECK (dlcmilinrbepedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrbepins CHECK (dlcmilinrbepins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrbepvsb CHECK (dlcmilinrbepvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcaddel CHECK (dlcmilinrcaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcadins CHECK (dlcmilinrcadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcadvsb CHECK (dlcmilinrcadvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcindel CHECK (dlcmilinrcindel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcinedt CHECK (dlcmilinrcinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcinins CHECK (dlcmilinrcinins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcinvsb CHECK (dlcmilinrcinvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcordel CHECK (dlcmilinrcordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcoredt CHECK (dlcmilinrcoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcorins CHECK (dlcmilinrcorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcorvsb CHECK (dlcmilinrcorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrctfdel CHECK (dlcmilinrctfdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrctfedt CHECK (dlcmilinrctfedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrctfins CHECK (dlcmilinrctfins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrctfvsb CHECK (dlcmilinrctfvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrdivdel CHECK (dlcmilinrdivdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrdivedt CHECK (dlcmilinrdivedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrdivins CHECK (dlcmilinrdivins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrdivvsb CHECK (dlcmilinrdivvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrinsdel CHECK (dlcmilinrinsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrinsedt CHECK (dlcmilinrinsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrinsins CHECK (dlcmilinrinsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrinsovbzdel CHECK (dlcmilinrinsovbzdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrinsvsb CHECK (dlcmilinrinsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrivbdel CHECK (dlcmilinrivbdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrivbedt CHECK (dlcmilinrivbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrivbins CHECK (dlcmilinrivbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrivbvsb CHECK (dlcmilinrivbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrkladel CHECK (dlcmilinrkladel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrklaedt CHECK (dlcmilinrklaedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrklains CHECK (dlcmilinrklains = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrklavsb CHECK (dlcmilinrklavsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlctdel CHECK (dlcmilinrlctdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlctedt CHECK (dlcmilinrlctedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlctins CHECK (dlcmilinrlctins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlctvsb CHECK (dlcmilinrlctvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlogdel CHECK (dlcmilinrlogdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlogedt CHECK (dlcmilinrlogedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlogins CHECK (dlcmilinrlogins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlogvsb CHECK (dlcmilinrlogvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlokdel CHECK (dlcmilinrlokdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlokedt CHECK (dlcmilinrlokedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlokins CHECK (dlcmilinrlokins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlokvsb CHECK (dlcmilinrlokvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinropsdel CHECK (dlcmilinropsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinropsedt CHECK (dlcmilinropsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinropsins CHECK (dlcmilinropsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinropsvsb CHECK (dlcmilinropsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrsbidel CHECK (dlcmilinrsbidel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrsbiedt CHECK (dlcmilinrsbiedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrsbiins CHECK (dlcmilinrsbiins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrsbivsb CHECK (dlcmilinrsbivsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrsltdel CHECK (dlcmilinrsltdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrsltedt CHECK (dlcmilinrsltedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrsltins CHECK (dlcmilinrsltins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrsltvsb CHECK (dlcmilinrsltvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrstldel CHECK (dlcmilinrstldel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrstledt CHECK (dlcmilinrstledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrstlins CHECK (dlcmilinrstlins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrstlvsb CHECK (dlcmilinrstlvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrtrwdel CHECK (dlcmilinrtrwdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrtrwedt CHECK (dlcmilinrtrwedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrtrwins CHECK (dlcmilinrtrwins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrtrwvsb CHECK (dlcmilinrtrwvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrwatdel CHECK (dlcmilinrwatdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrwatedt CHECK (dlcmilinrwatedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrwatins CHECK (dlcmilinrwatins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrwatvsb CHECK (dlcmilinrwatvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrzkpdel CHECK (dlcmilinrzkpdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrzkpedt CHECK (dlcmilinrzkpedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrzkpins CHECK (dlcmilinrzkpins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrzkpvsb CHECK (dlcmilinrzkpvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmlicreghnm CHECK (dlcmilinrcorreghnm = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milrechten_dlverzendl CHECK (dlbmilinrverzledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_keyrechten CHECK (dnkeyrechten IS NOT NULL),
 CONSTRAINT chk_milrect_dlcmilinrcordocdel CHECK (dlcmilinrcordocdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_mirechten_dlcmilinruurdel CHECK (dlcmilinruurdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_mirechten_dlcmilinruuredt CHECK (dlcmilinruuredt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_mirechten_dlcmilinruurins CHECK (dlcmilinruurins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_mirechten_dlcmilinruurvsb CHECK (dlcmilinruurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_mirechten_dlcmlirinsuurvsb CHECK (dlcmilinrinsuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbmilr_dlcmilinrinsdms CHECK (dlcmilinrinsdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbmilr_dlcmilinrkladms CHECK (dlcmilinrkladms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbmilrecht_dlcmilinrasbdel CHECK (dlcmilinrasbdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbmilrecht_dlcmilinrasbedt CHECK (dlcmilinrasbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbmilrecht_dlcmilinrasbins CHECK (dlcmilinrasbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbmilrecht_dlcmilinrasbvsb CHECK (dlcmilinrasbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbmilrechten_dlbmilhlink CHECK (dlbmilinrhlink = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbmilrechten_dlbmilinrafse CHECK (dlbmilinrafsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbmilrechten_dlbmilinrdms CHECK (dlbmilinrdms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbmilrechten_dlcmilinrzkphoofdedt CHECK (dlcmilinrzkphoofdedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT cnn_milrcht_dlcmilinrcorregdwl CHECK (dlcmilinrcorregdwl IS NOT NULL),
 CONSTRAINT cnn_milrcht_dlcmilinrcorregvsb CHECK (dlcmilinrcorregvsb IS NOT NULL),
 CONSTRAINT cnn_milrecht_dlcmilinrcordms CHECK (dlcmilinrcordms IS NOT NULL),
 CONSTRAINT cnn_milrecht_dlcmilinrcorodt CHECK (dlcmilinrcorodt IS NOT NULL),
 CONSTRAINT cnn_milrecht_dlcmilinrcorregtent CHECK (dlcmilinrcorregtent IS NOT NULL),
 CONSTRAINT cnn_milrecht_dlcmilinrcorwmo CHECK (dlcmilinrcorwmo IS NOT NULL),
 CONSTRAINT cnn_milrecht_dlcmilinrprojdel CHECK (dlcmilinrprojdel IS NOT NULL),
 CONSTRAINT cnn_milrecht_dlcmilinrprojedt CHECK (dlcmilinrprojedt IS NOT NULL),
 CONSTRAINT cnn_milrecht_dlcmilinrprojins CHECK (dlcmilinrprojins IS NOT NULL),
 CONSTRAINT cnn_milrecht_dlcmilinrprojvsb CHECK (dlcmilinrprojvsb IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmilinrbepdel CHECK (dlcmilinrbepdel IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmilinrbepedt CHECK (dlcmilinrbepedt IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmilinrbepins CHECK (dlcmilinrbepins IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmilinrbepvsb CHECK (dlcmilinrbepvsb IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmilinrlokdel CHECK (dlcmilinrlokdel IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmilinrlokedt CHECK (dlcmilinrlokedt IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmilinrlokins CHECK (dlcmilinrlokins IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmilinrlokvsb CHECK (dlcmilinrlokvsb IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmilinrsltdel CHECK (dlcmilinrsltdel IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmilinrsltedt CHECK (dlcmilinrsltedt IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmilinrsltins CHECK (dlcmilinrsltins IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmilinrsltvsb CHECK (dlcmilinrsltvsb IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmilinrzkpdel CHECK (dlcmilinrzkpdel IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmilinrzkpedt CHECK (dlcmilinrzkpedt IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmilinrzkpins CHECK (dlcmilinrzkpins IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmilinrzkpvsb CHECK (dlcmilinrzkpvsb IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlcmlicreghnm CHECK (dlcmilinrcorreghnm IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlverzendl CHECK (dlbmilinrverzledt IS NOT NULL),
 CONSTRAINT cnn_milrect_dlcmilinrcordocdel CHECK (dlcmilinrcordocdel IS NOT NULL),
 CONSTRAINT cnn_mirechten_dlcmilinruurdel CHECK (dlcmilinruurdel IS NOT NULL),
 CONSTRAINT cnn_mirechten_dlcmilinruuredt CHECK (dlcmilinruuredt IS NOT NULL),
 CONSTRAINT cnn_mirechten_dlcmilinruurins CHECK (dlcmilinruurins IS NOT NULL),
 CONSTRAINT cnn_mirechten_dlcmilinruurvsb CHECK (dlcmilinruurvsb IS NOT NULL),
 CONSTRAINT cnn_mirechten_dlcmlirinsuurvsb CHECK (dlcmilinrinsuurvsb IS NOT NULL),
 CONSTRAINT cnn_tbmilrecht_dlcmilinrasbdel CHECK (dlcmilinrasbdel IS NOT NULL),
 CONSTRAINT cnn_tbmilrecht_dlcmilinrasbedt CHECK (dlcmilinrasbedt IS NOT NULL),
 CONSTRAINT cnn_tbmilrecht_dlcmilinrasbins CHECK (dlcmilinrasbins IS NOT NULL),
 CONSTRAINT cnn_tbmilrecht_dlcmilinrasbvsb CHECK (dlcmilinrasbvsb IS NOT NULL),
 CONSTRAINT cnn_tbmilrechten_dlbmilhlink CHECK (dlbmilinrhlink IS NOT NULL),
 CONSTRAINT cnn_tbmilrechten_dlbmilinrafse CHECK (dlbmilinrafsedt IS NOT NULL),
 CONSTRAINT cnn_tbmilrechten_dlbmilinrdms CHECK (dlbmilinrdms IS NOT NULL),
 CONSTRAINT cnn_tbmilrechten_dlcmilinrinsovbzdel CHECK (dlcmilinrinsovbzdel IS NOT NULL),
 CONSTRAINT cnn_tbmilrechten_dlcmilinrzkphoofdedt CHECK (dlcmilinrzkphoofdedt IS NOT NULL),
 CONSTRAINT cfk_tbmilrechten_keyrechten FOREIGN KEY (dnkeyrechten)
   REFERENCES public.tbrechten(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) ;

COMMENT ON TABLE public.tbmilrechten
IS 'Rechtentabel voor de module inrichtingen (rechten op de inrichtingen zelf)';

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

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

COMMENT ON COLUMN public.tbmilrechten.dlbmilinredt
IS 'Niveau B Milieu inrichting Wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlbmilinrins
IS 'Niveau B Milieu inrichting Nieuwrecht (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlbmilinrdel
IS 'Niveau B Milieu inrichting Verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlbmilinrblokkedt
IS 'Niveau B Milieu inrichting Blokkeerrecht (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlbmilinrverplaats
IS 'Niveau B Milieu inrichting Verplaatsrecht.';

COMMENT ON COLUMN public.tbmilrechten.dlbmilinrgroepedt
IS 'Niveau B Milieu inrichting (T of F) Groepvergunnigen maken.';

COMMENT ON COLUMN public.tbmilrechten.dlbmilinrmemovsb
IS 'Niveau B Milieu inrichting Memo zichtbaar (T  of F).';

COMMENT ON COLUMN public.tbmilrechten.dlbmilinrkopie
IS 'Niveau B Milieu inrichting. Kopieerrecht.';

COMMENT ON COLUMN public.tbmilrechten.dlbmilinrmemoedt
IS 'Niveau B. Milieu inrichting. Memo wijzigen.';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrinsvsb
IS 'Niveau C Milieu inrichting Inspecties zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrinsedt
IS 'Niveau C Milieu inrichting Inspecties wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrinsins
IS 'Niveau C Milieu inrichting Inspecties nieuw (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrinsdel
IS 'Niveau C Milieu inrichting Inspecties verwijderrecht (trajecten, overtredingen en bezoeken) (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcorvsb
IS 'Niveau C Milieu inrichting alle correspondentie zichtbaar (T of F). default T';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcoredt
IS 'Niveau C Milieu inrichting Registreren van doucmenten en geregistreerde correspondentie wijzigen metadata(T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcorins
IS 'Niveau C Milieu inrichting correspondentie correspondentie creeren en uploaden document (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcordel
IS 'Niveau C Milieu inrichting correspondentie geregisteerde correspondentie verwijderen metadata (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcadvsb
IS 'Niveau C Milieu inrichting contactadressen  zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcadins
IS 'Niveau C Milieu inrichting contactadressen koppeling maken (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcaddel
IS 'Niveau C Milieu inrichting contactadressen koppeling verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrlogvsb
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrlogedt
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrlogins
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrlogdel
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcinvsb
IS 'Niveau C Milieu inrichting Correspondentie Binnen Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcinedt
IS 'Niveau C Milieu inrichting Correspondentie Binnen Wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcinins
IS 'Niveau C Milieu inrichting Correspondentie Binnen Nieuw (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcindel
IS 'Niveau C Milieu inrichting Correspondentie Binnen Verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrivbvsb
IS 'Niveau C Milieu inrichting ROB (voorheen IVB) zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrivbedt
IS 'Niveau C Milieu inrichting ROB (voorheen IVB) wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrivbins
IS 'Niveau C Milieu inrichting ROB (vootheen IVB) nieuw (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrivbdel
IS 'Niveau C Milieu inrichting ROB (voorheen IVB) verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrsbivsb
IS 'Niveau C Milieu inrichting SBI zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrsbiedt
IS 'Niveau C Milieu inrichting SBI wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrsbiins
IS 'Niveau C Milieu inrichting SBI nieuw (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrsbidel
IS 'Niveau C Milieu inrichting SBI verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrtrwvsb
IS 'Niveau C Milieu inrichting trefword zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrtrwins
IS 'Niveau C Milieu inrichting trefwoord nieuw (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrtrwedt
IS 'Niveau C Milieu inrichting trefwoord wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrtrwdel
IS 'Niveau C Milieu inrichting trefwoord verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrstlvsb
IS 'Niveau C Milieu inrichting Stallen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrstlins
IS 'Niveau C Milieu inrichting Stallen nieuw (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrstledt
IS 'Niveau C Milieu inrichting Stallen wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrstldel
IS 'Niveau C Milieu inrichting Stallen verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinropsvsb
IS 'Niveau C Milieu inrichting Opslag zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinropsins
IS 'Niveau C Milieu inrichting Opslag nieuw (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinropsedt
IS 'Niveau C Milieu inrichting Opslag wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinropsdel
IS 'Niveau C Milieu inrichting Opslag verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrwatvsb
IS 'Niveau C Milieu inrichting Water zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrwatins
IS 'Niveau C Milieu inrichting Water nieuw (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrwatedt
IS 'Niveau C Milieu inrichting Water wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrwatdel
IS 'Niveau C Milieu inrichting Water verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrlctvsb
IS 'Niveau C Milieu inrichting Lucht zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrlctins
IS 'Niveau C Milieu inrichting Lucht nieuw (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrlctedt
IS 'Niveau C Milieu inrichting Lucht wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrlctdel
IS 'Niveau C Milieu inrichting Lucht verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrdivvsb
IS 'Niveau C Milieu inrichting Diversen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrdivins
IS 'Niveau C Milieu inrichting Diversen nieuw (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrdivedt
IS 'Niveau C Milieu inrichting Diversen wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrdivdel
IS 'Niveau C Milieu inrichting Diversen verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrklavsb
IS 'Niveau C Milieu inrichting Klachten zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrklains
IS 'Niveau C Milieu inrichting Klachten nieuw (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrklaedt
IS 'Niveau C Milieu inrichting Klachten wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrkladel
IS 'Niveau C Milieu inrichting Klachten verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrctfvsb
IS 'Niveau C Milieu inrichting Certificaten zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrctfins
IS 'Niveau C Milieu inrichting Certificaten nieuw (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrctfedt
IS 'Niveau C Milieu inrichting Certificaten wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrctfdel
IS 'Niveau C Milieu inrichting Certificaten verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlbmilinrverzledt
IS 'Niveau B milinr Verzendlijst maken (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinromsvsb
IS 'Niveau C Milieu inrichting OMS zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinromsedt
IS 'Niveau C Milieu inrichting OMS wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinromsins
IS 'Niveau C Milieu inrichting OMS nieuw (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinromsdel
IS 'Niveau C Milieu inrichting OMS verwijder (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinravpvsb
IS 'Niveau C Milieu inrichting Aanvalsplannen en Lokatiecriteria zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinravpedt
IS 'Niveau C Milieu Aanvalsplannen en Lokatiecriteria wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinravpins
IS 'Niveau C Milieu inrichting Aanvalsplannen en Lokatiecriteria nieuw (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinravpdel
IS 'Niveau C Milieu inrichting Aanvalsplannen en Lokatiecriteria verwijder (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlbmilinrsamen
IS 'Niveau B Milieu inrichting Samenvoegen inrichtingen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcordms
IS 'Niveau C. Milieuinrichting. Correspondentie. DMS-kolom muteerbaar';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcorodt
IS 'Niveau C. Milieuinrichting. Correspondentie. Opgeslagen document-kolom muteerbaar.';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrontvsb
IS 'Niveau C. Milieuinrichting Ontheffingen Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrontedt
IS 'Niveau C. Milieuinrichting Ontheffingen  wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrontins
IS 'Niveau C. Milieuinrichting Ontheffingen insertrecht (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrontdel
IS 'Niveau C. Milieuinrichting Ontheffingen verwijderrecht (T of F). ';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrenevsb
IS 'Niveau C. Milieuinrichting Energie Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinreneedt
IS 'Niveau C. Milieuinrichting Energie  wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinreneins
IS 'Niveau C. Milieuinrichting Energie insertrecht (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrenedel
IS 'Niveau C. Milieuinrichting Energie verwijderrecht (T of F). ';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrkladms
IS 'Niveau C. Milieuinrichting Klachten. Dmscode muteren (T of F). ';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrinsdms
IS 'Niveau C. Milieuinrichting Inspecties. Dmscode muteren (T of F). ';

COMMENT ON COLUMN public.tbmilrechten.dlbmilinrhlink
IS 'Niveau B. Milieuinrichting. Mag hyperlink starten vanuit powerportal inrichtingdetail.';

COMMENT ON COLUMN public.tbmilrechten.dlbmilinrdms
IS 'Niveau B. Milieuinrichting. Mag Zaakcode/DMS wijzigen.';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrbepdel
IS 'Niveau C. Milieuinrichting Beperkingen verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrbepins
IS 'Niveau C. Milieuinrichting Beperkingen insertrecht (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrbepedt
IS 'Niveau C. Milieuinrichting Beperkingen wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrbepvsb
IS 'Niveau C. Milieuinrichting Beperkingen Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrsltdel
IS 'Niveau C. Milieuinrichting. Sluitingstijden verwijderrecht.';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrsltins
IS 'Niveau C. Milieuinrichting. Sluitingstijden Insertrecht.';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrsltvsb
IS 'Niveau C. Milieuinrichting. Sluitingstijden muteerbaar.';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrlokdel
IS 'Niveau C. Milieuinrichting Lokalieiten  verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrlokins
IS 'Niveau C. Milieuinrichting Lokaliteiten insertrecht (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrlokedt
IS 'Niveau C. Milieuinrichting Lokaliteiten wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrlokvsb
IS 'niveau c. Milieuinrichting Lokaliteiten zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinruurvsb
IS 'Niveau C. Milieuinrichting... uren inzien (T of F)';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinruurins
IS 'Niveau C. Milieuinrichting... uren insert (T of F)';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinruurdel
IS 'Niveau C. Milieuinrichting... uren delete (T of F)';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinruuredt
IS 'Niveau C. Milieuinrichting... uren wijzgen (T of F)';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrinsuurvsb
IS 'Niveau C. inspecties bij Milieuinrichting... uren inzien (T of F), edit- insert- delrechten via dlcmilinruuredt, dlcmilinruurins,dlcmilinruurdel';

COMMENT ON COLUMN public.tbmilrechten.dlbmilinrafsedt
IS 'Niveau B Inrichtimg gevulde afhandeldatum wijzgen en dit geldt ook voor gevulde externe zaak einddatum (dddmsafgehandeld) bij deelzaak inspecties die aan inrichting zijn gekoppeld(T of F)';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcorregvsb
IS 'Niveau C Inrichting Geregistreerde documenten zichtbaar (T of F) Default T';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcorregdwl
IS 'Niveau C Inrichting Geregistreerde documenten Mag geforceerd downloaden (T of F) Default F';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcordocdel
IS 'Niveau C Inrichting geregisteerde correspondentie verwijderen fysiek document(T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrprojvsb
IS 'Niveau C. Milieuinrichting... projecten inzien (T of F)';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrprojedt
IS 'Niveau C. Milieuinrichting... projecten wijzigen (T of F)';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrprojins
IS 'Niveau C. Milieuinrichting... projecten aanmaken (T of F)';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrprojdel
IS 'Niveau C. Milieuinrichting... projecten verwijderen (T of F)';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcorwmo
IS 'Niveau C Milieuinrichting Wijzigen metadata (hernoemen filenaam) ongeregistreerde documenten (T of F)';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrzkpvsb
IS 'Niveau C. Milieuinrichting Kadastrale percelen zichtbaar (T of F)';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrzkpins
IS 'Niveau C. Milieuinrichting Kadastrale percelen insert (T of F)';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrzkpedt
IS 'Niveau C. Milieuinrichting Kadastrale percelen wijzigen (T of F)';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrzkpdel
IS 'Niveau C Milieuinrichting Kadastrale percelen delete (T of F)';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcorreghnm
IS 'Niveau C Milieuinrichting Hernoemen geregistreerde documenten';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrinsovbzdel
IS 'Niveau C Milieu inrichting. Alleen inspectiebezoeken en overtredingen verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrcorregtent
IS 'Niveau C. Milieu inrichting... wijzigrecht (externe) tbcorrespondentie.dvexttracktrace';

COMMENT ON COLUMN public.tbmilrechten.dlcmilinrzkphoofdedt
IS 'Niveau C. Milieu inrichting. Mag hoofdprojectlocatie-indicatie wijzigen (T of F).';

CREATE UNIQUE INDEX idu_milrechten_keyrechten ON public.tbmilrechten
 USING btree (dnkeyrechten);