Datadictionary OpenWave 3.1.25
 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 Omgevingsvergunning Inspecties verwijderrecht (trajecten, overtredingen en bezoeken) (T of F).

 

 

dlcomgcorvsb

char(1)

 

 

 

'T'::bpchar

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

 

 

dlcomgcoredt

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Registreren van doucmenten en geregistreerde correspondentie wijzigen metadata(T of F).

 

 

dlcomgcorins

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning correspondentie creeren en uploaden document (T of F).

 

 

dlcomgcordel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning correspondentie geregisteerde correspondentie verwijderen metadata (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, 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 ontvangstdatum wijzigen (T of F).

 

 

dlbomghlink

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcomgbezwvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgevingsverunning. Bezwaar/beroep inzien (T of F)

 

 

dlcomgbezwedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgevingsverunning. Bezwaar/beroep wijzgen (T of F)

 

 

dlcomgbezwins

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgevingsverunning. Bezwaar/beroep insert (T of F)

 

 

dlcomgbezwdel

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgevingsverunning. Bezwaar/beroep delete (T of F)

 

 

dlcomgbezwdms

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgevingsverunning. Bezwaar/beroep. dmscode (extern zaakidentificatie) muteren (T of F).

 

 

dlcomgzkpins

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgevingsverunning. Kadastrale percelen insert (T of F)

 

 

dlcomgzkpvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgevingsverunning. Kadastrale percelen zichtbaar (T of F)

 

 

dlcomgzkpedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgevingsverunning. Kadastrale percelen wijzigen (T of F)

 

 

dlcomgzkpdel

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgevingsverunning. Kadastrale percelen delete (T of F)

 

 

dlcomguurvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgeving... uren inzien (T of F)

 

 

dlcomguurins

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgeving... uren insert (T of F)

 

 

dlcomguurdel

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgeving... uren delete (T of F)

 

 

dlcomguuredt

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgeving... uren wijzgen (T of F)

 

 

dlcomginsuurvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. inspecties bij Omgeving... uren inzien (T of F), edit- insert- delrechten via dlcomguuredt, dlcomguurins,dlcomguurdel

 

 

dlcomgbezwuurvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. bezwaar/beroep bij Omgeving... uren inzien (T of F), edit- insert- delrechten via dlcomguuredt, dlcomguurins,dlcomguurdel

 

 

dlcomgadvuurvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. adviezen bij Omgeving... uren inzien (T of F), edit- insert- delrechten via dlcomguuredt, dlcomguurins,dlcomguurdel

 

 

dlbomgafsedt

char(1)

 

 

 

'F'::bpchar

Niveau B Omgeving gevulde afhandeldatum wijzgen en dit geldt ook voor gevulde externe zaak einddatum (dddmsafgehandeld) bij deelzaken advies, inspecties en bezwaarberoep die aan Omgeving zijn gekoppeld(T of F)

 

 

dlcomgbguiins

char(1)

 

 

 

'F'::bpchar

Niveau C Omgeving Insert historie bevoegd gezag/uitv inst (T of F)

 

 

dlcomgbguiedt

char(1)

 

 

 

'F'::bpchar

Niveau C Omgeving wjzigen historie bevoegd gezag/uitv inst (T of F)

 

 

dlcomgbguidel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgeving delete historie bevoegd gezag/uitv inst (T of F)

 

 

dlcomgbguivsb

char(1)

 

 

 

'F'::bpchar

Niveau C Omgeving zichtbaar historie bevoegd gezag/uitv inst (T of F)

 

 

dlcomgcorregvsb

char(1)

 

 

 

'T'::bpchar

Niveau C Omgeving Geregistreerde documenten zichtbaar (T of F) Default T

 

 

dlcomgcorregdwl

char(1)

 

 

 

'F'::bpchar

Niveau C Omgeving Geregistreerde documenten Mag geforceerd downloaden (T of F) Default F

 

 

dlcomgcordocdel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgeving geregisteerde correspondentie verwijderen fysiek document(T of F).

 

 

dlcomgcorwmo

char(1)

 

 

 

'F'::bpchar

Niveau C Omgeving Wijzigen metadata (hernoemen filenaam) ongeregistreerde documenten (T of F)

 

 

dlcomgcorreghnm

char(1)

 

 

 

'F'::bpchar

Niveau C Omgeving Hernoemen geregistreerde documenten

 

 

dlcomgprdedt

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Product/Dienst wijzigen (T of F).

 

 

dlcomginsovbzdel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevingsvergunning Alleen inspectiebezoeken en overtredingen verwijderen (T of F).

 

 

dlcomgswfins

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgeving... mag samenwerkingsruimte aanmaken (ook in SWF)

 

 

dlcomgswfedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgeving... samenwerkingsruimte wijzgen (T of F)

 

 

dlcomgswfdel

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgeving... samenwerkingsruimte delete (T of F)

 

 

dlcomgswfvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgeving... samenwerkingsruimte inzien (T of F)

 

 

dlcomgswfafs

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgeving... mag samenwerkingsruimte afsluiten/verwijderen in SWF

 

 

dlcomgprdins

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevingsvergunning Product/Dienst toevoegen (T of F).

 

 

dlcomgprddel

char(1)

 

 

 

'F'::bpchar

Niveau C Omgevings vergunning Product/Dienst verwijderen (T of F).

 

 

dlbomgwznedt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlbomgztedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Omgevingsvergunning. Mag soort aanvraag wijzigen (T of F).

 

 

dlcomgcorregtent

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgeving... wijzigrecht (externe) tbcorrespondentie.dvexttracktrace

 

 

dlcomgzkphoofdedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Omgevingsvergunning. Mag hoofdprojectlocatie-indicatie wijzigen (T of F).

 

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_dlbomgafsedt

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

 

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_dlbomgwznedt

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

 

chk_omgrecht_dlbomgztedt

dlbomgztedt = ANY (ARRAY['F'::bpchar, 'T'::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_dlcomgbguidel

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

 

chk_omgrecht_dlcomgbguiedt

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

 

chk_omgrecht_dlcomgbguiins

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

 

chk_omgrecht_dlcomgbguivsb

dlcomgbguivsb = ANY (ARRAY['F'::bpchar, 'T'::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_dlcomgcordocdel

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

 

chk_omgrecht_dlcomgcorregdwl

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

 

chk_omgrecht_dlcomgcorregtent

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

 

chk_omgrecht_dlcomgcorregvsb

dlcomgcorregvsb = ANY (ARRAY['F'::bpchar, 'T'::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_dlcomginsovbzdel

dlcomginsovbzdel = ANY (ARRAY['F'::bpchar, 'T'::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_dlcomgprddel

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

 

chk_omgrecht_dlcomgprdedt

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

 

chk_omgrecht_dlcomgprdins

dlcomgprdins = ANY (ARRAY['F'::bpchar, 'T'::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_omgrecht_dlcomgzkpdel

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

 

chk_omgrecht_dlcomgzkpedt

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

 

chk_omgrecht_dlcomgzkphoofdedt

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

 

chk_omgrecht_dlcomgzkpins

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

 

chk_omgrecht_dlcomgzkpvsb

dlcomgzkpvsb = ANY (ARRAY['F'::bpchar, 'T'::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_dlcomgbezwdel

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

 

chk_omgrechten_dlcomgbezwdms

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

 

chk_omgrechten_dlcomgbezwedt

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

 

chk_omgrechten_dlcomgbezwins

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

 

chk_omgrechten_dlcomgbezwvsb

dlcomgbezwvsb = ANY (ARRAY['F'::bpchar, 'T'::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_dlcomgcorreghnm

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

 

chk_omgrechten_dlcomgcorwmo

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

 

chk_omgrechten_dlcomgswfafs

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

 

chk_omgrechten_dlcomgswfdel

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

 

chk_omgrechten_dlcomgswfedt

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

 

chk_omgrechten_dlcomgswfins

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

 

chk_omgrechten_dlcomgswfvsb

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

 

chk_omgrechten_dlcomgtstbcc

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

 

chk_omrechten_dlcomgadvuurvsb

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

 

chk_omrechten_dlcomgbezwuurvsb

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

 

chk_omrechten_dlcomginsuurvsb

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

 

chk_omrechten_dlcomguurdel

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

 

chk_omrechten_dlcomguuredt

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

 

chk_omrechten_dlcomguurins

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

 

chk_omrechten_dlcomguurvsb

dlcomguurvsb = ANY (ARRAY['F'::bpchar, 'T'::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_dlbomgafsedt

dlbomgafsedt IS NOT NULL

 

cnn_omgrecht_dlbomgwznedt

dlbomgwznedt IS NOT NULL

 

cnn_omgrecht_dlbomgztedt

dlbomgztedt IS NOT NULL

 

cnn_omgrecht_dlcomgbguidel

dlcomgbguidel IS NOT NULL

 

cnn_omgrecht_dlcomgbguiedt

dlcomgbguiedt IS NOT NULL

 

cnn_omgrecht_dlcomgbguiins

dlcomgbguiins IS NOT NULL

 

cnn_omgrecht_dlcomgbguivsb

dlcomgbguivsb IS NOT NULL

 

cnn_omgrecht_dlcomgcordocdel

dlcomgcordocdel IS NOT NULL

 

cnn_omgrecht_dlcomgcorregdwl

dlcomgcorregdwl IS NOT NULL

 

cnn_omgrecht_dlcomgcorregtent

dlcomgcorregtent IS NOT NULL

 

cnn_omgrecht_dlcomgcorregvsb

dlcomgcorregvsb IS NOT NULL

 

cnn_omgrecht_dlcomgprddel

dlcomgprddel IS NOT NULL

 

cnn_omgrecht_dlcomgprdedt

dlcomgprdedt IS NOT NULL

 

cnn_omgrecht_dlcomgprdins

dlcomgprdins IS NOT NULL

 

cnn_omgrecht_dlcomgzkpdel

dlcomgzkpdel IS NOT NULL

 

cnn_omgrecht_dlcomgzkpedt

dlcomgzkpedt IS NOT NULL

 

cnn_omgrecht_dlcomgzkphoofdedt

dlcomgzkphoofdedt IS NOT NULL

 

cnn_omgrecht_dlcomgzkpins

dlcomgzkpins IS NOT NULL

 

cnn_omgrecht_dlcomgzkpvsb

dlcomgzkpvsb IS NOT NULL

 

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_dlcomgbezwdel

dlcomgbezwdel IS NOT NULL

 

cnn_omgrechten_dlcomgbezwdms

dlcomgbezwdms IS NOT NULL

 

cnn_omgrechten_dlcomgbezwedt

dlcomgbezwedt IS NOT NULL

 

cnn_omgrechten_dlcomgbezwins

dlcomgbezwins IS NOT NULL

 

cnn_omgrechten_dlcomgbezwvsb

dlcomgbezwvsb IS NOT NULL

 

cnn_omgrechten_dlcomgcordms

dlcomgcordms IS NOT NULL

 

cnn_omgrechten_dlcomgcorodt

dlcomgcorodt IS NOT NULL

 

cnn_omgrechten_dlcomgcorreghnm

dlcomgcorreghnm IS NOT NULL

 

cnn_omgrechten_dlcomgcorwmo

dlcomgcorwmo IS NOT NULL

 

cnn_omgrechten_dlcomginsovbzdel

dlcomginsovbzdel IS NOT NULL

 

cnn_omgrechten_dlcomgswfafs

dlcomgswfafs IS NOT NULL

 

cnn_omgrechten_dlcomgswfdel

dlcomgswfdel IS NOT NULL

 

cnn_omgrechten_dlcomgswfedt

dlcomgswfedt IS NOT NULL

 

cnn_omgrechten_dlcomgswfins

dlcomgswfins IS NOT NULL

 

cnn_omgrechten_dlcomgswfvsb

dlcomgswfvsb IS NOT NULL

 

cnn_omgrechten_dlcomgtstbcc

dlcomgtstbcc IS NOT NULL

 

cnn_omrechten_dlcomgadvuurvsb

dlcomgadvuurvsb IS NOT NULL

 

cnn_omrechten_dlcomgbezwuurvsb

dlcomgbezwuurvsb IS NOT NULL

 

cnn_omrechten_dlcomginsuurvsb

dlcomginsuurvsb IS NOT NULL

 

cnn_omrechten_dlcomguurdel

dlcomguurdel IS NOT NULL

 

cnn_omrechten_dlcomguuredt

dlcomguuredt IS NOT NULL

 

cnn_omrechten_dlcomguurins

dlcomguurins IS NOT NULL

 

cnn_omrechten_dlcomguurvsb

dlcomguurvsb 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

 

Policies

There are no policies 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 'T'::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,
 dlcomgbezwvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbezwedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbezwins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbezwdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbezwdms CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgzkpins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgzkpvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgzkpedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgzkpdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomguurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomguurins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomguurdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomguuredt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomginsuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbezwuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgadvuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgafsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbguiins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbguiedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbguidel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgbguivsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorregvsb CHAR(1) DEFAULT 'T'::bpchar,
 dlcomgcorregdwl CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcordocdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorwmo CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorreghnm CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgprdedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomginsovbzdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgswfins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgswfedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgswfdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgswfvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgswfafs CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgprdins CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgprddel CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgwznedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbomgztedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgcorregtent CHAR(1) DEFAULT 'F'::bpchar,
 dlcomgzkphoofdedt CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tbomgrechten PRIMARY KEY(dnkey),
 CONSTRAINT chk_omgrecht_dlbomgafsedt CHECK (dlbomgafsedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 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_dlbomgwznedt CHECK (dlbomgwznedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlbomgztedt CHECK (dlbomgztedt = ANY (ARRAY['F'::bpchar, 'T'::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_dlcomgbguidel CHECK (dlcomgbguidel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgbguiedt CHECK (dlcomgbguiedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgbguiins CHECK (dlcomgbguiins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgbguivsb CHECK (dlcomgbguivsb = ANY (ARRAY['F'::bpchar, 'T'::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_dlcomgcordocdel CHECK (dlcomgcordocdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcorregdwl CHECK (dlcomgcorregdwl = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcorregtent CHECK (dlcomgcorregtent = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgcorregvsb CHECK (dlcomgcorregvsb = ANY (ARRAY['F'::bpchar, 'T'::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_dlcomginsovbzdel CHECK (dlcomginsovbzdel = ANY (ARRAY['F'::bpchar, 'T'::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_dlcomgprddel CHECK (dlcomgprddel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgprdedt CHECK (dlcomgprdedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgprdins CHECK (dlcomgprdins = ANY (ARRAY['F'::bpchar, 'T'::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_omgrecht_dlcomgzkpdel CHECK (dlcomgzkpdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgzkpedt CHECK (dlcomgzkpedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgzkphoofdedt CHECK (dlcomgzkphoofdedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgzkpins CHECK (dlcomgzkpins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrecht_dlcomgzkpvsb CHECK (dlcomgzkpvsb = ANY (ARRAY['F'::bpchar, 'T'::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_dlcomgbezwdel CHECK (dlcomgbezwdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbezwdms CHECK (dlcomgbezwdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbezwedt CHECK (dlcomgbezwedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbezwins CHECK (dlcomgbezwins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgbezwvsb CHECK (dlcomgbezwvsb = ANY (ARRAY['F'::bpchar, 'T'::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_dlcomgcorreghnm CHECK (dlcomgcorreghnm = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgcorwmo CHECK (dlcomgcorwmo = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgswfafs CHECK (dlcomgswfafs = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgswfdel CHECK (dlcomgswfdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgswfedt CHECK (dlcomgswfedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgswfins CHECK (dlcomgswfins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgswfvsb CHECK (dlcomgswfvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omgrechten_dlcomgtstbcc CHECK (dlcomgtstbcc = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_omrechten_dlcomgadvuurvsb CHECK (dlcomgadvuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omrechten_dlcomgbezwuurvsb CHECK (dlcomgbezwuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omrechten_dlcomginsuurvsb CHECK (dlcomginsuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omrechten_dlcomguurdel CHECK (dlcomguurdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omrechten_dlcomguuredt CHECK (dlcomguuredt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omrechten_dlcomguurins CHECK (dlcomguurins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_omrechten_dlcomguurvsb CHECK (dlcomguurvsb = ANY (ARRAY['F'::bpchar, 'T'::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_dlbomgafsedt CHECK (dlbomgafsedt IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlbomgwznedt CHECK (dlbomgwznedt IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlbomgztedt CHECK (dlbomgztedt IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgbguidel CHECK (dlcomgbguidel IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgbguiedt CHECK (dlcomgbguiedt IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgbguiins CHECK (dlcomgbguiins IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgbguivsb CHECK (dlcomgbguivsb IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgcordocdel CHECK (dlcomgcordocdel IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgcorregdwl CHECK (dlcomgcorregdwl IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgcorregtent CHECK (dlcomgcorregtent IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgcorregvsb CHECK (dlcomgcorregvsb IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgprddel CHECK (dlcomgprddel IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgprdedt CHECK (dlcomgprdedt IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgprdins CHECK (dlcomgprdins IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgzkpdel CHECK (dlcomgzkpdel IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgzkpedt CHECK (dlcomgzkpedt IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgzkphoofdedt CHECK (dlcomgzkphoofdedt IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgzkpins CHECK (dlcomgzkpins IS NOT NULL),
 CONSTRAINT cnn_omgrecht_dlcomgzkpvsb CHECK (dlcomgzkpvsb IS NOT NULL),
 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_dlcomgbezwdel CHECK (dlcomgbezwdel IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgbezwdms CHECK (dlcomgbezwdms IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgbezwedt CHECK (dlcomgbezwedt IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgbezwins CHECK (dlcomgbezwins IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgbezwvsb CHECK (dlcomgbezwvsb IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgcordms CHECK (dlcomgcordms IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgcorodt CHECK (dlcomgcorodt IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgcorreghnm CHECK (dlcomgcorreghnm IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgcorwmo CHECK (dlcomgcorwmo IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomginsovbzdel CHECK (dlcomginsovbzdel IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgswfafs CHECK (dlcomgswfafs IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgswfdel CHECK (dlcomgswfdel IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgswfedt CHECK (dlcomgswfedt IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgswfins CHECK (dlcomgswfins IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgswfvsb CHECK (dlcomgswfvsb IS NOT NULL),
 CONSTRAINT cnn_omgrechten_dlcomgtstbcc CHECK (dlcomgtstbcc IS NOT NULL),
 CONSTRAINT cnn_omrechten_dlcomgadvuurvsb CHECK (dlcomgadvuurvsb IS NOT NULL),
 CONSTRAINT cnn_omrechten_dlcomgbezwuurvsb CHECK (dlcomgbezwuurvsb IS NOT NULL),
 CONSTRAINT cnn_omrechten_dlcomginsuurvsb CHECK (dlcomginsuurvsb IS NOT NULL),
 CONSTRAINT cnn_omrechten_dlcomguurdel CHECK (dlcomguurdel IS NOT NULL),
 CONSTRAINT cnn_omrechten_dlcomguuredt CHECK (dlcomguuredt IS NOT NULL),
 CONSTRAINT cnn_omrechten_dlcomguurins CHECK (dlcomguurins IS NOT NULL),
 CONSTRAINT cnn_omrechten_dlcomguurvsb CHECK (dlcomguurvsb 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
) ;

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 Omgevingsvergunning Inspecties verwijderrecht (trajecten, overtredingen en bezoeken) (T of F).';

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

COMMENT ON COLUMN public.tbomgrechten.dlcomgcoredt
IS 'Niveau C Omgevings vergunning Registreren van doucmenten en geregistreerde correspondentie wijzigen metadata(T of F).';

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

COMMENT ON COLUMN public.tbomgrechten.dlcomgcordel
IS 'Niveau C Omgevings vergunning correspondentie geregisteerde correspondentie verwijderen metadata (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, 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 ontvangstdatum wijzigen (T of F).';

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

COMMENT ON COLUMN public.tbomgrechten.dlcomgbezwvsb
IS 'Niveau C. Omgevingsverunning. Bezwaar/beroep inzien (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbezwedt
IS 'Niveau C. Omgevingsverunning. Bezwaar/beroep wijzgen (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbezwins
IS 'Niveau C. Omgevingsverunning. Bezwaar/beroep insert (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbezwdel
IS 'Niveau C. Omgevingsverunning. Bezwaar/beroep delete (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbezwdms
IS 'Niveau C. Omgevingsverunning. Bezwaar/beroep. dmscode (extern zaakidentificatie) muteren (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgzkpins
IS 'Niveau C. Omgevingsverunning. Kadastrale percelen insert (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgzkpvsb
IS 'Niveau C. Omgevingsverunning. Kadastrale percelen zichtbaar (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgzkpedt
IS 'Niveau C. Omgevingsverunning. Kadastrale percelen wijzigen (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgzkpdel
IS 'Niveau C. Omgevingsverunning. Kadastrale percelen delete (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomguurvsb
IS 'Niveau C. Omgeving... uren inzien (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomguurins
IS 'Niveau C. Omgeving... uren insert (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomguurdel
IS 'Niveau C. Omgeving... uren delete (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomguuredt
IS 'Niveau C. Omgeving... uren wijzgen (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomginsuurvsb
IS 'Niveau C. inspecties bij Omgeving... uren inzien (T of F), edit- insert- delrechten via dlcomguuredt, dlcomguurins,dlcomguurdel';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbezwuurvsb
IS 'Niveau C. bezwaar/beroep bij Omgeving... uren inzien (T of F), edit- insert- delrechten via dlcomguuredt, dlcomguurins,dlcomguurdel';

COMMENT ON COLUMN public.tbomgrechten.dlcomgadvuurvsb
IS 'Niveau C. adviezen bij Omgeving... uren inzien (T of F), edit- insert- delrechten via dlcomguuredt, dlcomguurins,dlcomguurdel';

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

COMMENT ON COLUMN public.tbomgrechten.dlcomgbguiins
IS 'Niveau C Omgeving Insert historie bevoegd gezag/uitv inst (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbguiedt
IS 'Niveau C Omgeving wjzigen historie bevoegd gezag/uitv inst (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbguidel
IS 'Niveau C Omgeving delete historie bevoegd gezag/uitv inst (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgbguivsb
IS 'Niveau C Omgeving zichtbaar historie bevoegd gezag/uitv inst (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorregvsb
IS 'Niveau C Omgeving Geregistreerde documenten zichtbaar (T of F) Default T';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorregdwl
IS 'Niveau C Omgeving Geregistreerde documenten Mag geforceerd downloaden (T of F) Default F';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcordocdel
IS 'Niveau C Omgeving geregisteerde correspondentie verwijderen fysiek document(T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorwmo
IS 'Niveau C Omgeving Wijzigen metadata (hernoemen filenaam) ongeregistreerde documenten (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorreghnm
IS 'Niveau C Omgeving Hernoemen geregistreerde documenten';

COMMENT ON COLUMN public.tbomgrechten.dlcomgprdedt
IS 'Niveau C Omgevings vergunning Product/Dienst wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomginsovbzdel
IS 'Niveau C Omgevingsvergunning Alleen inspectiebezoeken en overtredingen verwijderen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgswfins
IS 'Niveau C. Omgeving... mag samenwerkingsruimte aanmaken (ook in SWF)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgswfedt
IS 'Niveau C. Omgeving... samenwerkingsruimte wijzgen (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgswfdel
IS 'Niveau C. Omgeving... samenwerkingsruimte delete (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgswfvsb
IS 'Niveau C. Omgeving... samenwerkingsruimte inzien (T of F)';

COMMENT ON COLUMN public.tbomgrechten.dlcomgswfafs
IS 'Niveau C. Omgeving... mag samenwerkingsruimte afsluiten/verwijderen in SWF';

COMMENT ON COLUMN public.tbomgrechten.dlcomgprdins
IS 'Niveau C Omgevingsvergunning Product/Dienst toevoegen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgprddel
IS 'Niveau C Omgevings vergunning Product/Dienst verwijderen (T of F).';

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

COMMENT ON COLUMN public.tbomgrechten.dlbomgztedt
IS 'Niveau B. Omgevingsvergunning. Mag soort aanvraag wijzigen (T of F).';

COMMENT ON COLUMN public.tbomgrechten.dlcomgcorregtent
IS 'Niveau C. Omgeving... wijzigrecht (externe) tbcorrespondentie.dvexttracktrace';

COMMENT ON COLUMN public.tbomgrechten.dlcomgzkphoofdedt
IS 'Niveau C. Omgevingsvergunning. Mag hoofdprojectlocatie-indicatie wijzigen (T of F).';

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 5-1-2022 14:13
 Previous topic Chapter index Next topic