Datadictionary OpenWave 3.1.11
 Previous topic Chapter index Next topic

Table: tbomgrechten

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Rechtentabel voor de module omgevingsvergunning

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbomgrechten_dnkey_seq'::regclass)

Primary.

 

dnkeyrechten

integer

 

 

 

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

 

 

dlbomgedt

char(1)

 

 

 

'F'::bpchar

Niveau B Omgevings vergunning Wijzigrecht (T of F).

 

 

dlbomgins

char(1)

 

 

 

'F'::bpchar

Niveau B Omgevings vergunning Nieuwrecht (T of F).

 

 

dlbomgdel

char(1)

 

 

 

'F'::bpchar

Niveau B Omgevings vergunning Verwijderrecht (T of F).

 

 

dlbomgverplaats

char(1)

 

 

 

'F'::bpchar

Niveau B Omgevingsvergunning Verplaatsrecht.

 

 

dlbomgblokkedt

char(1)

 

 

 

'F'::bpchar

Niveau B Omgevings vergunning Blokkeerrecht (T of F).

 

 

dlbomgmemovsb

char(1)

 

 

 

'F'::bpchar

Niveau B Omgevings vergunning Memo zichtbaar (T of F).

 

 

dlbomgmemoedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Omgevings vergunning. Memo wijzigen.

 

 

dlcomginsvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Inspecties zichtbaar (T of F).

 

 

dlcomginsedt

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Inspecties wijzigen (T of F).

 

 

dlcomginsins

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Inspecties nieuw (T of F).

 

 

dlcomginsdel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Inspecties verwijderen (T of F).

 

 

dlcomgcorvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning correspondentie zichtbaar (T of F).

 

 

dlcomgcoredt

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning correspondentie wijzigen (T of F).

 

 

dlcomgcorins

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning correspondentie nieuw (T of F).

 

 

dlcomgcordel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning correspondentie verwijderen (T of F).

 

 

dlcomgcadvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning contactadressen zichtbaar (T of F).

 

 

dlcomgcadins

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning contactadressen koppeling maken (T of F).

 

 

dlcomgcaddel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning contactadressen koppeling verwijderen (T of F).

 

 

dlcomgadvvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning adviezen zichtbaar (T of F).

 

 

dlcomgadvedt

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning adviezen wijzigen (T of F).

 

 

dlcomgadvins

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Adviezen nieuw (T of F).

 

 

dlcomgadvdel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning adviezen verwijderen (T of F).

 

 

dlcomgcinvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Correspondentie Binnen Zichtbaar (T of F).

 

 

dlcomgcinedt

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Correspondentie Binnen Wijzigen (T of F).

 

 

dlcomgcinins

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Correspondentie Binnen Nieuw (T of F).

 

 

dlcomgcindel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Correspondentie Binnen Verwijderen (T of F).

 

 

dlcomgibbvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning in behandeling bij zichtbaar (T of F).

 

 

dlcomgibbedt

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning in behandeling bij wijzigen (T of F).

 

 

dlcomgibbins

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning in behandeling bij nieuw (T of F).

 

 

dlcomgprovsb

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Procedures zichtbaar (T of F).

 

 

dlcomgproedt

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Procedures zichtbaar (T of F).

 

 

dlcomgproins

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Procedures nieuw (T of F).

 

 

dlcomgprodel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning procedures verwijderen (T of F).

 

 

dlcomgproahn

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning procedures aanhouden en termijn van orde (T of F).

 

 

dlcomgprovdg

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning procedures verdagen (T of F).

 

 

dlcomgadvdatedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Adviezen. Wijzigrecht kolom DdDateringadvies van tabel TbAdviezen bij Omgevings vergunning (T of F).

 

 

dlcomgadvinedt

char(1)

 

 

 

'T'::bpchar

Niveau C. Omgevings vergunning Adviesinstantie wijzigbaar bij adviezen.

 

 

dlcomgtstvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Toestemmingen zichtbaar (T of F).

 

 

dlcomgtstedt

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Toestemmingen wijzigen (T of F).

 

 

dlcomgtstins

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Toestemmingen nieuw (T of F).

 

 

dlcomgtstdel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning toestemmingen verwijderen (T of F).

 

 

dlcomglegvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning leges zichtbaar (T of F).

 

 

dlcomglegedt

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning leges wijzigen (T of F).

 

 

dlcomglegins

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning leges nieuw (T of F).

 

 

dlcomglegdel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning leges verwijderen (T of F).

 

 

dlcomglegexpnot

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning recht om exportdatum leges te wijzigen n (T of F).

 

 

dlcomgwelstandvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning recht om welstandaviezen in te zien (T of F).

 

 

dlcomgwelstandins

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning recht om welstandaviezen aan te maken (T of F).

 

 

dlcomgwelstanddel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning recht om welstandaviezen te verwijderen (T of F).

 

 

dlcomgwelstandedt

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning recht om welstandaviezen te muteren (T of F).

 

 

dlbomgverzledt

char(1)

 

 

 

'F'::bpchar

Niveau B omg vergunning Verzendlijst maken (T of F).

 

 

dlcomgbtcvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Bestemminsplannen toestingscriteria zichtbaar (T of F).

 

 

dlcomgbtcedt

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Bestemminsplannen toestingscriteria wijzigen (T of F).

 

 

dlcomgbtcins

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Bestemminsplannen toestingscriteria nieuw (T of F).

 

 

dlcomgbtcdel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Bestemminsplannen toestingscriteria verwijderen (T of F).

 

 

dlcomgbrwvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Brandweer (Preparaties en installaties) zichtbaar (T of F).

 

 

dlcomgbrwedt

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Brandweer (Preparaties en installaties) wijzigen (T of F).

 

 

dlcomgbrwins

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Brandweer (Preparaties en installaties) nieuw (T of F).

 

 

dlcomgbrwdel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Brandweer (Preparaties en installaties) verwijderen (T of F).

 

 

dlcomgolovsb

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning OloBerichten zichtbaar (T of F).

 

 

dlcomgoloedt

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning OloBerichten wijzigen (T of F).

 

 

dlcomgoloins

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning OloBerichten nieuw (T of F).

 

 

dlcomgolodel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning OloBerichten verwijderen (T of F).

 

 

dlbomggroepedt

char(1)

 

 

 

'F'::bpchar

Niveau B Omgevings vergunning. Groepvergunnig maken (T of F).

 

 

dlbomgverspr

char(1)

 

 

 

'F'::bpchar

Niveau B Omgevingss vergunning. Mag Complex verspreiden (T of F).

 

 

dlcomgtstbcc

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevingsvergunning. Toestemmingen. Mag brandweer cyclische controles maken (T of F).

 

 

dlcomgcordms

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgevingsvergunning. Correspondentie. DMS-kolom muteerbaar

 

 

dlcomgcorodt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlbomgsnelins

char(1)

 

 

 

'T'::bpchar

Niveau B. Omgevingsvergunning. Mag externe zaaknummers wijzigen (olonummer, dvdmszaakcode, dvintzaakcode en dvzaaknrbevgezag).T of F

 

 

dlcomginsdms

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgevingsvergunning. Inspecties. Mag externe inspecties-zaaknummers wijzigen: dvdmszaakcode, dvintzaakcode (T of F).

 

 

dlcomgadvdms

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgevingsvergunning. Adviezen. Mag externe advies-zaaknummers wijzigen: dvdmszaakcode, dvintzaakcode (T of F).

 

 

dlbomgodedt

char(1)

 

 

 

'T'::bpchar

Niveau B. Omgevingsvergunning. Mag Wavezaaknummer (dvzaakcode) en ontvangstdatum en soortaak wijzigen (T of F).

 

 

dlbomghlink

char(1)

 

 

 

'F'::bpchar

Niveau B. Omgevingsverunning. Mag hyperlink starten vanuit powerportal omgevingdetail.

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

cfk_tbomgrechten_keyrechten

dnkeyrechten

public.tbrechten

dnkey

Cascade

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

chk_omgrecht_dlbomgblok

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

 

chk_omgrecht_dlbomgdel

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

 

chk_omgrecht_dlbomgedt

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

 

chk_omgrecht_dlbomgins

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

 

chk_omgrecht_dlbomgmmedt

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

 

chk_omgrecht_dlbomgmmvsb

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

 

chk_omgrecht_dlbomgverzledt

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

 

chk_omgrecht_dlbomgvpl

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

 

chk_omgrecht_dlcomgavdel

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

 

chk_omgrecht_dlcomgavdet

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

 

chk_omgrecht_dlcomgavedt

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

 

chk_omgrecht_dlcomgaviet

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

 

chk_omgrecht_dlcomgavins

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

 

chk_omgrecht_dlcomgavvsb

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

 

chk_omgrecht_dlcomgbtcdel

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

 

chk_omgrecht_dlcomgbtcedt

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

 

chk_omgrecht_dlcomgbtcins

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

 

chk_omgrecht_dlcomgbtcvsb

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

 

chk_omgrecht_dlcomgcddel

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

 

chk_omgrecht_dlcomgcdins

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

 

chk_omgrecht_dlcomgcdvsb

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

 

chk_omgrecht_dlcomgcndel

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

 

chk_omgrecht_dlcomgcnedt

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

 

chk_omgrecht_dlcomgcnins

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

 

chk_omgrecht_dlcomgcnvsb

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

 

chk_omgrecht_dlcomgcrdel

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

 

chk_omgrecht_dlcomgcredt

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

 

chk_omgrecht_dlcomgcrins

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

 

chk_omgrecht_dlcomgcrvsb

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

 

chk_omgrecht_dlcomgibedt

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

 

chk_omgrecht_dlcomgibins

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

 

chk_omgrecht_dlcomgibvsb

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

 

chk_omgrecht_dlcomginsdel

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

 

chk_omgrecht_dlcomginsedt

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

 

chk_omgrecht_dlcomginsins

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

 

chk_omgrecht_dlcomginsvsb

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

 

chk_omgrecht_dlcomglegexpnot

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

 

chk_omgrecht_dlcomglgdel

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

 

chk_omgrecht_dlcomglgedt

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

 

chk_omgrecht_dlcomglgins

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

 

chk_omgrecht_dlcomglgvsb

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

 

chk_omgrecht_dlcomgolodel

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

 

chk_omgrecht_dlcomgoloedt

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

 

chk_omgrecht_dlcomgoloins

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

 

chk_omgrecht_dlcomgolovsb

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

 

chk_omgrecht_dlcomgpoahn

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

 

chk_omgrecht_dlcomgpodel

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

 

chk_omgrecht_dlcomgpoedt

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

 

chk_omgrecht_dlcomgpoins

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

 

chk_omgrecht_dlcomgpovdg

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

 

chk_omgrecht_dlcomgpovsb

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

 

chk_omgrecht_dlcomgtsdel

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

 

chk_omgrecht_dlcomgtsedt

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

 

chk_omgrecht_dlcomgtsins

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

 

chk_omgrecht_dlcomgtsvsb

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

 

chk_omgrecht_dlcomgwelstanddel

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

 

chk_omgrecht_dlcomgwelstandedt

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

 

chk_omgrecht_dlcomgwelstandins

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

 

chk_omgrecht_dlcomgwelstandvsb

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

 

chk_omgrechten_dlbomggroepedt

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

 

chk_omgrechten_dlbomgsnelins

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

 

chk_omgrechten_dlbomgverspr

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

 

chk_omgrechten_dlcomgbrwdel

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

 

chk_omgrechten_dlcomgbrwedt

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

 

chk_omgrechten_dlcomgbrwins

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

 

chk_omgrechten_dlcomgbrwvsb

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

 

chk_omgrechten_dlcomgcordms

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

 

chk_omgrechten_dlcomgcorodt

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

 

chk_omgrechten_dlcomgtstbcc

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

 

chk_tbomgrechten_dlbomghlink

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

 

chk_tbomgrechten_dlbomgodedt

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

 

chk_tbomgrechten_dlcomgadvdms

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

 

chk_tbomgrechten_dlcomginsdms

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

 

cnn_omgrecht_keyrechten

dnkeyrechten IS NOT NULL

 

cnn_omgrechten_dlbomggroepedt

dlbomggroepedt IS NOT NULL

 

cnn_omgrechten_dlbomgsnelins

dlbomgsnelins IS NOT NULL

 

cnn_omgrechten_dlbomgverspr

dlbomgverspr IS NOT NULL

 

cnn_omgrechten_dlcomgcordms

dlcomgcordms IS NOT NULL

 

cnn_omgrechten_dlcomgcorodt

dlcomgcorodt IS NOT NULL

 

cnn_omgrechten_dlcomgtstbcc

dlcomgtstbcc IS NOT NULL

 

cnn_tbomgrechten_dlbomghlink

dlbomghlink IS NOT NULL

 

cnn_tbomgrechten_dlbomgodedt

dlbomgodedt IS NOT NULL

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbomgrechten

btree

 

dnkey

 

idu_omgrechten_keyrechten

btree

 

dnkeyrechten

 

 

 

Triggers

There are no triggers for table tbomgrechten

 

Rules

There are no rules for table tbomgrechten

 

Referenced

There are no tables referenced by table tbomgrechten

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.tbomgrechten (
 dnkey SERIAL,
 dnkeyrechten INTEGER,
 dlbomgedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgins CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgverplaats CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgblokkedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgmemovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgmemoedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomginsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomginsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomginsins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomginsdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcoredt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcordel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcadvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcadins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcaddel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgadvvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgadvedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgadvins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgadvdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcinvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcinins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcindel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgibbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgibbedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgibbins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgprovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgproedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgproins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgprodel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgproahn CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgprovdg CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgadvdatedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgadvinedt CHAR(1) DEFAULT 'T'::bpchar,
 dlcomgtstvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgtstedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgtstins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgtstdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomglegvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomglegedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomglegins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomglegdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomglegexpnot CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgwelstandvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgwelstandins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgwelstanddel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgwelstandedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgverzledt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbtcvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbtcedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbtcins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbtcdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbrwvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbrwedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbrwins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbrwdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgolovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgoloedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgoloins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgolodel CHAR(1) DEFAULT 'F'::bpchar,
 dlbomggroepedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgverspr CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgtstbcc CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcordms CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorodt CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgsnelins CHAR(1) DEFAULT 'T'::bpchar,
 dlcomginsdms CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgadvdms CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgodedt CHAR(1) DEFAULT 'T'::bpchar,
 dlbomghlink CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tbomgrechten PRIMARY KEY(dnkey),
 CONSTRAINT chk_omgrecht_dlbomgblok CHECK (dlbomgblokkedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgdel CHECK (dlbomgdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgedt CHECK (dlbomgedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgins CHECK (dlbomgins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgmmedt CHECK (dlbomgmemoedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgmmvsb CHECK (dlbomgmemovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgverzledt CHECK (dlbomgverzledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgvpl CHECK (dlbomgverplaats = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgavdel CHECK (dlcomgadvdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgavdet CHECK (dlcomgadvdatedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgavedt CHECK (dlcomgadvedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgaviet CHECK (dlcomgadvinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgavins CHECK (dlcomgadvins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgavvsb CHECK (dlcomgadvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgbtcdel CHECK (dlcomgbtcdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgbtcedt CHECK (dlcomgbtcedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgbtcins CHECK (dlcomgbtcins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgbtcvsb CHECK (dlcomgbtcvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcddel CHECK (dlcomgcaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcdins CHECK (dlcomgcadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcdvsb CHECK (dlcomgcadvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcndel CHECK (dlcomgcindel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcnedt CHECK (dlcomgcinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcnins CHECK (dlcomgcinins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcnvsb CHECK (dlcomgcinvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcrdel CHECK (dlcomgcordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcredt CHECK (dlcomgcoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcrins CHECK (dlcomgcorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcrvsb CHECK (dlcomgcorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgibedt CHECK (dlcomgibbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgibins CHECK (dlcomgibbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgibvsb CHECK (dlcomgibbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomginsdel CHECK (dlcomginsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomginsedt CHECK (dlcomginsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomginsins CHECK (dlcomginsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomginsvsb CHECK (dlcomginsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomglegexpnot CHECK (dlcomglegexpnot = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomglgdel CHECK (dlcomglegdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomglgedt CHECK (dlcomglegedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomglgins CHECK (dlcomglegins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomglgvsb CHECK (dlcomglegvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgolodel CHECK (dlcomgolodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgoloedt CHECK (dlcomgoloedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgoloins CHECK (dlcomgoloins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgolovsb CHECK (dlcomgolovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgpoahn CHECK (dlcomgproahn = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgpodel CHECK (dlcomgprodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgpoedt CHECK (dlcomgproedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgpoins CHECK (dlcomgproins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgpovdg CHECK (dlcomgprovdg = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgpovsb CHECK (dlcomgprovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgtsdel CHECK (dlcomgtstdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgtsedt CHECK (dlcomgtstedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgtsins CHECK (dlcomgtstins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgtsvsb CHECK (dlcomgtstvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgwelstanddel CHECK (dlcomgwelstanddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgwelstandedt CHECK (dlcomgwelstandedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgwelstandins CHECK (dlcomgwelstandins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgwelstandvsb CHECK (dlcomgwelstandvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlbomggroepedt CHECK (dlbomggroepedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlbomgsnelins CHECK (dlbomgsnelins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlbomgverspr CHECK (dlbomgverspr = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbrwdel CHECK (dlcomgbrwdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbrwedt CHECK (dlcomgbrwedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbrwins CHECK (dlcomgbrwins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbrwvsb CHECK (dlcomgbrwvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgcordms CHECK (dlcomgcordms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgcorodt CHECK (dlcomgcorodt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgtstbcc CHECK (dlcomgtstbcc = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlbomghlink CHECK (dlbomghlink = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlbomgodedt CHECK (dlbomgodedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlcomgadvdms CHECK (dlcomgadvdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbomgrechten_dlcomginsdms CHECK (dlcomginsdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT cnn_omgrecht_keyrechten CHECK (dnkeyrechten IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlbomggroepedt CHECK (dlbomggroepedt IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlbomgsnelins CHECK (dlbomgsnelins IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlbomgverspr CHECK (dlbomgverspr IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgcordms CHECK (dlcomgcordms IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgcorodt CHECK (dlcomgcorodt IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgtstbcc CHECK (dlcomgtstbcc IS NOT NULL),
 CONSTRAINT cnn_tbomgrechten_dlbomghlink CHECK (dlbomghlink IS NOT NULL),
 CONSTRAINT cnn_tbomgrechten_dlbomgodedt CHECK (dlbomgodedt IS NOT NULL),
 CONSTRAINT cfk_tbomgrechten_keyrechten FOREIGN KEY (dnkeyrechten)
   REFERENCES public.tbrechten(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
)
WITH (oids = false);

COMMENT ON TABLE public.tbomgrechten
IS 'Rechtentabel voor de module omgevingsvergunning';

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

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

COMMENT ON COLUMN public.tbomgrechten.dlbomgedt
IS 'Niveau B Omgevings vergunning Wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgins
IS 'Niveau B Omgevings vergunning Nieuwrecht (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgdel
IS 'Niveau B Omgevings vergunning Verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgverplaats
IS 'Niveau B Omgevingsvergunning Verplaatsrecht.';

COMMENT ON COLUMN public.tbomgrechten.dlbomgblokkedt
IS 'Niveau B Omgevings vergunning Blokkeerrecht (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgmemovsb
IS 'Niveau B Omgevings vergunning Memo zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgmemoedt
IS 'Niveau B. Omgevings vergunning. Memo wijzigen.';

COMMENT ON COLUMN public.tbomgrechten.dlcomginsvsb
IS 'Niveau C Omgevings vergunning Inspecties zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomginsedt
IS 'Niveau C Omgevings vergunning Inspecties wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomginsins
IS 'Niveau C Omgevings vergunning Inspecties nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomginsdel
IS 'Niveau C Omgevings vergunning Inspecties verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorvsb
IS 'Niveau C Omgevings vergunning correspondentie zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcoredt
IS 'Niveau C Omgevings vergunning correspondentie wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorins
IS 'Niveau C Omgevings vergunning correspondentie nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcordel
IS 'Niveau C Omgevings vergunning correspondentie verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcadvsb
IS 'Niveau C Omgevings vergunning contactadressen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcadins
IS 'Niveau C Omgevings vergunning contactadressen koppeling maken (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcaddel
IS 'Niveau C Omgevings vergunning contactadressen koppeling verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgadvvsb
IS 'Niveau C Omgevings vergunning adviezen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgadvedt
IS 'Niveau C Omgevings vergunning adviezen wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgadvins
IS 'Niveau C Milieu vergunning Adviezen nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgadvdel
IS 'Niveau C Omgevings vergunning adviezen verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcinvsb
IS 'Niveau C Omgevings vergunning Correspondentie Binnen Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcinedt
IS 'Niveau C Omgevings vergunning Correspondentie Binnen Wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcinins
IS 'Niveau C Omgevings vergunning Correspondentie Binnen Nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcindel
IS 'Niveau C Omgevings vergunning Correspondentie Binnen Verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgibbvsb
IS 'Niveau C Omgevings vergunning in behandeling bij zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgibbedt
IS 'Niveau C Omgevings vergunning in behandeling bij wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgibbins
IS 'Niveau C Omgevings vergunning in behandeling bij nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgprovsb
IS 'Niveau C Omgevings vergunning Procedures zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgproedt
IS 'Niveau C Omgevings vergunning Procedures zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgproins
IS 'Niveau C Omgevings vergunning Procedures nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgprodel
IS 'Niveau C Omgevings vergunning procedures verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgproahn
IS 'Niveau C Omgevings vergunning procedures aanhouden en termijn van orde (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgprovdg
IS 'Niveau C Omgevings vergunning procedures verdagen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgadvdatedt
IS 'Niveau C. Adviezen. Wijzigrecht kolom DdDateringadvies van tabel TbAdviezen bij Omgevings vergunning (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgadvinedt
IS 'Niveau C. Omgevings vergunning Adviesinstantie wijzigbaar bij adviezen.';

COMMENT ON COLUMN public.tbomgrechten.dlcomgtstvsb
IS 'Niveau C Omgevings vergunning Toestemmingen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgtstedt
IS 'Niveau C Omgevings vergunning Toestemmingen wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgtstins
IS 'Niveau C Omgevings vergunning Toestemmingen nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgtstdel
IS 'Niveau C Omgevings vergunning toestemmingen verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomglegvsb
IS 'Niveau C Omgevings vergunning leges zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomglegedt
IS 'Niveau C Omgevings vergunning leges wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomglegins
IS 'Niveau C Omgevings vergunning leges nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomglegdel
IS 'Niveau C Omgevings vergunning leges verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomglegexpnot
IS 'Niveau C Omgevings vergunning recht om exportdatum leges te wijzigen n (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgwelstandvsb
IS 'Niveau C Omgevings vergunning recht om welstandaviezen in te zien (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgwelstandins
IS 'Niveau C Omgevings vergunning recht om welstandaviezen aan te maken (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgwelstanddel
IS 'Niveau C Omgevings vergunning recht om welstandaviezen te verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgwelstandedt
IS 'Niveau C Omgevings vergunning recht om welstandaviezen te muteren (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgverzledt
IS 'Niveau B omg vergunning Verzendlijst maken (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbtcvsb
IS 'Niveau C Omgevings vergunning Bestemminsplannen toestingscriteria zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbtcedt
IS 'Niveau C Omgevings vergunning Bestemminsplannen toestingscriteria wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbtcins
IS 'Niveau C Omgevings vergunning Bestemminsplannen toestingscriteria nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbtcdel
IS 'Niveau C Omgevings vergunning Bestemminsplannen toestingscriteria verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbrwvsb
IS 'Niveau C Omgevings vergunning Brandweer (Preparaties en installaties) zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbrwedt
IS 'Niveau C Omgevings vergunning Brandweer (Preparaties en installaties) wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbrwins
IS 'Niveau C Omgevings vergunning Brandweer (Preparaties en installaties) nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbrwdel
IS 'Niveau C Omgevings vergunning Brandweer (Preparaties en installaties) verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgolovsb
IS 'Niveau C Omgevings vergunning OloBerichten zichtbaar (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgoloedt
IS 'Niveau C Omgevings vergunning OloBerichten wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgoloins
IS 'Niveau C Omgevings vergunning OloBerichten nieuw (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgolodel
IS 'Niveau C Omgevings vergunning OloBerichten verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomggroepedt
IS 'Niveau B Omgevings vergunning. Groepvergunnig maken  (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlbomgverspr
IS 'Niveau B Omgevingss vergunning. Mag Complex verspreiden (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgtstbcc
IS 'Niveau C Omgevingsvergunning. Toestemmingen. Mag brandweer cyclische controles maken (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcordms
IS 'Niveau C. Omgevingsvergunning. Correspondentie. DMS-kolom muteerbaar';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorodt
IS 'Niveau C. Omgevingsvergunning. Correspondentie. Opgeslagen document-kolom muteerbaar.';

COMMENT ON COLUMN public.tbomgrechten.dlbomgsnelins
IS 'Niveau B. Omgevingsvergunning. Mag externe zaaknummers wijzigen (olonummer, dvdmszaakcode, dvintzaakcode en dvzaaknrbevgezag).T of F';

COMMENT ON COLUMN public.tbomgrechten.dlcomginsdms
IS 'Niveau C. Omgevingsvergunning. Inspecties. Mag externe inspecties-zaaknummers wijzigen:  dvdmszaakcode, dvintzaakcode  (T of F). ';

COMMENT ON COLUMN public.tbomgrechten.dlcomgadvdms
IS 'Niveau C. Omgevingsvergunning. Adviezen. Mag externe advies-zaaknummers wijzigen:  dvdmszaakcode, dvintzaakcode  (T of F). ';

COMMENT ON COLUMN public.tbomgrechten.dlbomgodedt
IS 'Niveau B. Omgevingsvergunning. Mag Wavezaaknummer (dvzaakcode) en ontvangstdatum  en soortaak wijzigen (T of F). ';

COMMENT ON COLUMN public.tbomgrechten.dlbomghlink
IS 'Niveau B. Omgevingsverunning. Mag hyperlink starten vanuit powerportal omgevingdetail.';

CREATE UNIQUE INDEX idu_omgrechten_keyrechten ON public.tbomgrechten
 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