Datadictionary OpenWave 3.1.25

Table: tbhorrechten

Schema

public

Owner

waveuser005

Tablespace

(default)

Descriptions

Rechtentabel voor de module horeca

Fields

Foreign Keys

Check Constraints

Indices

Triggers

There are no triggers for table tbhorrechten

Rules

There are no rules for table tbhorrechten

Policies

There are no policies for table tbhorrechten

Referenced

There are no tables referenced by table tbhorrechten

Properties

Definition

CREATE TABLE public.tbhorrechten (
 dnkey SERIAL,
 dnkeyrechten INTEGER,
 dlbhoredt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorins CHAR(1) DEFAULT 'F'::bpchar,
 dlbhordel CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorblokkedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorverzledt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorgroepedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhormemovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorkopie CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorverplaats CHAR(1) DEFAULT 'F'::bpchar,
 dlchoribbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchoribbedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchoribbins CHAR(1) DEFAULT 'F'::bpchar,
 dlchoribbdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorprovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorproedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorproins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorprodel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorproahn CHAR(1) DEFAULT 'F'::bpchar,
 dlchorprovdg CHAR(1) DEFAULT 'F'::bpchar,
 dlchoradvvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchoradvedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchoradvins CHAR(1) DEFAULT 'F'::bpchar,
 dlchoradvdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorinsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorinsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorinsins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorinsdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcorvsb CHAR(1) DEFAULT 'T'::bpchar,
 dlchorcoredt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcorins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcordel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcadvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcadins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcaddel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlegvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlegedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlegins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlegdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlogvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlogedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlogins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlogdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcinvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcinins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcindel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorexplvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorexpledt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorexplins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorexpldel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorklavsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorklaedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorklains CHAR(1) DEFAULT 'F'::bpchar,
 dlchorkladel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorohfvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorohfedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorohfins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorohfdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchortervsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorteredt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorterins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorterdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorsptvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorsptedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorsptins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorsptdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorsltvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorsltedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorsltins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorsltdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcompr CHAR(1) DEFAULT 'F'::bpchar,
 dlchoradvinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlegexpnot CHAR(1) DEFAULT 'F'::bpchar,
 dlbhormemoedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorabedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchoradvdatedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorbepedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorbepvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorbepins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorbepdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlokedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlokvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlokins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlokdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorontedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorontvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorontins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorontdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbhoradedt CHAR(1) DEFAULT 'T'::bpchar,
 dlchorcordms CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcorodt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorsnelins CHAR(1) DEFAULT 'T'::bpchar,
 dlchoradvdms CHAR(1) DEFAULT 'F'::bpchar,
 dlchorinsdms CHAR(1) DEFAULT 'F'::bpchar,
 dlchorkladms CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorhlink CHAR(1) DEFAULT 'F'::bpchar,
 dlchorbezwvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorbezwedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorbezwins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorbezwdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorbezwdms CHAR(1) DEFAULT 'F'::bpchar,
 dlchoruurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchoruurins CHAR(1) DEFAULT 'F'::bpchar,
 dlchoruurdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchoruuredt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorinsuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorbezwuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchoradvuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorafsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcorregvsb CHAR(1) DEFAULT 'T'::bpchar,
 dlchorcorregdwl CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcordocdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcorwmo CHAR(1) DEFAULT 'F'::bpchar,
 dlchorprdedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorinsovbzdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcorreghnm CHAR(1) DEFAULT 'F'::bpchar,
 dlchorprdins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorprddel CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorwznedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorztedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcorregtent CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tbhorrechten PRIMARY KEY(dnkey),
 CONSTRAINT chk_horrecht_dlchorcorregdwl CHECK (dlchorcorregdwl = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrecht_dlchorcorregtent CHECK (dlchorcorregtent = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrecht_dlchorcorregvsb CHECK (dlchorcorregvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorabedt CHECK (dlbhorabedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhoradedt CHECK (dlbhoradedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorafsedt CHECK (dlbhorafsedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorblokkedt CHECK (dlbhorblokkedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhordel CHECK (dlbhordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhoredt CHECK (dlbhoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorgroepedt CHECK (dlbhorgroepedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorins CHECK (dlbhorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorkopie CHECK (dlbhorkopie = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhormemoedt CHECK (dlbhormemoedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhormemovsb CHECK (dlbhormemovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorsnelins CHECK (dlbhorsnelins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorverplaats CHECK (dlbhorverplaats = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorverzledt CHECK (dlbhorverzledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorwznedt CHECK (dlbhorwznedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorztedt CHECK (dlbhorztedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoradvdel CHECK (dlchoradvdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoradvedt CHECK (dlchoradvedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoradvinedt CHECK (dlchoradvinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoradvins CHECK (dlchoradvins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoradvvsb CHECK (dlchoradvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorbezwdel CHECK (dlchorbezwdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorbezwdms CHECK (dlchorbezwdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorbezwedt CHECK (dlchorbezwedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorbezwins CHECK (dlchorbezwins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorbezwvsb CHECK (dlchorbezwvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcaddel CHECK (dlchorcaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcadins CHECK (dlchorcadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcadvsb CHECK (dlchorcadvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcindel CHECK (dlchorcindel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcinedt CHECK (dlchorcinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcinins CHECK (dlchorcinins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcinvsb CHECK (dlchorcinvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcompr CHECK (dlchorcompr = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcordel CHECK (dlchorcordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcordms CHECK (dlchorcordms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcordocdel CHECK (dlchorcordocdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcoredt CHECK (dlchorcoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcorins CHECK (dlchorcorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcorodt CHECK (dlchorcorodt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcorreghnm CHECK (dlchorcorreghnm = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcorvsb CHECK (dlchorcorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcorwmo CHECK (dlchorcorwmo = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorexpldel CHECK (dlchorexpldel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorexpledt CHECK (dlchorexpledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorexplins CHECK (dlchorexplins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorexplvsb CHECK (dlchorexplvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoribbdel CHECK (dlchoribbdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoribbedt CHECK (dlchoribbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoribbins CHECK (dlchoribbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoribbvsb CHECK (dlchoribbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorinsdel CHECK (dlchorinsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorinsedt CHECK (dlchorinsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorinsins CHECK (dlchorinsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorinsovbzdel CHECK (dlchorinsovbzdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorinsvsb CHECK (dlchorinsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorkladel CHECK (dlchorkladel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorklaedt CHECK (dlchorklaedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorklains CHECK (dlchorklains = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorklavsb CHECK (dlchorklavsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlegdel CHECK (dlchorlegdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlegedt CHECK (dlchorlegedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlegexpnot CHECK (dlchorlegexpnot = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlegins CHECK (dlchorlegins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlegvsb CHECK (dlchorlegvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlogdel CHECK (dlchorlogdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlogedt CHECK (dlchorlogedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlogins CHECK (dlchorlogins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlogvsb CHECK (dlchorlogvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorohfdel CHECK (dlchorohfdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorohfedt CHECK (dlchorohfedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorohfins CHECK (dlchorohfins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorohfvsb CHECK (dlchorohfvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorprddel CHECK (dlchorprddel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorprdedt CHECK (dlchorprdedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorprdins CHECK (dlchorprdins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorproahn CHECK (dlchorproahn = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorprodel CHECK (dlchorprodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorproedt CHECK (dlchorproedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorproins CHECK (dlchorproins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorprovdg CHECK (dlchorprovdg = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorprovsb CHECK (dlchorprovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorsltdel CHECK (dlchorsltdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorsltedt CHECK (dlchorsltedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorsltins CHECK (dlchorsltins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorsltvsb CHECK (dlchorsltvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorsptdel CHECK (dlchorsptdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorsptedt CHECK (dlchorsptedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorsptins CHECK (dlchorsptins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorsptvsb CHECK (dlchorsptvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorterdel CHECK (dlchorterdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorteredt CHECK (dlchorteredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorterins CHECK (dlchorterins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchortervsb CHECK (dlchortervsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horadvdatedt CHECK (dlchoradvdatedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horbepdel CHECK (dlchorbepdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horbepedt CHECK (dlchorbepedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horbepins CHECK (dlchorbepins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horbepvsb CHECK (dlchorbepvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horlokdel CHECK (dlchorlokdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horlokedt CHECK (dlchorlokedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horlokins CHECK (dlchorlokins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horlokvsb CHECK (dlchorlokvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horontdel CHECK (dlchorontdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horontedt CHECK (dlchorontedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horontins CHECK (dlchorontins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horontvsb CHECK (dlchorontvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hrrechten_dlchoradvuurvsb CHECK (dlchoradvuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hrrechten_dlchorbezwuurvsb CHECK (dlchorbezwuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hrrechten_dlchorinsuurvsb CHECK (dlchorinsuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hrrechten_dlchoruurdel CHECK (dlchoruurdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hrrechten_dlchoruuredt CHECK (dlchoruuredt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hrrechten_dlchoruurins CHECK (dlchoruurins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hrrechten_dlchoruurvsb CHECK (dlchoruurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbhorrechten_dlbhorhlink CHECK (dlbhorhlink = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbhorrechten_dlchoradvdms CHECK (dlchoradvdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbhorrechten_dlchorinsdms CHECK (dlchorinsdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbhorrechten_dlchorkladms CHECK (dlchorkladms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT cnn_horrecht_dlchorcorregdwl CHECK (dlchorcorregdwl IS NOT NULL),
 CONSTRAINT cnn_horrecht_dlchorcorregtent CHECK (dlchorcorregtent IS NOT NULL),
 CONSTRAINT cnn_horrecht_dlchorcorregvsb CHECK (dlchorcorregvsb IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlbhorafsedt CHECK (dlbhorafsedt IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlbhorsnelins CHECK (dlbhorsnelins IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlbhorwznedt CHECK (dlbhorwznedt IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlbhorztedt CHECK (dlbhorztedt IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlchorbezwdel CHECK (dlchorbezwdel IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlchorbezwdms CHECK (dlchorbezwdms IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlchorbezwedt CHECK (dlchorbezwedt IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlchorbezwins CHECK (dlchorbezwins IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlchorbezwvsb CHECK (dlchorbezwvsb IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlchorcordms CHECK (dlchorcordms IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlchorcordocdel CHECK (dlchorcordocdel IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlchorcorodt CHECK (dlchorcorodt IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlchorcorreghnm CHECK (dlchorcorreghnm IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlchorcorwmo CHECK (dlchorcorwmo IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlchorinsovbzdel CHECK (dlchorinsovbzdel IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlchorprddel CHECK (dlchorprddel IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlchorprdedt CHECK (dlchorprdedt IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlchorprdins CHECK (dlchorprdins IS NOT NULL),
 CONSTRAINT cnn_horrechten_dnkeyrechten CHECK (dnkeyrechten IS NOT NULL),
 CONSTRAINT cnn_hrrechten_dlchoradvuurvsb CHECK (dlchoradvuurvsb IS NOT NULL),
 CONSTRAINT cnn_hrrechten_dlchorbezwuurvsb CHECK (dlchorbezwuurvsb IS NOT NULL),
 CONSTRAINT cnn_hrrechten_dlchorinsuurvsb CHECK (dlchorinsuurvsb IS NOT NULL),
 CONSTRAINT cnn_hrrechten_dlchoruurdel CHECK (dlchoruurdel IS NOT NULL),
 CONSTRAINT cnn_hrrechten_dlchoruuredt CHECK (dlchoruuredt IS NOT NULL),
 CONSTRAINT cnn_hrrechten_dlchoruurins CHECK (dlchoruurins IS NOT NULL),
 CONSTRAINT cnn_hrrechten_dlchoruurvsb CHECK (dlchoruurvsb IS NOT NULL),
 CONSTRAINT cnn_tbhorrechten_dlbhorhlink CHECK (dlbhorhlink IS NOT NULL),
 CONSTRAINT cfk_horrechten_keyrechten FOREIGN KEY (dnkeyrechten)
   REFERENCES public.tbrechten(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) ;

COMMENT ON TABLE public.tbhorrechten
IS 'Rechtentabel voor de module horeca';

COMMENT ON COLUMN public.tbhorrechten.dnkey
IS 'Primary Key.';

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

COMMENT ON COLUMN public.tbhorrechten.dlbhoredt
IS 'Niveau B. Horeca. Editscherm wijzigbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorins
IS 'Niveau B. Horeca. Editscherm InsertRecht.';

COMMENT ON COLUMN public.tbhorrechten.dlbhordel
IS 'Niveau B. Horeca. Editscherm Verwijderecht.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorblokkedt
IS 'Niveau B. Horeca. Editscherm Blokkeerecht.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorverzledt
IS 'Niveau B. Horeca. Editscherm Verzendlijstsrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorgroepedt
IS 'Niveau B. Horeca. Editscherm Groepsvergunningrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlbhormemovsb
IS 'Niveau B. Horeca. Editscherm Memo zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorkopie
IS 'Niveau B. Horeca. Editscherm Kopieerrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorverplaats
IS 'Niveau B. Horeca. Editscherm verplaatsrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchoribbvsb
IS 'Niveau C. Horeca. In behandeling Bij zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchoribbedt
IS 'Niveau C. Horeca. In behandeling Bij muteerbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchoribbins
IS 'Niveau C. Horeca. In behandeling Bij Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchoribbdel
IS 'Niet meer in gebruik.';

COMMENT ON COLUMN public.tbhorrechten.dlchorprovsb
IS 'Niveau C. Horeca. Procedures zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorproedt
IS 'Niveau C. Horeca. Procedures muteerbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorproins
IS 'Niveau C. Horeca. Procedures Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorprodel
IS 'Niveau C. Horeca. Procedures verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorproahn
IS 'Wordt niet meet gebruikt sinds open-waveversie 1.13. Niveau C. Horeca. Procedures aanhouden en termijn van orde.';

COMMENT ON COLUMN public.tbhorrechten.dlchorprovdg
IS 'Wordt niet meet gebruikt sinds open-waveversie 1.13. Niveau C. Horeca. Procedures Verdagen.';

COMMENT ON COLUMN public.tbhorrechten.dlchoradvvsb
IS 'Niveau C. Horeca. Adviezen zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchoradvedt
IS 'Niveau C. Horeca. Adviezen muteerrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchoradvins
IS 'Niveau C. Horeca. Adviezen Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchoradvdel
IS 'Niveau C. Horeca. Adviezen verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorinsvsb
IS 'Niveau C. Horeca. Inspecties zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorinsedt
IS 'Niveau C. Horeca. Inspecties muteerrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorinsins
IS 'Niveau C. Horeca. Inspecties Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorinsdel
IS 'Niveau C. Horeca. Inspecties verwijderrecht (trajecten, overtredingen en bezoeken) (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorcorvsb
IS 'Niveau C. Horeca. alle correspondentie zichtbaar (T of F). default T';

COMMENT ON COLUMN public.tbhorrechten.dlchorcoredt
IS 'Niveau C. Horeca. Registreren van doucmenten en geregistreerde correspondentie wijzigen metadata(T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorcorins
IS 'Niveau C. Horeca. correspondentie creeren en uploaden document (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorcordel
IS 'Niveau C. Horeca. geregisteerde correspondentie verwijderen metadata(T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorcadvsb
IS 'Niveau C. Horeca. Contactadressen zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcadins
IS 'Niveau C. Horeca. Contactadressen Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcaddel
IS 'Niveau C. Horeca. Contactadressen ontkoppelrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorlegvsb
IS 'Niveau C. Horeca. Leges zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorlegedt
IS 'Niveau C. Horeca. Leges muteerbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorlegins
IS 'Niveau C. Horeca. Leges Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorlegdel
IS 'Niveau C. Horeca. Leges verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorlogvsb
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbhorrechten.dlchorlogedt
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbhorrechten.dlchorlogins
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbhorrechten.dlchorlogdel
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbhorrechten.dlchorcinvsb
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca. Correspondentie binnenkomend zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcinedt
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca. Correspondentie binnenkomend muteerrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcinins
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca. Correspondentie binnenkomend Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcindel
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca. Correspondentie binnenkomend verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorexplvsb
IS 'Niveau C. Horeca. Expoitatie zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorexpledt
IS 'Niveau C. Horeca. Expoitatie muteerrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorexplins
IS 'Niveau C. Horeca. Expoitatie InsertRecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorexpldel
IS 'Niveau C. Horeca. Expoitatie Verwijdedrrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorklavsb
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca. Klachten zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorklaedt
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca. Klachten muteerecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorklains
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca. Klachten Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorkladel
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca. Klachten verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorohfvsb
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13.Niveau C. Horeca. Ontheffingen zichtbaar. Wordt niet gebruikt.';

COMMENT ON COLUMN public.tbhorrechten.dlchorohfedt
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13.Niveau C. Horeca. Ontheffingen muteerrecht. Wordt niet gebruikt.';

COMMENT ON COLUMN public.tbhorrechten.dlchorohfins
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13.Niveau C. Horeca. Ontheffingen Insertrecht. Wordt niet gebruikt.';

COMMENT ON COLUMN public.tbhorrechten.dlchorohfdel
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13.Niveau C. Horeca. Ontheffingen verwijderrecht. Wordt niet gebruikt.';

COMMENT ON COLUMN public.tbhorrechten.dlchortervsb
IS 'Niveau C. Horeca. Terras zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorteredt
IS 'Niveau C. Horeca. Terras muteerbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorterins
IS 'Niveau C. Horeca. Terras Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorterdel
IS 'Niveau C. Horeca. Terras verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorsptvsb
IS 'Niveau C. Horeca. Speelautomaten zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorsptedt
IS 'Niveau C. Horeca. Speelautomaten muteerrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorsptins
IS 'Niveau C. Horeca. Speelautomaten Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorsptdel
IS 'Niveau C. Horeca. Speelautomaten Verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorsltvsb
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca. Sluitingstijden muteerbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorsltins
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca. Sluitingstijden Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorsltdel
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca. Sluitingstijden verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcompr
IS 'Niveau C. Horeca. Procedures ComprimeerRecht. Wordt niet gebruikt.';

COMMENT ON COLUMN public.tbhorrechten.dlchoradvinedt
IS 'Niveau C Horeca. Adviezen. Mag kolom Adviesinstantie wijzigen.';

COMMENT ON COLUMN public.tbhorrechten.dlchorlegexpnot
IS 'Niveau C. Horeca. Leges Notanummer en Exportdatum muteerbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlbhormemoedt
IS 'Niveau B. Horeca. Memo wijzigen.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorabedt
IS 'Niveau B. Horeca. Aard besluit en besluitdatum wijzigbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchoradvdatedt
IS 'Niveau C. Adviezen. Wijzigrecht kolom DdDateringadvies van tabel TbAdviezen bij horeca (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorbepedt
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. HorecaBeperkingen wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorbepvsb
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. HorecaBeperkingen Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorbepins
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. HorecaBeperkingen insertrecht (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorbepdel
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. HorecaBeperkingen verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorlokedt
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13.Niveau C. Horeca Lokaliteiten wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorlokvsb
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13.niveau c. Horeca Lokaliteiten zichtbaar (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorlokins
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13.Niveau C. Horeca Lokaliteiten insertrecht (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorlokdel
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13.Niveau C. Horeca Lokalieiten  verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorontedt
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca Ontheffingen  wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorontvsb
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca Ontheffingen Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorontins
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca Ontheffingen insertrecht (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorontdel
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca Ontheffingen verwijderrecht (T of F). ';

COMMENT ON COLUMN public.tbhorrechten.dlbhoradedt
IS 'Niveau B Horeca. Mag aanvraagdatum wijzigen (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorcordms
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. C. Horeca. Correspondentie. DMS-kolom muteerbaar';

COMMENT ON COLUMN public.tbhorrechten.dlchorcorodt
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca. Correspondentie. Opgeslagen document-kolom muteerbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorsnelins
IS 'Niveau B. Horeca. Mag dvintzaakcode wijzigen.';

COMMENT ON COLUMN public.tbhorrechten.dlchoradvdms
IS 'Niveau C. Horeca. Adviezen. dvintzaakcode wijzigen.';

COMMENT ON COLUMN public.tbhorrechten.dlchorinsdms
IS 'Niveau C. Horeca. Inspecties. Mag dvintzaakcode wijzigen.';

COMMENT ON COLUMN public.tbhorrechten.dlchorkladms
IS 'Wordt niet meer gebruikt sinds open-waveversie 1.13. Niveau C. Horeca. Klachten. Mag dvdmscode wijzigen.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorhlink
IS 'Niveau B. Horeca. Mag hyperlink starten vanuit powerportal horecadetail.';

COMMENT ON COLUMN public.tbhorrechten.dlchorbezwvsb
IS 'Niveau C. Horeca. Bezwaar/beroep inzien (T of F)';

COMMENT ON COLUMN public.tbhorrechten.dlchorbezwedt
IS 'Niveau C. Horeca. Bezwaar/beroep wijzgen (T of F)';

COMMENT ON COLUMN public.tbhorrechten.dlchorbezwins
IS 'Niveau C. Horeca. Bezwaar/beroep insert (T of F)';

COMMENT ON COLUMN public.tbhorrechten.dlchorbezwdel
IS 'Niveau C. Horeca. Bezwaar/beroep delete (T of F)';

COMMENT ON COLUMN public.tbhorrechten.dlchorbezwdms
IS 'Niveau C. Horeca. Bezwaar/beroep. dmscode (extern zaakidentificatie) muteren (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchoruurvsb
IS 'Niveau C. Horeca... uren inzien (T of F)';

COMMENT ON COLUMN public.tbhorrechten.dlchoruurins
IS 'Niveau C. Horeca... uren insert (T of F)';

COMMENT ON COLUMN public.tbhorrechten.dlchoruurdel
IS 'Niveau C. Horeca... uren delete (T of F)';

COMMENT ON COLUMN public.tbhorrechten.dlchoruuredt
IS 'Niveau C. Horeca... uren wijzgen (T of F)';

COMMENT ON COLUMN public.tbhorrechten.dlchorinsuurvsb
IS 'Niveau C. inspecties bij Horeca... uren inzien (T of F), edit- insert- delrechten via dlchoruuredt, dlchoruurins,dlchoruurdel';

COMMENT ON COLUMN public.tbhorrechten.dlchorbezwuurvsb
IS 'Niveau C. bezwaar/beroep bij Horeca... uren inzien (T of F), edit- insert- delrechten via dlchoruuredt, dlchoruurins,dlchoruurdel';

COMMENT ON COLUMN public.tbhorrechten.dlchoradvuurvsb
IS 'Niveau C. adviezen bij Horeca... uren inzien (T of F), edit- insert- delrechten via dlchoruuredt, dlchoruurins,dlchoruurdel';

COMMENT ON COLUMN public.tbhorrechten.dlbhorafsedt
IS 'Niveau B Horeca gevulde afhandeldatum wijzgen en dit geldt ook voor gevulde externe zaak einddatum (dddmsafgehandeld) bij deelzaken advies, inspectiesen, bezwaarberoep die aan horeca zijn gekoppeld(T of F)';

COMMENT ON COLUMN public.tbhorrechten.dlchorcorregvsb
IS 'Niveau C horeca Geregistreerde documenten zichtbaar (T of F) Default T';

COMMENT ON COLUMN public.tbhorrechten.dlchorcorregdwl
IS 'Niveau C horeca Geregistreerde documenten Mag geforceerd downloaden (T of F) Default F';

COMMENT ON COLUMN public.tbhorrechten.dlchorcordocdel
IS 'Niveau C horeca geregisteerde correspondentie verwijderen fysiek document(T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorcorwmo
IS 'Niveau C Horeca Wijzigen metadata (hernoemen filenaam) ongeregistreerde documenten (T of F)';

COMMENT ON COLUMN public.tbhorrechten.dlchorprdedt
IS 'Niveau C Horeca. Product/Dienst wijzigen (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorinsovbzdel
IS 'Niveau C. Horeca. Alleen inspectiebezoeken en overtredingen verwijderen (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorcorreghnm
IS 'Niveau C Horeca Hernoemen geregistreerde documenten';

COMMENT ON COLUMN public.tbhorrechten.dlchorprdins
IS 'Niveau C Horeca. Product/Dienst toevoegen (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorprddel
IS 'Niveau C Horeca. Product/Dienst verwijderen (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlbhorwznedt
IS 'Niveau B Horeca. Mag vergunningnummer wijzigen (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlbhorztedt
IS 'Niveau B Horeca. Aanvraagdatum vergnr, en soortvergunning wijzigen recht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcorregtent
IS 'Niveau C. Horeca... wijzigrecht (externe) tbcorrespondentie.dvexttracktrace';

CREATE UNIQUE INDEX idu_horrechten_keyrechten ON public.tbhorrechten
 USING btree (dnkeyrechten);