Datadictionary OpenWave 3.1.11
 Previous topic Chapter index Next topic

Table: tbmilrechten

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

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

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbmilrechten_dnkey_seq'::regclass)

Primary.

 

dnkeyrechten

integer

 

 

 

Foreign Key naar TbRechten.DnKey. Op deze kolom staat een unieke index.

 

 

dlbmilinredt

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu inrichting Wijzigrecht (T of F).

 

 

dlbmilinrins

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu inrichting Nieuwrecht (T of F).

 

 

dlbmilinrdel

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu inrichting Verwijderrecht (T of F).

 

 

dlbmilinrblokkedt

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu inrichting Blokkeerrecht (T of F).

 

 

dlbmilinrverplaats

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu inrichting Verplaatsrecht.

 

 

dlbmilinrgroepedt

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu inrichting (T of F) Groepvergunnigen maken.

 

 

dlbmilinrmemovsb

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu inrichting Memo zichtbaar (T of F).

 

 

dlbmilinrkopie

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu inrichting. Kopieerrecht.

 

 

dlbmilinrmemoedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Milieu inrichting. Memo wijzigen.

 

 

dlcmilinrinsvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Inspecties zichtbaar (T of F).

 

 

dlcmilinrinsedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Inspecties wijzigen (T of F).

 

 

dlcmilinrinsins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Inspecties nieuw (T of F).

 

 

dlcmilinrinsdel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Inspecties verwijderen (T of F).

 

 

dlcmilinrcorvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting correspondentie zichtbaar (T of F).

 

 

dlcmilinrcoredt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting correspondentie wijzigen (T of F).

 

 

dlcmilinrcorins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting correspondentie nieuw (T of F).

 

 

dlcmilinrcordel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting correspondentie verwijderen (T of F).

 

 

dlcmilinrcadvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting contactadressen zichtbaar (T of F).

 

 

dlcmilinrcadins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting contactadressen koppeling maken (T of F).

 

 

dlcmilinrcaddel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting contactadressen koppeling verwijderen (T of F).

 

 

dlcmilinrlogvsb

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlcmilinrlogedt

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlcmilinrlogins

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlcmilinrlogdel

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlcmilinrcinvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Correspondentie Binnen Zichtbaar (T of F).

 

 

dlcmilinrcinedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Correspondentie Binnen Wijzigen (T of F).

 

 

dlcmilinrcinins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Correspondentie Binnen Nieuw (T of F).

 

 

dlcmilinrcindel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Correspondentie Binnen Verwijderen (T of F).

 

 

dlcmilinrivbvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting ROB (voorheen IVB) zichtbaar (T of F).

 

 

dlcmilinrivbedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting ROB (voorheen IVB) wijzigen (T of F).

 

 

dlcmilinrivbins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting ROB (vootheen IVB) nieuw (T of F).

 

 

dlcmilinrivbdel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting ROB (voorheen IVB) verwijderen (T of F).

 

 

dlcmilinrsbivsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting SBI zichtbaar (T of F).

 

 

dlcmilinrsbiedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting SBI wijzigen (T of F).

 

 

dlcmilinrsbiins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting SBI nieuw (T of F).

 

 

dlcmilinrsbidel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting SBI verwijderen (T of F).

 

 

dlcmilinrtrwvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting trefword zichtbaar (T of F).

 

 

dlcmilinrtrwins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting trefwoord nieuw (T of F).

 

 

dlcmilinrtrwedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting trefwoord wijzigen (T of F).

 

 

dlcmilinrtrwdel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting trefwoord verwijderen (T of F).

 

 

dlcmilinrstlvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Stallen zichtbaar (T of F).

 

 

dlcmilinrstlins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Stallen nieuw (T of F).

 

 

dlcmilinrstledt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Stallen wijzigen (T of F).

 

 

dlcmilinrstldel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Stallen verwijderen (T of F).

 

 

dlcmilinropsvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Opslag zichtbaar (T of F).

 

 

dlcmilinropsins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Opslag nieuw (T of F).

 

 

dlcmilinropsedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Opslag wijzigen (T of F).

 

 

dlcmilinropsdel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Opslag verwijderen (T of F).

 

 

dlcmilinrwatvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Water zichtbaar (T of F).

 

 

dlcmilinrwatins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Water nieuw (T of F).

 

 

dlcmilinrwatedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Water wijzigen (T of F).

 

 

dlcmilinrwatdel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Water verwijderen (T of F).

 

 

dlcmilinrlctvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Lucht zichtbaar (T of F).

 

 

dlcmilinrlctins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Lucht nieuw (T of F).

 

 

dlcmilinrlctedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Lucht wijzigen (T of F).

 

 

dlcmilinrlctdel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Lucht verwijderen (T of F).

 

 

dlcmilinrdivvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Diversen zichtbaar (T of F).

 

 

dlcmilinrdivins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Diversen nieuw (T of F).

 

 

dlcmilinrdivedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Diversen wijzigen (T of F).

 

 

dlcmilinrdivdel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Diversen verwijderen (T of F).

 

 

dlcmilinrklavsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Klachten zichtbaar (T of F).

 

 

dlcmilinrklains

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Klachten nieuw (T of F).

 

 

dlcmilinrklaedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Klachten wijzigen (T of F).

 

 

dlcmilinrkladel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Klachten verwijderen (T of F).

 

 

dlcmilinrctfvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Certificaten zichtbaar (T of F).

 

 

dlcmilinrctfins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Certificaten nieuw (T of F).

 

 

dlcmilinrctfedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Certificaten wijzigen (T of F).

 

 

dlcmilinrctfdel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Certificaten verwijderen (T of F).

 

 

dlbmilinrverzledt

char(1)

 

 

 

'F'::bpchar

Niveau B milinr Verzendlijst maken (T of F).

 

 

dlcmilinromsvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting OMS zichtbaar (T of F).

 

 

dlcmilinromsedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting OMS wijzigen (T of F).

 

 

dlcmilinromsins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting OMS nieuw (T of F).

 

 

dlcmilinromsdel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting OMS verwijder (T of F).

 

 

dlcmilinravpvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Aanvalsplannen en Lokatiecriteria zichtbaar (T of F).

 

 

dlcmilinravpedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu Aanvalsplannen en Lokatiecriteria wijzigen (T of F).

 

 

dlcmilinravpins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Aanvalsplannen en Lokatiecriteria nieuw (T of F).

 

 

dlcmilinravpdel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu inrichting Aanvalsplannen en Lokatiecriteria verwijder (T of F).

 

 

dlbmilinrsamen

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu inrichting Samenvoegen inrichtingen (T of F).

 

 

dlcmilinrcordms

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieuinrichting. Correspondentie. DMS-kolom muteerbaar

 

 

dlcmilinrcorodt

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieuinrichting. Correspondentie. Opgeslagen document-kolom muteerbaar.

 

 

dlcmilinrontvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieuinrichting Ontheffingen Zichtbaar (T of F).

 

 

dlcmilinrontedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieuinrichting Ontheffingen wijzigrecht (T of F).

 

 

dlcmilinrontins

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieuinrichting Ontheffingen insertrecht (T of F).

 

 

dlcmilinrontdel

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieuinrichting Ontheffingen verwijderrecht (T of F).

 

 

dlcmilinrenevsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieuinrichting Energie Zichtbaar (T of F).

 

 

dlcmilinreneedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieuinrichting Energie wijzigrecht (T of F).

 

 

dlcmilinreneins

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieuinrichting Energie insertrecht (T of F).

 

 

dlcmilinrenedel

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieuinrichting Energie verwijderrecht (T of F).

 

 

dlcmilinrkladms

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieuinrichting Klachten. Dmscode muteren (T of F).

 

 

dlcmilinrinsdms

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieuinrichting Inspecties. Dmscode muteren (T of F).

 

 

dlbmilinrhlink

char(1)

 

 

 

'F'::bpchar

Niveau B. Milieuinrichting. Mag hyperlink starten vanuit powerportal inrichtingdetail.

 

 

dlbmilinrdms

char(1)

 

 

 

'F'::bpchar

Niveau B. Milieuinrichting. Mag Zaakcode/DMS wijzigen.

 

 

dlcmilinrasbvsb

char(1)

 

 

 

'F'::bpchar

 

 

 

dlcmilinrasbins

char(1)

 

 

 

'F'::bpchar

 

 

 

dlcmilinrasbedt

char(1)

 

 

 

'F'::bpchar

 

 

 

dlcmilinrasbdel

char(1)

 

 

 

'F'::bpchar

 

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

cfk_tbmilrechten_keyrechten

dnkeyrechten

public.tbrechten

dnkey

Cascade

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

chk_milrecht_dlcmilinravpdel

dlcmilinravpdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinravpedt

dlcmilinravpedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinravpins

dlcmilinravpins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinravpvsb

dlcmilinravpvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinrcordms

dlcmilinrcordms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinrcorodt

dlcmilinrcorodt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinrenedel

dlcmilinrenedel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinreneedt

dlcmilinreneedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinreneins

dlcmilinreneins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinrenevsb

dlcmilinrenevsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinromsdel

dlcmilinromsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinromsedt

dlcmilinromsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinromsins

dlcmilinromsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinromsvsb

dlcmilinromsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinrontdel

dlcmilinrontdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinrontedt

dlcmilinrontedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinrontins

dlcmilinrontins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrecht_dlcmilinrontvsb

dlcmilinrontvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlbmilinrblok

dlbmilinrblokkedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlbmilinrdel

dlbmilinrdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlbmilinredt

dlbmilinredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlbmilinrgrpedt

dlbmilinrgroepedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlbmilinrins

dlbmilinrins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlbmilinrkopie

dlbmilinrkopie = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlbmilinrmmedt

dlbmilinrmemoedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlbmilinrmmvsb

dlbmilinrmemovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlbmilinrsamen

dlbmilinrsamen = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlbmilinrverp

dlbmilinrverplaats = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrcaddel

dlcmilinrcaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrcadins

dlcmilinrcadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrcadvsb

dlcmilinrcadvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrcindel

dlcmilinrcindel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrcinedt

dlcmilinrcinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrcinins

dlcmilinrcinins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrcinvsb

dlcmilinrcinvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrcordel

dlcmilinrcordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrcoredt

dlcmilinrcoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrcorins

dlcmilinrcorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrcorvsb

dlcmilinrcorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrctfdel

dlcmilinrctfdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrctfedt

dlcmilinrctfedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrctfins

dlcmilinrctfins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrctfvsb

dlcmilinrctfvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrdivdel

dlcmilinrdivdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrdivedt

dlcmilinrdivedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrdivins

dlcmilinrdivins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrdivvsb

dlcmilinrdivvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrinsdel

dlcmilinrinsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrinsedt

dlcmilinrinsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrinsins

dlcmilinrinsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrinsvsb

dlcmilinrinsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrivbdel

dlcmilinrivbdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrivbedt

dlcmilinrivbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrivbins

dlcmilinrivbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrivbvsb

dlcmilinrivbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrkladel

dlcmilinrkladel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrklaedt

dlcmilinrklaedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrklains

dlcmilinrklains = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrklavsb

dlcmilinrklavsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrlctdel

dlcmilinrlctdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrlctedt

dlcmilinrlctedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrlctins

dlcmilinrlctins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrlctvsb

dlcmilinrlctvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrlogdel

dlcmilinrlogdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrlogedt

dlcmilinrlogedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrlogins

dlcmilinrlogins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrlogvsb

dlcmilinrlogvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinropsdel

dlcmilinropsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinropsedt

dlcmilinropsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinropsins

dlcmilinropsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinropsvsb

dlcmilinropsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrsbidel

dlcmilinrsbidel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrsbiedt

dlcmilinrsbiedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrsbiins

dlcmilinrsbiins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrsbivsb

dlcmilinrsbivsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrstldel

dlcmilinrstldel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrstledt

dlcmilinrstledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrstlins

dlcmilinrstlins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrstlvsb

dlcmilinrstlvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrtrwdel

dlcmilinrtrwdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrtrwedt

dlcmilinrtrwedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrtrwins

dlcmilinrtrwins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrtrwvsb

dlcmilinrtrwvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrwatdel

dlcmilinrwatdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrwatedt

dlcmilinrwatedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrwatins

dlcmilinrwatins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlcmilinrwatvsb

dlcmilinrwatvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_dlverzendl

dlbmilinrverzledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_milrechten_keyrechten

dnkeyrechten IS NOT NULL

 

chk_tbmilr_dlcmilinrinsdms

dlcmilinrinsdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])

 

chk_tbmilr_dlcmilinrkladms

dlcmilinrkladms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])

 

chk_tbmilrecht_dlcmilinrasbdel

dlcmilinrasbdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_tbmilrecht_dlcmilinrasbedt

dlcmilinrasbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_tbmilrecht_dlcmilinrasbins

dlcmilinrasbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_tbmilrecht_dlcmilinrasbvsb

dlcmilinrasbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_tbmilrechten_dlbmilhlink

dlbmilinrhlink = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

chk_tbmilrechten_dlbmilinrdms

dlbmilinrdms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])

 

cnn_milrecht_dlcmilinrcordms

dlcmilinrcordms IS NOT NULL

 

cnn_milrecht_dlcmilinrcorodt

dlcmilinrcorodt IS NOT NULL

 

cnn_milrechten_dlverzendl

dlbmilinrverzledt IS NOT NULL

 

cnn_tbmilrecht_dlcmilinrasbdel

dlcmilinrasbdel IS NOT NULL

 

cnn_tbmilrecht_dlcmilinrasbedt

dlcmilinrasbedt IS NOT NULL

 

cnn_tbmilrecht_dlcmilinrasbins

dlcmilinrasbins IS NOT NULL

 

cnn_tbmilrecht_dlcmilinrasbvsb

dlcmilinrasbvsb IS NOT NULL

 

cnn_tbmilrechten_dlbmilhlink

dlbmilinrhlink IS NOT NULL

 

cnn_tbmilrechten_dlbmilinrdms

dlbmilinrdms IS NOT NULL

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbmilrechten

btree

 

dnkey

 

idu_milrechten_keyrechten

btree

 

dnkeyrechten

 

 

 

Triggers

There are no triggers for table tbmilrechten

 

Rules

There are no rules for table tbmilrechten

 

Referenced

There are no tables referenced by table tbmilrechten

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.tbmilrechten (
 dnkey SERIAL,
 dnkeyrechten INTEGER,
 dlbmilinredt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrins CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrblokkedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrverplaats CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrgroepedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrmemovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrkopie CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrmemoedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrinsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrinsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrinsins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrinsdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcorvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcoredt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcorins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcordel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcadvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcadins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcaddel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlogvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlogedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlogins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlogdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcinvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcinins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcindel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrivbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrivbedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrivbins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrivbdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrsbivsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrsbiedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrsbiins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrsbidel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrtrwvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrtrwins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrtrwedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrtrwdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrstlvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrstlins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrstledt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrstldel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinropsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinropsins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinropsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinropsdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrwatvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrwatins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrwatedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrwatdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlctvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlctins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlctedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrlctdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrdivvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrdivins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrdivedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrdivdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrklavsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrklains CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrklaedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrkladel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrctfvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrctfins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrctfedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrctfdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrverzledt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinromsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinromsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinromsins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinromsdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinravpvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinravpedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinravpins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinravpdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrsamen CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcordms CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrcorodt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrontvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrontedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrontins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrontdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrenevsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinreneedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinreneins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrenedel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrkladms CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrinsdms CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrhlink CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilinrdms CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrasbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrasbins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrasbedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilinrasbdel CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tbmilrechten PRIMARY KEY(dnkey),
 CONSTRAINT chk_milrecht_dlcmilinravpdel CHECK (dlcmilinravpdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinravpedt CHECK (dlcmilinravpedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinravpins CHECK (dlcmilinravpins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinravpvsb CHECK (dlcmilinravpvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrcordms CHECK (dlcmilinrcordms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrcorodt CHECK (dlcmilinrcorodt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrenedel CHECK (dlcmilinrenedel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinreneedt CHECK (dlcmilinreneedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinreneins CHECK (dlcmilinreneins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrenevsb CHECK (dlcmilinrenevsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinromsdel CHECK (dlcmilinromsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinromsedt CHECK (dlcmilinromsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinromsins CHECK (dlcmilinromsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinromsvsb CHECK (dlcmilinromsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrontdel CHECK (dlcmilinrontdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrontedt CHECK (dlcmilinrontedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrontins CHECK (dlcmilinrontins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrecht_dlcmilinrontvsb CHECK (dlcmilinrontvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrblok CHECK (dlbmilinrblokkedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrdel CHECK (dlbmilinrdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinredt CHECK (dlbmilinredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrgrpedt CHECK (dlbmilinrgroepedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrins CHECK (dlbmilinrins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrkopie CHECK (dlbmilinrkopie = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrmmedt CHECK (dlbmilinrmemoedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrmmvsb CHECK (dlbmilinrmemovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrsamen CHECK (dlbmilinrsamen = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlbmilinrverp CHECK (dlbmilinrverplaats = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcaddel CHECK (dlcmilinrcaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcadins CHECK (dlcmilinrcadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcadvsb CHECK (dlcmilinrcadvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcindel CHECK (dlcmilinrcindel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcinedt CHECK (dlcmilinrcinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcinins CHECK (dlcmilinrcinins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcinvsb CHECK (dlcmilinrcinvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcordel CHECK (dlcmilinrcordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcoredt CHECK (dlcmilinrcoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcorins CHECK (dlcmilinrcorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrcorvsb CHECK (dlcmilinrcorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrctfdel CHECK (dlcmilinrctfdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrctfedt CHECK (dlcmilinrctfedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrctfins CHECK (dlcmilinrctfins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrctfvsb CHECK (dlcmilinrctfvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrdivdel CHECK (dlcmilinrdivdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrdivedt CHECK (dlcmilinrdivedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrdivins CHECK (dlcmilinrdivins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrdivvsb CHECK (dlcmilinrdivvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrinsdel CHECK (dlcmilinrinsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrinsedt CHECK (dlcmilinrinsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrinsins CHECK (dlcmilinrinsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrinsvsb CHECK (dlcmilinrinsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrivbdel CHECK (dlcmilinrivbdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrivbedt CHECK (dlcmilinrivbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrivbins CHECK (dlcmilinrivbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrivbvsb CHECK (dlcmilinrivbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrkladel CHECK (dlcmilinrkladel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrklaedt CHECK (dlcmilinrklaedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrklains CHECK (dlcmilinrklains = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrklavsb CHECK (dlcmilinrklavsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlctdel CHECK (dlcmilinrlctdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlctedt CHECK (dlcmilinrlctedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlctins CHECK (dlcmilinrlctins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlctvsb CHECK (dlcmilinrlctvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlogdel CHECK (dlcmilinrlogdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlogedt CHECK (dlcmilinrlogedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlogins CHECK (dlcmilinrlogins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrlogvsb CHECK (dlcmilinrlogvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinropsdel CHECK (dlcmilinropsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinropsedt CHECK (dlcmilinropsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinropsins CHECK (dlcmilinropsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinropsvsb CHECK (dlcmilinropsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrsbidel CHECK (dlcmilinrsbidel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrsbiedt CHECK (dlcmilinrsbiedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrsbiins CHECK (dlcmilinrsbiins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrsbivsb CHECK (dlcmilinrsbivsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrstldel CHECK (dlcmilinrstldel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrstledt CHECK (dlcmilinrstledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrstlins CHECK (dlcmilinrstlins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrstlvsb CHECK (dlcmilinrstlvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrtrwdel CHECK (dlcmilinrtrwdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrtrwedt CHECK (dlcmilinrtrwedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrtrwins CHECK (dlcmilinrtrwins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrtrwvsb CHECK (dlcmilinrtrwvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrwatdel CHECK (dlcmilinrwatdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrwatedt CHECK (dlcmilinrwatedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrwatins CHECK (dlcmilinrwatins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlcmilinrwatvsb CHECK (dlcmilinrwatvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_dlverzendl CHECK (dlbmilinrverzledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milrechten_keyrechten CHECK (dnkeyrechten IS NOT NULL),
 CONSTRAINT chk_tbmilr_dlcmilinrinsdms CHECK (dlcmilinrinsdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbmilr_dlcmilinrkladms CHECK (dlcmilinrkladms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbmilrecht_dlcmilinrasbdel CHECK (dlcmilinrasbdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbmilrecht_dlcmilinrasbedt CHECK (dlcmilinrasbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbmilrecht_dlcmilinrasbins CHECK (dlcmilinrasbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbmilrecht_dlcmilinrasbvsb CHECK (dlcmilinrasbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbmilrechten_dlbmilhlink CHECK (dlbmilinrhlink = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbmilrechten_dlbmilinrdms CHECK (dlbmilinrdms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT cnn_milrecht_dlcmilinrcordms CHECK (dlcmilinrcordms IS NOT NULL),
 CONSTRAINT cnn_milrecht_dlcmilinrcorodt CHECK (dlcmilinrcorodt IS NOT NULL),
 CONSTRAINT cnn_milrechten_dlverzendl CHECK (dlbmilinrverzledt IS NOT NULL),
 CONSTRAINT cnn_tbmilrecht_dlcmilinrasbdel CHECK (dlcmilinrasbdel IS NOT NULL),
 CONSTRAINT cnn_tbmilrecht_dlcmilinrasbedt CHECK (dlcmilinrasbedt IS NOT NULL),
 CONSTRAINT cnn_tbmilrecht_dlcmilinrasbins CHECK (dlcmilinrasbins IS NOT NULL),
 CONSTRAINT cnn_tbmilrecht_dlcmilinrasbvsb CHECK (dlcmilinrasbvsb IS NOT NULL),
 CONSTRAINT cnn_tbmilrechten_dlbmilhlink CHECK (dlbmilinrhlink IS NOT NULL),
 CONSTRAINT cnn_tbmilrechten_dlbmilinrdms CHECK (dlbmilinrdms IS NOT NULL),
 CONSTRAINT cfk_tbmilrechten_keyrechten FOREIGN KEY (dnkeyrechten)
   REFERENCES public.tbrechten(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
)
WITH (oids = false);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50
 Previous topic Chapter index Next topic