Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Rechtentabel voor de module handhavingen
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
dnkey |
serial |
|
nextval('tbhhrechten_dnkey_seq'::regclass) |
Primary. |
|||
|
dnkeyrechten |
integer |
|
|
|
Foreign Key naar TbRechten.DnKey. Op deze kolom staat een unieke index. |
||
|
|
dlbhahedt |
char(1) |
|
|
|
'F'::bpchar |
Niveau B Handhaving Wijzigrecht (T of F). |
|
|
dlbhahins |
char(1) |
|
|
|
'F'::bpchar |
Niveau B Handhaving Nieuwrecht (T of F). |
|
|
dlbhahdel |
char(1) |
|
|
|
'F'::bpchar |
Niveau B Handhaving Verwijderrecht (T of F). |
|
|
dlbhahblokkedt |
char(1) |
|
|
|
'F'::bpchar |
Niveau B Handhaving Blokkeerrecht (T of F). |
|
|
dlbhahverzledt |
char(1) |
|
|
|
'F'::bpchar |
Niveau B Handhaving Verzendlijst maken (T of F). |
|
|
dlbhahmemovsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau B Handhaving Memo zichtbaar (T of F). |
|
|
dlbhahverplaats |
char(1) |
|
|
|
'F'::bpchar |
Niveau B Handhaving. Verplaatsrecht. |
|
|
dlbhahgroepedt |
char(1) |
|
|
|
'F'::bpchar |
Niveau B. Handhavingen. Groepverg. wijzigen. |
|
|
dlbhahkopie |
char(1) |
|
|
|
'F'::bpchar |
Niveau B Handhavingen. Kopieerrecht. |
|
|
dlbhahmemoedt |
char(1) |
|
|
|
'F'::bpchar |
Niveau B. Handhavingen. Memo wijzigen. |
|
|
dlchahibbvsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Ibb zichtbaar (T of F). |
|
|
dlchahibbedt |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Ibb wijzigen (T of F). |
|
|
dlchahibbins |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Ibb nieuw (T of F). |
|
|
dlchahibbdel |
char(1) |
|
|
|
'F'::bpchar |
Niet meer in gebruik. |
|
|
dlchahprovsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Procedures zichtbaar (T of F). |
|
|
dlchahproedt |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Procedures wijzigen (T of F). |
|
|
dlchahproins |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Procedures nieuw (T of F). |
|
|
dlchahprodel |
char(1) |
|
|
|
'F'::bpchar |
Niveau C handhaving Procedures verwijderen (T of F). |
|
|
dlchahadvvsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Adviezen zichtbaar (T of F). |
|
|
dlchahadvedt |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Adviezen nieuw (T of F). |
|
|
dlchahadvins |
char(1) |
|
|
|
'F'::bpchar |
|
|
|
dlchahadvdel |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Adviezen verwijderen (T of F). |
|
|
dlchahinvvsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Invorddringen zichtbaar (T of F). |
|
|
dlchahinvedt |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Invorderingen wijzigen (T of F). |
|
|
dlchahinvins |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Invorderingen nieuw (T of F). |
|
|
dlchahinvdel |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Invorderingen verwijderen (T of F). |
|
|
dlchahcorvsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving correspondentie zichtbaar (T of F). |
|
|
dlchahcoredt |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving correspondentie wijzigen (T of F). |
|
|
dlchahcorins |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving correspondentie nieuw (T of F). |
|
|
dlchahcordel |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving correspondentie verwijderen (T of F). |
|
|
dlchahcadvsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving contactadressen zichtbaar (T of F). |
|
|
dlchahcadins |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving contactadressen koppeling maken (T of F). |
|
|
dlchahcaddel |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving contactadressen koppeling verwijderen (T of F). |
|
|
dlchahlogvsb |
char(1) |
|
|
|
'F'::bpchar |
Wordt niet meer gebruikt sinds versie 307 |
|
|
dlchahlogedt |
char(1) |
|
|
|
'F'::bpchar |
Wordt niet meer gebruikt sinds versie 307 |
|
|
dlchahlogins |
char(1) |
|
|
|
'F'::bpchar |
Wordt niet meer gebruikt sinds versie 307 |
|
|
dlchahlogdel |
char(1) |
|
|
|
'F'::bpchar |
Wordt niet meer gebruikt sinds versie 307 |
|
|
dlchahcinvsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Corresp-IN zichtbaar (T of F). |
|
|
dlchahcinedt |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Corresp-IN wijzigen (T of F). |
|
|
dlchahcinins |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Corresp-IN nieuw (T of F). |
|
|
dlchahcindel |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Corresp-IN del (T of F). |
|
|
dlchahcompr |
char(1) |
|
|
|
'F'::bpchar |
(Niveau C Handhaving Compressie Termijnbewaking). Wordt niet gebruikt. |
|
|
dlchahadvinedt |
char(1) |
|
|
|
'T'::bpchar |
Niveau C. Handhavingen. Adviesinstantie wijzigbaar. |
|
|
dlchahadvdatedt |
char(1) |
|
|
|
'F'::bpchar |
Niveau C. Adviezen. Wijzigrecht kolom DdDateringadvies van tabel TbAdviezen bij handhaving (T of F). |
|
|
dlchahinsedt |
char(1) |
|
|
|
'F'::bpchar |
Niveau C. handhaving Inspecties. Wijzigrecht (T of F). |
|
|
dlchahinsvsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau C. handhaving Inspecties zichtbaar (T of F). |
|
|
dlchahinsins |
char(1) |
|
|
|
'F'::bpchar |
Niveau C. handhaving Inspecties. Insertrecht (T of F). |
|
|
dlchahinsdel |
char(1) |
|
|
|
'F'::bpchar |
Niveau C. handhaving Inspecties verwijderrecht (T of F). |
|
|
dlchahcordms |
char(1) |
|
|
|
'F'::bpchar |
Niveau C. handhaving. Correspondentie. DMS-kolom muteerbaar |
|
|
dlchahcorodt |
char(1) |
|
|
|
'F'::bpchar |
Niveau C. handhaving. Correspondentie. Opgeslagen document-kolom muteerbaar. |
|
|
dlchahwelstandvsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving recht om welstandaviezen in te zien (T of F). |
|
|
dlchahwelstandins |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving recht om welstandaviezen aan te maken (T of F). |
|
|
dlchahwelstanddel |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving recht om welstandaviezen te verwijderen (T of F). |
|
|
dlchahwelstandedt |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving recht om welstandaviezen te muteren (T of F). |
|
|
dlbhahsnelins |
char(1) |
|
|
|
'T'::bpchar |
Niveau B. Handhavingen. Mag externe zaaknummers wijzigingen (dvdmscode, dvintzaakcode dvzaaknrbevgezag). |
|
|
dlchahinsdms |
char(1) |
|
|
|
'F'::bpchar |
Niveau C. Handhavingen. Inspecties. Mag externe zaaknummers van inspectietraject wijzigingen (dvdmscode, dvintzaakcode). |
|
|
dlchahadvdms |
char(1) |
|
|
|
'F'::bpchar |
Niveau C. Handhavingen. Adviezen. Mag externe zaaknummers van advies wijzigingen (dvdmscode, dvintzaakcode). |
|
|
dlbhahodedt |
char(1) |
|
|
|
'T'::bpchar |
Niveau B. Handhavingen. Mag Wave-handhavingsnummer (dvaanschrijfnr), soortzaak en startdatum (ddverzoekdatum) wijzigen. |
|
|
dlbhahhlink |
char(1) |
|
|
|
'F'::bpchar |
Niveau B. Handhavingen. Mag hyperlink starten vanuit powerportal handhavingdetail. |
|
|
dlchahdwsvsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Dwangsom zichtbaar (T of F). |
|
|
dlchahdwsedt |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Dwangsom wijzigen (T of F). |
|
|
dlchahdwsins |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Dwangsom nieuw (T of F). |
|
|
dlchahdwsdel |
char(1) |
|
|
|
'F'::bpchar |
Niveau C Handhaving Dwangsom delete (T of F). |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|
cfk_hhrechten_keyrechten |
dnkeyrechten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
---|---|---|
chk_hhrechten_dlbhahblokkedt |
dlbhahblokkedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlbhahdel |
dlbhahdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlbhahedt |
dlbhahedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlbhahgroepedt |
dlbhahgroepedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlbhahins |
dlbhahins = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlbhahkopie |
dlbhahkopie = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlbhahmemoedt |
dlbhahmemoedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlbhahmemovsb |
dlbhahmemovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlbhahsnelins |
dlbhahsnelins = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlbhahverplaats |
dlbhahverplaats = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlbhahverzledt |
dlbhahverzledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahadvdel |
dlchahadvdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahadvedt |
dlchahadvedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahadvinedt |
dlchahadvinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahadvins |
dlchahadvins = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahadvvsb |
dlchahadvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahcaddel |
dlchahcaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahcadins |
dlchahcadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahcadvsb |
dlchahcadvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahcindel |
dlchahcindel = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahcinedt |
dlchahcinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahcinins |
dlchahcinins = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahcinvsb |
dlchahcinvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahcompr |
dlchahcompr = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahcordel |
dlchahcordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahcordms |
dlchahcordms = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahcoredt |
dlchahcoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahcorins |
dlchahcorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahcorodt |
dlchahcorodt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahcorvsb |
dlchahcorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahibbdel |
dlchahibbdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahibbedt |
dlchahibbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahibbins |
dlchahibbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahibbvsb |
dlchahibbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahinvdel |
dlchahinvdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahinvedt |
dlchahinvedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahinvins |
dlchahinvins = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahinvvsb |
dlchahinvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahlogdel |
dlchahlogdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahlogedt |
dlchahlogedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahlogins |
dlchahlogins = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahlogvsb |
dlchahlogvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahprodel |
dlchahprodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahproedt |
dlchahproedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahproins |
dlchahproins = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahprovsb |
dlchahprovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahwelstdel |
dlchahwelstanddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahwelstedt |
dlchahwelstandedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahwelstins |
dlchahwelstandins = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_dlchahwelstvsb |
dlchahwelstandvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_hahadvdatedt |
dlchahadvdatedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_hahinsdel |
dlchahinsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_hahinsedt |
dlchahinsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_hahinsins |
dlchahinsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_hhrechten_hahinsvsb |
dlchahinsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_tbhhrechten_dlbhahhlink |
dlbhahhlink = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_tbhhrechten_dlbhahodedt |
dlbhahodedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_tbhhrechten_dlchahadvdms |
dlchahadvdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
chk_tbhhrechten_dlchahdwsdel |
dlchahdwsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_tbhhrechten_dlchahdwsedt |
dlchahdwsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_tbhhrechten_dlchahdwsins |
dlchahdwsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_tbhhrechten_dlchahdwsvsb |
dlchahdwsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_tbhhrechten_dlchahinsdms |
dlchahinsdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
cnn_hhrechten_dlbhahsnelins |
dlbhahsnelins IS NOT NULL |
|
cnn_hhrechten_dlchahcordms |
dlchahcordms IS NOT NULL |
|
cnn_hhrechten_dlchahcorodt |
dlchahcorodt IS NOT NULL |
|
cnn_hhrechten_dlchahwelstdel |
dlchahwelstanddel IS NOT NULL |
|
cnn_hhrechten_dlchahwelstedt |
dlchahwelstandedt IS NOT NULL |
|
cnn_hhrechten_dlchahwelstins |
dlchahwelstandins IS NOT NULL |
|
cnn_hhrechten_dlchahwelstvsb |
dlchahwelstandvsb IS NOT NULL |
|
cnn_hhrechten_dnkeyrechten |
dnkeyrechten IS NOT NULL |
|
cnn_tbhhrechten_dlbhahhlink |
dlbhahhlink IS NOT NULL |
|
cnn_tbhhrechten_dlbhahodedt |
dlbhahodedt IS NOT NULL |
|
cnn_tbhhrechten_dlchahdwsdel |
dlchahdwsdel IS NOT NULL |
|
cnn_tbhhrechten_dlchahdwsedt |
dlchahdwsedt IS NOT NULL |
|
cnn_tbhhrechten_dlchahdwsins |
dlchahdwsins IS NOT NULL |
|
cnn_tbhhrechten_dlchahdwsvsb |
dlchahdwsvsb IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
cpk_tbhhrechten |
btree |
|
dnkey |
|
||
idu_hhrechten_keyrechten |
btree |
|
dnkeyrechten |
|
|
Triggers
There are no triggers for table tbhhrechten
Rules
There are no rules for table tbhhrechten
Referenced
There are no tables referenced by table tbhhrechten
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
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 'F'::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,
CONSTRAINT cpk_tbhhrechten PRIMARY KEY(dnkey),
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_dlchahadvvsb CHECK (dlchahadvvsb = ANY (ARRAY['T'::bpchar, 'F'::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_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_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_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_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_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_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_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 cnn_hhrechten_dlbhahsnelins CHECK (dlbhahsnelins IS NOT NULL),
CONSTRAINT cnn_hhrechten_dlchahcordms CHECK (dlchahcordms IS NOT NULL),
CONSTRAINT cnn_hhrechten_dlchahcorodt CHECK (dlchahcorodt 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_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 cfk_hhrechten_keyrechten FOREIGN KEY (dnkeyrechten)
REFERENCES public.tbrechten(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
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 correspondentie zichtbaar (T of F).';
COMMENT ON COLUMN public.tbhhrechten.dlchahcoredt
IS 'Niveau C Handhaving correspondentie wijzigen (T of F).';
COMMENT ON COLUMN public.tbhhrechten.dlchahcorins
IS 'Niveau C Handhaving correspondentie nieuw (T of F).';
COMMENT ON COLUMN public.tbhhrechten.dlchahcordel
IS 'Niveau C Handhaving correspondentie verwijderen (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 (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 Wave-handhavingsnummer (dvaanschrijfnr), soortzaak en startdatum (ddverzoekdatum) wijzigen.';
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 Dwangsom zichtbaar (T of F).';
COMMENT ON COLUMN public.tbhhrechten.dlchahdwsedt
IS 'Niveau C Handhaving Dwangsom wijzigen (T of F).';
COMMENT ON COLUMN public.tbhhrechten.dlchahdwsins
IS 'Niveau C Handhaving Dwangsom nieuw (T of F).';
COMMENT ON COLUMN public.tbhhrechten.dlchahdwsdel
IS 'Niveau C Handhaving Dwangsom delete (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 22-2-2017 10:50 |
![]() ![]() ![]() |