Datadictionary OpenWave 3.1.25

Table: tbhhrechten

Schema

public

Owner

waveuser005

Tablespace

(default)

Descriptions

Rechtentabel voor de module handhavingen

Fields

Foreign Keys

Check Constraints

Indices

Triggers

There are no triggers for table tbhhrechten

Rules

There are no rules for table tbhhrechten

Policies

There are no policies for table tbhhrechten

Referenced

There are no tables referenced by table tbhhrechten

Properties

Definition

CREATE TABLE public.tbhhrechten (
 dnkey SERIAL,
 dnkeyrechten INTEGER,
 dlbhahedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahins CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahblokkedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahverzledt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahmemovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahverplaats CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahgroepedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahkopie CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahmemoedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahibbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchahibbedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahibbins CHAR(1) DEFAULT 'F'::bpchar,
 dlchahibbdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchahprovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchahproedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahproins CHAR(1) DEFAULT 'F'::bpchar,
 dlchahprodel CHAR(1) DEFAULT 'F'::bpchar,
 dlchahadvvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchahadvedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahadvins CHAR(1) DEFAULT 'F'::bpchar,
 dlchahadvdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchahinvvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchahinvedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahinvins CHAR(1) DEFAULT 'F'::bpchar,
 dlchahinvdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcorvsb CHAR(1) DEFAULT 'T'::bpchar,
 dlchahcoredt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcorins CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcordel CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcadvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcadins CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcaddel CHAR(1) DEFAULT 'F'::bpchar,
 dlchahlogvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchahlogedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahlogins CHAR(1) DEFAULT 'F'::bpchar,
 dlchahlogdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcinvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcinins CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcindel CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcompr CHAR(1) DEFAULT 'F'::bpchar,
 dlchahadvinedt CHAR(1) DEFAULT 'T'::bpchar,
 dlchahadvdatedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahinsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahinsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchahinsins CHAR(1) DEFAULT 'F'::bpchar,
 dlchahinsdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcordms CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcorodt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahwelstandvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchahwelstandins CHAR(1) DEFAULT 'F'::bpchar,
 dlchahwelstanddel CHAR(1) DEFAULT 'F'::bpchar,
 dlchahwelstandedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahsnelins CHAR(1) DEFAULT 'T'::bpchar,
 dlchahinsdms CHAR(1) DEFAULT 'F'::bpchar,
 dlchahadvdms CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahodedt CHAR(1) DEFAULT 'T'::bpchar,
 dlbhahhlink CHAR(1) DEFAULT 'F'::bpchar,
 dlchahdwsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchahdwsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahdwsins CHAR(1) DEFAULT 'F'::bpchar,
 dlchahdwsdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchahbezwvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchahbezwedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahbezwins CHAR(1) DEFAULT 'F'::bpchar,
 dlchahbezwdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchahbezwdms CHAR(1) DEFAULT 'F'::bpchar,
 dlchahuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchahuurins CHAR(1) DEFAULT 'F'::bpchar,
 dlchahuurdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchahuuredt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahinsuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchahbezwuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchahadvuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahafsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcorregvsb CHAR(1) DEFAULT 'T'::bpchar,
 dlchahcorregdwl CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcordocdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcorwmo CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahzkpvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahzkpins CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahzkpedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahzkpdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcorreghnm CHAR(1) DEFAULT 'F'::bpchar,
 dlchahprdedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahinsovbzdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchahprdins CHAR(1) DEFAULT 'F'::bpchar,
 dlchahprddel CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahwznedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahztedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchahcorregtent CHAR(1) DEFAULT 'F'::bpchar,
 dlbhahzkphoofdedt CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tbhhrechten PRIMARY KEY(dnkey),
 CONSTRAINT chk_hhrecht_dlchahcorregdwl CHECK (dlchahcorregdwl = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrecht_dlchahcorregtent CHECK (dlchahcorregtent = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrecht_dlchahcorregvsb CHECK (dlchahcorregvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_dlbhahafsedt CHECK (dlbhahafsedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_dlbhahblokkedt CHECK (dlbhahblokkedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlbhahdel CHECK (dlbhahdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlbhahedt CHECK (dlbhahedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlbhahgroepedt CHECK (dlbhahgroepedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlbhahins CHECK (dlbhahins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlbhahkopie CHECK (dlbhahkopie = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlbhahmemoedt CHECK (dlbhahmemoedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlbhahmemovsb CHECK (dlbhahmemovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlbhahsnelins CHECK (dlbhahsnelins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlbhahverplaats CHECK (dlbhahverplaats = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlbhahverzledt CHECK (dlbhahverzledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahadvdel CHECK (dlchahadvdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahadvedt CHECK (dlchahadvedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahadvinedt CHECK (dlchahadvinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahadvins CHECK (dlchahadvins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahadvuurvsb CHECK (dlchahadvuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahadvvsb CHECK (dlchahadvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahbezwdel CHECK (dlchahbezwdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahbezwdms CHECK (dlchahbezwdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahbezwedt CHECK (dlchahbezwedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahbezwins CHECK (dlchahbezwins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahbezwuurvsb CHECK (dlchahbezwuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahbezwvsb CHECK (dlchahbezwvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahcaddel CHECK (dlchahcaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahcadins CHECK (dlchahcadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahcadvsb CHECK (dlchahcadvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahcindel CHECK (dlchahcindel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahcinedt CHECK (dlchahcinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahcinins CHECK (dlchahcinins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahcinvsb CHECK (dlchahcinvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahcompr CHECK (dlchahcompr = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahcordel CHECK (dlchahcordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahcordms CHECK (dlchahcordms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahcordocdel CHECK (dlchahcordocdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahcoredt CHECK (dlchahcoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahcorins CHECK (dlchahcorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahcorodt CHECK (dlchahcorodt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahcorreghnm CHECK (dlchahcorreghnm = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahcorvsb CHECK (dlchahcorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahibbdel CHECK (dlchahibbdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahibbedt CHECK (dlchahibbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahibbins CHECK (dlchahibbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahibbvsb CHECK (dlchahibbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahinsuurvsb CHECK (dlchahinsuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahinvdel CHECK (dlchahinvdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahinvedt CHECK (dlchahinvedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahinvins CHECK (dlchahinvins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahinvvsb CHECK (dlchahinvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahlogdel CHECK (dlchahlogdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahlogedt CHECK (dlchahlogedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahlogins CHECK (dlchahlogins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahlogvsb CHECK (dlchahlogvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahprodel CHECK (dlchahprodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahproedt CHECK (dlchahproedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahproins CHECK (dlchahproins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahprovsb CHECK (dlchahprovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahuurdel CHECK (dlchahuurdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahuuredt CHECK (dlchahuuredt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahuurins CHECK (dlchahuurins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahuurvsb CHECK (dlchahuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahwelstdel CHECK (dlchahwelstanddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahwelstedt CHECK (dlchahwelstandedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahwelstins CHECK (dlchahwelstandins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlchahwelstvsb CHECK (dlchahwelstandvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_dlcomgcorwmo CHECK (dlchahcorwmo = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_hahadvdatedt CHECK (dlchahadvdatedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_hahinsdel CHECK (dlchahinsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_hahinsedt CHECK (dlchahinsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_hahinsins CHECK (dlchahinsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_hhrechten_hahinsovbzdel CHECK (dlchahinsovbzdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_hhrechten_hahinsvsb CHECK (dlchahinsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbhhrechten_dlbhahhlink CHECK (dlbhahhlink = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbhhrechten_dlbhahodedt CHECK (dlbhahodedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbhhrechten_dlbhahwznedt CHECK (dlbhahwznedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbhhrechten_dlbhahzkphoofdedt CHECK (dlbhahzkphoofdedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbhhrechten_dlbhahztedt CHECK (dlbhahztedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbhhrechten_dlchahadvdms CHECK (dlchahadvdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbhhrechten_dlchahdwsdel CHECK (dlchahdwsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbhhrechten_dlchahdwsedt CHECK (dlchahdwsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbhhrechten_dlchahdwsins CHECK (dlchahdwsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbhhrechten_dlchahdwsvsb CHECK (dlchahdwsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbhhrechten_dlchahinsdms CHECK (dlchahinsdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbhhrechten_dlchahprddel CHECK (dlchahprddel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbhhrechten_dlchahprdedt CHECK (dlchahprdedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbhhrechten_dlchahprdins CHECK (dlchahprdins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbhhrechtent_dlbhahzkpdel CHECK (dlbhahzkpdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbhhrechtent_dlbhahzkpedt CHECK (dlbhahzkpedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbhhrechtent_dlbhahzkpins CHECK (dlbhahzkpins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbhhrechtent_dlbhahzkpvsb CHECK (dlbhahzkpvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT cnn_hhrecht_dlchahcorregdwl CHECK (dlchahcorregdwl IS NOT NULL),
 CONSTRAINT cnn_hhrecht_dlchahcorregtent CHECK (dlchahcorregtent IS NOT NULL),
 CONSTRAINT cnn_hhrecht_dlchahcorregvsb CHECK (dlchahcorregvsb IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlbhahafsedt CHECK (dlbhahafsedt IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlbhahsnelins CHECK (dlbhahsnelins IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahadvuurvsb CHECK (dlchahadvuurvsb IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahbezwdel CHECK (dlchahbezwdel IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahbezwdms CHECK (dlchahbezwdms IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahbezwedt CHECK (dlchahbezwedt IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahbezwins CHECK (dlchahbezwins IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahbezwuurvsb CHECK (dlchahbezwuurvsb IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahbezwvsb CHECK (dlchahbezwvsb IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahcordms CHECK (dlchahcordms IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahcordocdel CHECK (dlchahcordocdel IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahcorodt CHECK (dlchahcorodt IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahcorreghnm CHECK (dlchahcorreghnm IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahcorwmo CHECK (dlchahcorwmo IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahinsuurvsb CHECK (dlchahinsuurvsb IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahuurdel CHECK (dlchahuurdel IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahuuredt CHECK (dlchahuuredt IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahuurins CHECK (dlchahuurins IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahuurvsb CHECK (dlchahuurvsb IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahwelstdel CHECK (dlchahwelstanddel IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahwelstedt CHECK (dlchahwelstandedt IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahwelstins CHECK (dlchahwelstandins IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dlchahwelstvsb CHECK (dlchahwelstandvsb IS NOT NULL),
 CONSTRAINT cnn_hhrechten_dnkeyrechten CHECK (dnkeyrechten IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlbhahhlink CHECK (dlbhahhlink IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlbhahodedt CHECK (dlbhahodedt IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlbhahwznedt CHECK (dlbhahwznedt IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlbhahzkpdel CHECK (dlbhahzkpdel IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlbhahzkpedt CHECK (dlbhahzkpedt IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlbhahzkphoofdedt CHECK (dlbhahzkphoofdedt IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlbhahzkpins CHECK (dlbhahzkpins IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlbhahzkpvsb CHECK (dlbhahzkpvsb IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlbhahztedt CHECK (dlbhahztedt IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlchahdwsdel CHECK (dlchahdwsdel IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlchahdwsedt CHECK (dlchahdwsedt IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlchahdwsins CHECK (dlchahdwsins IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlchahdwsvsb CHECK (dlchahdwsvsb IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlchahinsovbzdel CHECK (dlchahinsovbzdel IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlchahprddel CHECK (dlchahprddel IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlchahprdedt CHECK (dlchahprdedt IS NOT NULL),
 CONSTRAINT cnn_tbhhrechten_dlchahprdins CHECK (dlchahprdins IS NOT NULL),
 CONSTRAINT cfk_hhrechten_keyrechten FOREIGN KEY (dnkeyrechten)
   REFERENCES public.tbrechten(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) ;

COMMENT ON TABLE public.tbhhrechten
IS 'Rechtentabel voor de module handhavingen';

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

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

COMMENT ON COLUMN public.tbhhrechten.dlbhahedt
IS 'Niveau B Handhaving Wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlbhahins
IS 'Niveau B Handhaving Nieuwrecht (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlbhahdel
IS 'Niveau B Handhaving Verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlbhahblokkedt
IS 'Niveau B Handhaving Blokkeerrecht (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlbhahverzledt
IS 'Niveau B Handhaving Verzendlijst maken (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlbhahmemovsb
IS 'Niveau B Handhaving Memo zichtbaar (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlbhahverplaats
IS 'Niveau B Handhaving. Verplaatsrecht.';

COMMENT ON COLUMN public.tbhhrechten.dlbhahgroepedt
IS 'Niveau B. Handhavingen. Groepverg. wijzigen.';

COMMENT ON COLUMN public.tbhhrechten.dlbhahkopie
IS 'Niveau B Handhavingen. Kopieerrecht.';

COMMENT ON COLUMN public.tbhhrechten.dlbhahmemoedt
IS 'Niveau B. Handhavingen. Memo wijzigen.';

COMMENT ON COLUMN public.tbhhrechten.dlchahibbvsb
IS 'Niveau C Handhaving Ibb zichtbaar (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahibbedt
IS 'Niveau C Handhaving Ibb wijzigen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahibbins
IS 'Niveau C Handhaving Ibb nieuw (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahibbdel
IS 'Niet meer in gebruik.';

COMMENT ON COLUMN public.tbhhrechten.dlchahprovsb
IS 'Niveau C Handhaving Procedures zichtbaar (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahproedt
IS 'Niveau C Handhaving Procedures wijzigen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahproins
IS 'Niveau C Handhaving Procedures nieuw (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahprodel
IS 'Niveau C handhaving Procedures verwijderen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahadvvsb
IS 'Niveau C Handhaving Adviezen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahadvedt
IS 'Niveau C Handhaving Adviezen nieuw (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahadvdel
IS 'Niveau C Handhaving Adviezen verwijderen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahinvvsb
IS 'Niveau C Handhaving Invorddringen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahinvedt
IS 'Niveau C Handhaving Invorderingen wijzigen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahinvins
IS 'Niveau C Handhaving Invorderingen nieuw (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahinvdel
IS 'Niveau C Handhaving Invorderingen verwijderen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahcorvsb
IS 'Niveau C Handhaving alle correspondentie zichtbaar (T of F). Default T';

COMMENT ON COLUMN public.tbhhrechten.dlchahcoredt
IS 'Niveau C Handhaving Registreren van documenten en geregistreerde correspondentie wijzigen metadata(T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahcorins
IS 'Niveau C Handhaving correspondentie creeren en uploaden van documenten (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahcordel
IS 'Niveau C Handhaving correspondentie verwijderen metadata (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahcadvsb
IS 'Niveau C Handhaving contactadressen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahcadins
IS 'Niveau C Handhaving contactadressen koppeling maken (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahcaddel
IS 'Niveau C Handhaving contactadressen koppeling verwijderen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahlogvsb
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbhhrechten.dlchahlogedt
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbhhrechten.dlchahlogins
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbhhrechten.dlchahlogdel
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbhhrechten.dlchahcinvsb
IS 'Niveau C Handhaving Corresp-IN zichtbaar (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahcinedt
IS 'Niveau C Handhaving Corresp-IN wijzigen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahcinins
IS 'Niveau C Handhaving Corresp-IN nieuw (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahcindel
IS 'Niveau C Handhaving Corresp-IN del (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahcompr
IS '(Niveau C Handhaving  Compressie Termijnbewaking). Wordt niet gebruikt.';

COMMENT ON COLUMN public.tbhhrechten.dlchahadvinedt
IS 'Niveau C. Handhavingen. Adviesinstantie wijzigbaar.';

COMMENT ON COLUMN public.tbhhrechten.dlchahadvdatedt
IS 'Niveau C. Adviezen. Wijzigrecht kolom DdDateringadvies van tabel TbAdviezen bij handhaving (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahinsedt
IS 'Niveau C. handhaving Inspecties. Wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahinsvsb
IS 'Niveau C. handhaving Inspecties zichtbaar (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahinsins
IS 'Niveau C. handhaving Inspecties. Insertrecht (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahinsdel
IS 'Niveau C. Handhaving Inspecties verwijderrecht (trajecten, overtredingen en bezoeken) (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahcordms
IS 'Niveau C. handhaving. Correspondentie. DMS-kolom muteerbaar';

COMMENT ON COLUMN public.tbhhrechten.dlchahcorodt
IS 'Niveau C. handhaving. Correspondentie. Opgeslagen document-kolom muteerbaar.';

COMMENT ON COLUMN public.tbhhrechten.dlchahwelstandvsb
IS 'Niveau C Handhaving recht om welstandaviezen in te zien (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahwelstandins
IS 'Niveau C Handhaving recht om welstandaviezen aan te maken (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahwelstanddel
IS 'Niveau C Handhaving recht om welstandaviezen te verwijderen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahwelstandedt
IS 'Niveau C Handhaving recht om welstandaviezen te muteren (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlbhahsnelins
IS 'Niveau B. Handhavingen. Mag externe zaaknummers wijzigingen (dvdmscode, dvintzaakcode dvzaaknrbevgezag).';

COMMENT ON COLUMN public.tbhhrechten.dlchahinsdms
IS 'Niveau C. Handhavingen. Inspecties. Mag externe zaaknummers van inspectietraject wijzigingen (dvdmscode, dvintzaakcode).';

COMMENT ON COLUMN public.tbhhrechten.dlchahadvdms
IS 'Niveau C. Handhavingen. Adviezen. Mag externe zaaknummers van advies wijzigingen (dvdmscode, dvintzaakcode).';

COMMENT ON COLUMN public.tbhhrechten.dlbhahodedt
IS 'Niveau B. Handhavingen. Mag startdatum (ddverzoekdatum) wijzigen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlbhahhlink
IS 'Niveau B. Handhavingen. Mag hyperlink starten vanuit powerportal handhavingdetail.';

COMMENT ON COLUMN public.tbhhrechten.dlchahdwsvsb
IS 'Niveau C Handhaving bestuurlijke maatregel zichtbaar (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahdwsedt
IS 'Niveau C Handhaving bestuurlijke maatregel wijzigen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahdwsins
IS 'Niveau C Handhaving bestuurlijke maatregel nieuw (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahdwsdel
IS 'Niveau C Handhaving bestuurlijke maatregel delete (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahbezwvsb
IS 'Niveau C. Handhaving. Bezwaar/beroep inzien (T of F)';

COMMENT ON COLUMN public.tbhhrechten.dlchahbezwedt
IS 'Niveau C. Handhaving.. Bezwaar/beroep wijzgen (T of F)';

COMMENT ON COLUMN public.tbhhrechten.dlchahbezwins
IS 'Niveau C. Handhaving. Bezwaar/beroep insert (T of F)';

COMMENT ON COLUMN public.tbhhrechten.dlchahbezwdel
IS 'Niveau C. Handhaving.. Bezwaar/beroep delete (T of F)';

COMMENT ON COLUMN public.tbhhrechten.dlchahbezwdms
IS 'Niveau C. Handhaving.. Bezwaar/beroep. dmscode (extern zaakidentificatie) muteren (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahuurvsb
IS 'Niveau C. Handhaving... uren inzien (T of F)';

COMMENT ON COLUMN public.tbhhrechten.dlchahuurins
IS 'Niveau C. Handhaving... uren insert (T of F)';

COMMENT ON COLUMN public.tbhhrechten.dlchahuurdel
IS 'Niveau C. Handhaving... uren delete (T of F)';

COMMENT ON COLUMN public.tbhhrechten.dlchahuuredt
IS 'Niveau C. Handhaving... uren wijzgen (T of F)';

COMMENT ON COLUMN public.tbhhrechten.dlchahinsuurvsb
IS 'Niveau C. inspecties bij Handhaving... uren inzien (T of F), edit- insert- delrechten via dlchahuuredt, dlchahuurins,dlchahuurdel';

COMMENT ON COLUMN public.tbhhrechten.dlchahbezwuurvsb
IS 'Niveau C. bezwaar/beroep bij Handhaving... uren inzien (T of F), edit- insert- delrechten via dlchahuuredt, dlchahuurins,dlchahuurdel';

COMMENT ON COLUMN public.tbhhrechten.dlchahadvuurvsb
IS 'Niveau C. adviezen bij Handhaving... uren inzien (T of F), edit- insert- delrechten via dlchahuuredt, dlchahuurins,dlchahuurdel';

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

COMMENT ON COLUMN public.tbhhrechten.dlchahcorregvsb
IS 'Niveau C handhaving Geregistreerde documenten zichtbaar (T of F) Default T';

COMMENT ON COLUMN public.tbhhrechten.dlchahcorregdwl
IS 'Niveau C Handhaving Geregistreerde documenten Maf geforceerd downloaden (T of F) Default F';

COMMENT ON COLUMN public.tbhhrechten.dlchahcordocdel
IS 'Niveau C Handhaving geregisteerde correspondentie verwijderen fysiek document(T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahcorwmo
IS 'Niveau C Handhaving Wijzigen metadata (hernoemen filenaam) ongeregistreerde documenten (T of F)';

COMMENT ON COLUMN public.tbhhrechten.dlbhahzkpvsb
IS 'Niveau C handhaving Kadastrale percelen zichtbaar (T of F)';

COMMENT ON COLUMN public.tbhhrechten.dlbhahzkpins
IS 'Niveau C Handhaving Kadastrale percelen insert (T of F)';

COMMENT ON COLUMN public.tbhhrechten.dlbhahzkpedt
IS 'Niveau C Handhaving Kadastrale percelen wijzigen(T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlbhahzkpdel
IS 'Niveau C Handhaving Kadastrale percelen delete (T of F)';

COMMENT ON COLUMN public.tbhhrechten.dlchahcorreghnm
IS 'Niveau C Handhaving Hernoemen geregistreerde documenten';

COMMENT ON COLUMN public.tbhhrechten.dlchahprdedt
IS 'Niveau C Handhaving Product/Dienst wijzigen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahinsovbzdel
IS 'Niveau C. Handhaving Alleen inspectiebezoeken en overtredingen verwijderen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahprdins
IS 'Niveau C Handhaving Product/Dienst toevoegen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahprddel
IS 'Niveau C Handhaving Product/Dienst verwijderen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlbhahwznedt
IS 'Niveau B. Handhavingen. Mag Wave-handhavingsnummer (dvaanschrijfnr) wijzigen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlbhahztedt
IS 'Niveau B. Handhavingen. Mag soortzaak wijzigen (T of F).';

COMMENT ON COLUMN public.tbhhrechten.dlchahcorregtent
IS 'Niveau C. Handhaving... wijzigrecht (externe) tbcorrespondentie.dvexttracktrace';

COMMENT ON COLUMN public.tbhhrechten.dlbhahzkphoofdedt
IS 'Niveau C. Handhavingen. Mag hoofdprojectlocatie-indicatie wijzigen (T of F).';

CREATE UNIQUE INDEX idu_hhrechten_keyrechten ON public.tbhhrechten
 USING btree (dnkeyrechten);

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13