Datadictionary OpenWave 3.1.25
 Previous topic Chapter index Next topic

Table: tbmilvergrechten

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Rechtentabel voor de module inrichtingen (rechten op de milieu- en gebruiksvergunningen)

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbmilvergrechten_dnkey_seq'::regclass)

Primary.

 

dnkeyrechten

integer

 

 

 

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

 

 

dlbmilvergedt

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu vergunning Wijzigrecht (T of F).

 

 

dlbmilvergins

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu vergunning Nieuwrecht (T of F).

 

 

dlbmilvergdel

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu vergunning Verwijderrecht (T of F).

 

 

dlbmilvergblokkedt

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu vergunning Blokkeerrecht (T of F).

 

 

dlbmilverggroepedt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlbmilvergmemovsb

char(1)

 

 

 

'F'::bpchar

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

 

 

dlbmilvergkopie

char(1)

 

 

 

'F'::bpchar

Niveau B Milieu vergunning. Kopieerrecht.

 

 

dlbmilvergmemoedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Milieu vergunning. Memo wijzigen.

 

 

dlcmilvergwetvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Wetten zichtbaar (T of F).

 

 

dlcmilvergwetedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Wetten wijzigen (T of F).

 

 

dlcmilvergwetins

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergwetdel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Wetten verwijderen (T of F).

 

 

dlcmilvergcorvsb

char(1)

 

 

 

'T'::bpchar

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

 

 

dlcmilvergcoredt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergcorins

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergcordel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning correspondentie geregisteerde correspondentie verwijderen metadata (T of F).

 

 

dlcmilvergcadvsb

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergcadins

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergcaddel

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergadvvsb

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergadvedt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergadvins

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergadvdel

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergcinvsb

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergcinedt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergcinins

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergcindel

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergibbvsb

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergibbedt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergibbins

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergprovsb

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergproedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning Procedures wijzigen (T of F).

 

 

dlcmilvergproins

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergprodel

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergproahn

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt

 

 

dlcmilvergprovdg

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt

 

 

dlcmilvergadvdatedt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergadvinedt

char(1)

 

 

 

'T'::bpchar

Niveau C. Milieuvergunningen. Adviesinstantie wijzigbaar bij adviezen.

 

 

dlbmilvergverzledt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergbrwvsb

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergbrwedt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergbrwins

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergbrwdel

char(1)

 

 

 

'F'::bpchar

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

 

 

dlbmilvergbcc

char(1)

 

 

 

'F'::bpchar

 

 

 

dlcmilvergcordms

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieuvergunnningen. Correspondentie. DMS-kolom muteerbaar

 

 

dlcmilvergcorodt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlbmilvergsnelins

char(1)

 

 

 

'T'::bpchar

Niveau B. Milieuvergunningen. Mag externe zaakcode wijzigen.

 

 

dlcmilvergolovsb

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning oloberichten zichtbaar (T of F).

 

 

dlcmilvergoloedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning oloberichten wijzigen (T of F).

 

 

dlcmilvergoloins

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergolodel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu vergunning oloberichten verwijderen (T of F).

 

 

dlcmilvergadvdms

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieu vergunning. Adviezen. Dmscode muteren (T of F).

 

 

dlbmilvergodedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Milieu/gebruik. Mag ontvangsdatum wijzigen (T of F).

 

 

dlbmilverghlink

char(1)

 

 

 

'F'::bpchar

Niveau B. Milieu/gebruik. Mag hyperlink starten vanuit powerportal milieu/gebruikdetail.

 

 

dlbmilvergverplaats

char(1)

 

 

 

'F'::bpchar

Niveau B. Milieu/gebruik. Mag zaak verplaatsen naar ander locatieadres

 

 

dlcmilvergbezwvsb

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergbezwedt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergbezwins

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergbezwdel

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergbezwdms

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilverguurvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieu/gebruik... uren inzien (T of F)

 

 

dlcmilverguurins

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieu/gebruik... uren insert (T of F)

 

 

dlcmilverguurdel

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieu/gebruik... uren delete (T of F)

 

 

dlcmilverguuredt

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieu/gebruik... uren wijzgen (T of F)

 

 

dlcmilverginsuurvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. inspecties bij Milieu/gebruik... uren inzien (T of F), edit- insert- delrechten via dlcmilverguuredt, dlcmilverguurins,dlcmilverguurdel

 

 

dlcmilvergbezwuurvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. bezwaar/beroep bij Milieu/gebruik... uren inzien (T of F), edit- insert- delrechten via dlcmilverguuredt, dlcmilverguurins,dlcmilverguurdel

 

 

dlcmilvergadvuurvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. adviezen bij Milieu/gebruik... uren inzien (T of F), edit- insert- delrechten via dlcmilverguuredt, dlcmilverguurins,dlcmilverguurdel

 

 

dlbmilvergafsedt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergcorregvsb

char(1)

 

 

 

'T'::bpchar

Niveau C Milieu/Gebruik Geregistreerde documenten zichtbaar (T of F) Default T

 

 

dlcmilvergcorregdwl

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu/Gebruik Geregistreerde documenten Mag geforceerd downloaden (T of F) Default F

 

 

dlcmilvergcordocdel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu/Gebruik geregisteerde correspondentie verwijderen fysiek document(T of F).

 

 

dlcmilvergcorwmo

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu/Gebruik Wijzigen metadata (hernoemen filenaam) ongeregistreerde documenten (T of F)

 

 

dlcmilvergcorreghnm

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu/Gebruik Hernoemen geregistreerde documenten

 

 

dlcmilvergprdedt

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu/Gebruik Product/Dienst wijzigen (T of F).

 

 

dlcmilvergprdins

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcmilvergprddel

char(1)

 

 

 

'F'::bpchar

Niveau C Milieu/Gebruik Product/Dienst verwijderen (T of F).

 

 

dlbmilvergwznedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Milieu/gebruik. Mag Wavezaakcode (dvvergnummer) wijzigen (T of F).

 

 

dlbmilvergztedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Milieu/gebruik. Mag soort vergunning wijzigen (T of F).

 

 

dlcmilvergcorregtent

char(1)

 

 

 

'F'::bpchar

Niveau C. Milieu/Gebruuk... wijzigrecht (externe) tbcorrespondentie.dvexttracktrace

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

cfk_tbmilvergrecht_keyrechten

dnkeyrechten

public.tbrechten

dnkey

Cascade

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

chk_milvergr_dlbmilverghlink

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

 

chk_milvergr_dlbmilvergodedt

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

 

chk_milvergr_dlbmilvergverpl

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

 

chk_milvergr_dlcmilvergolodel

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

 

chk_milvergr_dlcmilvergoloedt

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

 

chk_milvergr_dlcmilvergoloins

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

 

chk_milvergr_dlcmilvergolovsb

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

 

chk_milvergrecht_dlbmilvergbcc

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

 

chk_milvergrecht_dlbmilvergwznedt

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

 

chk_milvergrecht_dlbmilvergztedt

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

 

chk_milvergrecht_dlbmilvgblok

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

 

chk_milvergrecht_dlbmilvgdel

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

 

chk_milvergrecht_dlbmilvgedt

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

 

chk_milvergrecht_dlbmilvggpedt

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

 

chk_milvergrecht_dlbmilvgins

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

 

chk_milvergrecht_dlbmilvgkopie

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

 

chk_milvergrecht_dlbmilvgmmedt

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

 

chk_milvergrecht_dlbmilvgmmvsb

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

 

chk_milvergrecht_dlcmilbrwdel

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

 

chk_milvergrecht_dlcmilbrwedt

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

 

chk_milvergrecht_dlcmilbrwins

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

 

chk_milvergrecht_dlcmilbrwvsb

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

 

chk_milvergrecht_dlcmilvergcorregtent

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

 

chk_milvergrecht_dlcmilvergprddel

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

 

chk_milvergrecht_dlcmilvergprdedt

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

 

chk_milvergrecht_dlcmilvergprdins

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

 

chk_milvergrecht_dlcmilvgavdel

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

 

chk_milvergrecht_dlcmilvgavdet

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

 

chk_milvergrecht_dlcmilvgavedt

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

 

chk_milvergrecht_dlcmilvgaviet

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

 

chk_milvergrecht_dlcmilvgavins

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

 

chk_milvergrecht_dlcmilvgavvsb

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

 

chk_milvergrecht_dlcmilvgcddel

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

 

chk_milvergrecht_dlcmilvgcdins

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

 

chk_milvergrecht_dlcmilvgcdvsb

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

 

chk_milvergrecht_dlcmilvgcndel

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

 

chk_milvergrecht_dlcmilvgcnedt

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

 

chk_milvergrecht_dlcmilvgcnins

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

 

chk_milvergrecht_dlcmilvgcnvsb

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

 

chk_milvergrecht_dlcmilvgcrdel

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

 

chk_milvergrecht_dlcmilvgcredt

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

 

chk_milvergrecht_dlcmilvgcrins

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

 

chk_milvergrecht_dlcmilvgcrvsb

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

 

chk_milvergrecht_dlcmilvgibedt

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

 

chk_milvergrecht_dlcmilvgibins

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

 

chk_milvergrecht_dlcmilvgibvsb

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

 

chk_milvergrecht_dlcmilvgpoahn

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

 

chk_milvergrecht_dlcmilvgpodel

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

 

chk_milvergrecht_dlcmilvgpoedt

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

 

chk_milvergrecht_dlcmilvgpoins

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

 

chk_milvergrecht_dlcmilvgpovdg

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

 

chk_milvergrecht_dlcmilvgpovsb

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

 

chk_milvergrecht_dlcmilvgwtdel

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

 

chk_milvergrecht_dlcmilvgwtedt

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

 

chk_milvergrecht_dlcmilvgwtins

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

 

chk_milvergrecht_dlcmilvgwtvsb

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

 

chk_milvergrecht_keyrechten

dnkeyrechten IS NOT NULL

 

chk_milvergrechten_dlverzendl

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

 

chk_milvgrecht_dlcmilvgcordms

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

 

chk_milvgrecht_dlcmilvgcorodt

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

 

chk_milvgrechten_dlcmlvgcrghnm

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

 

chk_milvrecht_dlcmilvcorwmo

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

 

chk_milvrechten_dlbmvsnelins

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

 

chk_milvrechten_dlcmivbezwdel

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

 

chk_milvrechten_dlcmivbezwdms

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

 

chk_milvrechten_dlcmivbezwedt

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

 

chk_milvrechten_dlcmivbezwins

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

 

chk_milvrechten_dlcmivbezwvsb

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

 

chk_mlvrct_dlcmilvergcordocdel

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

 

chk_mlvrct_dlcmilvergcorregdwl

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

 

chk_mlvrct_dlcmilvergcorregvsb

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

 

chk_mvrechten_dlbmilvergafsedt

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

 

chk_mvrechten_dlcmilverguurdel

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

 

chk_mvrechten_dlcmilverguuredt

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

 

chk_mvrechten_dlcmilverguurins

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

 

chk_mvrechten_dlcmilverguurvsb

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

 

chk_mvrechten_dlcmlvgadvuurvsb

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

 

chk_mvrechten_dlcmlvgbezuurvsb

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

 

chk_mvrechten_dlcmlvginsuurvsb

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

 

chk_tbmilverg_dlcmilvergadvdms

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

 

cnn_milvergr_dlbmilverghlink

dlbmilverghlink IS NOT NULL

 

cnn_milvergr_dlbmilvergodedt

dlbmilvergodedt IS NOT NULL

 

cnn_milvergr_dlbmilvergverpl

dlbmilvergverplaats IS NOT NULL

 

cnn_milvergrecht_dlbmilvergbcc

dlbmilvergbcc IS NOT NULL

 

cnn_milvergrecht_dlbmilvergwznedt

dlbmilvergwznedt IS NOT NULL

 

cnn_milvergrecht_dlbmilvergztedt

dlbmilvergztedt IS NOT NULL

 

cnn_milvergrecht_dlcmilvergcorregtent

dlcmilvergcorregtent IS NOT NULL

 

cnn_milvergrecht_dlcmilvergprddel

dlcmilvergprddel IS NOT NULL

 

cnn_milvergrecht_dlcmilvergprdedt

dlcmilvergprdedt IS NOT NULL

 

cnn_milvergrecht_dlcmilvergprdins

dlcmilvergprdins IS NOT NULL

 

cnn_milvergrechten_dlverzendl

dlbmilvergverzledt IS NOT NULL

 

cnn_milvgrecht_dlcmilvgcordms

dlcmilvergcordms IS NOT NULL

 

cnn_milvgrecht_dlcmilvgcorodt

dlcmilvergcorodt IS NOT NULL

 

cnn_milvgrechten_dlcmivbezwdms

dlcmilvergbezwdms IS NOT NULL

 

cnn_milvgrechten_dlcmlvgcrghnm

dlcmilvergcorreghnm IS NOT NULL

 

cnn_milvrecht_dlcmilvcorwmo

dlcmilvergcorwmo IS NOT NULL

 

cnn_milvrechten_dlbmvsnelins

dlbmilvergsnelins IS NOT NULL

 

cnn_milvrechten_dlcmivbezwdel

dlcmilvergbezwdel IS NOT NULL

 

cnn_milvrechten_dlcmivbezwedt

dlcmilvergbezwedt IS NOT NULL

 

cnn_milvrechten_dlcmivbezwins

dlcmilvergbezwins IS NOT NULL

 

cnn_milvrechten_dlcmivbezwvsb

dlcmilvergbezwvsb IS NOT NULL

 

cnn_mlvrct_dlcmilvergcordocdel

dlcmilvergcordocdel IS NOT NULL

 

cnn_mlvrct_dlcmilvergcorregdwl

dlcmilvergcorregdwl IS NOT NULL

 

cnn_mlvrct_dlcmilvergcorregvsb

dlcmilvergcorregvsb IS NOT NULL

 

cnn_mvrechten_dlbmilvergafsedt

dlbmilvergafsedt IS NOT NULL

 

cnn_mvrechten_dlcmilverguurdel

dlcmilverguurdel IS NOT NULL

 

cnn_mvrechten_dlcmilverguuredt

dlcmilverguuredt IS NOT NULL

 

cnn_mvrechten_dlcmilverguurins

dlcmilverguurins IS NOT NULL

 

cnn_mvrechten_dlcmilverguurvsb

dlcmilverguurvsb IS NOT NULL

 

cnn_mvrechten_dlcmlvgadvuurvsb

dlcmilvergadvuurvsb IS NOT NULL

 

cnn_mvrechten_dlcmlvgbezuurvsb

dlcmilvergbezwuurvsb IS NOT NULL

 

cnn_mvrechten_dlcmlvginsuurvsb

dlcmilverginsuurvsb IS NOT NULL

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbmilvergrechten

btree

 

dnkey

 

idu_milvergrechten_keyrechten

btree

 

dnkeyrechten

 

 

 

Triggers

There are no triggers for table tbmilvergrechten

 

Rules

There are no rules for table tbmilvergrechten

 

Policies

There are no policies for table tbmilvergrechten

 

Referenced

There are no tables referenced by table tbmilvergrechten

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.tbmilvergrechten (
 dnkey SERIAL,
 dnkeyrechten INTEGER,
 dlbmilvergedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergins CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergblokkedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilverggroepedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergmemovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergkopie CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergmemoedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergwetvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergwetedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergwetins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergwetdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcorvsb CHAR(1) DEFAULT 'T'::bpchar,
 dlcmilvergcoredt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcorins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcordel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcadvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcadins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcaddel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergadvvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergadvedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergadvins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergadvdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcinvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcinins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcindel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergibbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergibbedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergibbins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergprovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergproedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergproins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergprodel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergproahn CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergprovdg CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergadvdatedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergadvinedt CHAR(1) DEFAULT 'T'::bpchar,
 dlbmilvergverzledt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergbrwvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergbrwedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergbrwins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergbrwdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergbcc CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcordms CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcorodt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergsnelins CHAR(1) DEFAULT 'T'::bpchar,
 dlcmilvergolovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergoloedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergoloins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergolodel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergadvdms CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergodedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilverghlink CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergverplaats CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergbezwvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergbezwedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergbezwins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergbezwdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergbezwdms CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilverguurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilverguurins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilverguurdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilverguuredt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilverginsuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergbezwuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergadvuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergafsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcorregvsb CHAR(1) DEFAULT 'T'::bpchar,
 dlcmilvergcorregdwl CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcordocdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcorwmo CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcorreghnm CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergprdedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergprdins CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergprddel CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergwznedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbmilvergztedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcmilvergcorregtent CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tbmilvergrechten PRIMARY KEY(dnkey),
 CONSTRAINT chk_milvergr_dlbmilverghlink CHECK (dlbmilverghlink = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvergr_dlbmilvergodedt CHECK (dlbmilvergodedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvergr_dlbmilvergverpl CHECK (dlbmilvergverplaats = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvergr_dlcmilvergolodel CHECK (dlcmilvergolodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergr_dlcmilvergoloedt CHECK (dlcmilvergoloedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergr_dlcmilvergoloins CHECK (dlcmilvergoloins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergr_dlcmilvergolovsb CHECK (dlcmilvergolovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvergbcc CHECK (dlbmilvergbcc = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvergwznedt CHECK (dlbmilvergwznedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvergztedt CHECK (dlbmilvergztedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvgblok CHECK (dlbmilvergblokkedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvgdel CHECK (dlbmilvergdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvgedt CHECK (dlbmilvergedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvggpedt CHECK (dlbmilverggroepedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvgins CHECK (dlbmilvergins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvgkopie CHECK (dlbmilvergkopie = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvgmmedt CHECK (dlbmilvergmemoedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlbmilvgmmvsb CHECK (dlbmilvergmemovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilbrwdel CHECK (dlcmilvergbrwdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilbrwedt CHECK (dlcmilvergbrwedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilbrwins CHECK (dlcmilvergbrwins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilbrwvsb CHECK (dlcmilvergbrwvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvergcorregtent CHECK (dlcmilvergcorregtent = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvergprddel CHECK (dlcmilvergprddel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvergprdedt CHECK (dlcmilvergprdedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvergprdins CHECK (dlcmilvergprdins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgavdel CHECK (dlcmilvergadvdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgavdet CHECK (dlcmilvergadvdatedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgavedt CHECK (dlcmilvergadvedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgaviet CHECK (dlcmilvergadvinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgavins CHECK (dlcmilvergadvins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgavvsb CHECK (dlcmilvergadvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcddel CHECK (dlcmilvergcaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcdins CHECK (dlcmilvergcadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcdvsb CHECK (dlcmilvergcadvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcndel CHECK (dlcmilvergcindel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcnedt CHECK (dlcmilvergcinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcnins CHECK (dlcmilvergcinins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcnvsb CHECK (dlcmilvergcinvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcrdel CHECK (dlcmilvergcordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcredt CHECK (dlcmilvergcoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcrins CHECK (dlcmilvergcorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgcrvsb CHECK (dlcmilvergcorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgibedt CHECK (dlcmilvergibbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgibins CHECK (dlcmilvergibbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgibvsb CHECK (dlcmilvergibbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgpoahn CHECK (dlcmilvergproahn = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgpodel CHECK (dlcmilvergprodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgpoedt CHECK (dlcmilvergproedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgpoins CHECK (dlcmilvergproins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgpovdg CHECK (dlcmilvergprovdg = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgpovsb CHECK (dlcmilvergprovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgwtdel CHECK (dlcmilvergwetdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgwtedt CHECK (dlcmilvergwetedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgwtins CHECK (dlcmilvergwetins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_dlcmilvgwtvsb CHECK (dlcmilvergwetvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvergrecht_keyrechten CHECK (dnkeyrechten IS NOT NULL),
 CONSTRAINT chk_milvergrechten_dlverzendl CHECK (dlbmilvergverzledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvgrecht_dlcmilvgcordms CHECK (dlcmilvergcordms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvgrecht_dlcmilvgcorodt CHECK (dlcmilvergcorodt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvgrechten_dlcmlvgcrghnm CHECK (dlcmilvergcorreghnm = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvrecht_dlcmilvcorwmo CHECK (dlcmilvergcorwmo = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvrechten_dlbmvsnelins CHECK (dlbmilvergsnelins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_milvrechten_dlcmivbezwdel CHECK (dlcmilvergbezwdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvrechten_dlcmivbezwdms CHECK (dlcmilvergbezwdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvrechten_dlcmivbezwedt CHECK (dlcmilvergbezwedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvrechten_dlcmivbezwins CHECK (dlcmilvergbezwins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_milvrechten_dlcmivbezwvsb CHECK (dlcmilvergbezwvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_mlvrct_dlcmilvergcordocdel CHECK (dlcmilvergcordocdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_mlvrct_dlcmilvergcorregdwl CHECK (dlcmilvergcorregdwl = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_mlvrct_dlcmilvergcorregvsb CHECK (dlcmilvergcorregvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_mvrechten_dlbmilvergafsedt CHECK (dlbmilvergafsedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_mvrechten_dlcmilverguurdel CHECK (dlcmilverguurdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_mvrechten_dlcmilverguuredt CHECK (dlcmilverguuredt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_mvrechten_dlcmilverguurins CHECK (dlcmilverguurins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_mvrechten_dlcmilverguurvsb CHECK (dlcmilverguurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_mvrechten_dlcmlvgadvuurvsb CHECK (dlcmilvergadvuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_mvrechten_dlcmlvgbezuurvsb CHECK (dlcmilvergbezwuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_mvrechten_dlcmlvginsuurvsb CHECK (dlcmilverginsuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbmilverg_dlcmilvergadvdms CHECK (dlcmilvergadvdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT cnn_milvergr_dlbmilverghlink CHECK (dlbmilverghlink IS NOT NULL),
 CONSTRAINT cnn_milvergr_dlbmilvergodedt CHECK (dlbmilvergodedt IS NOT NULL),
 CONSTRAINT cnn_milvergr_dlbmilvergverpl CHECK (dlbmilvergverplaats IS NOT NULL),
 CONSTRAINT cnn_milvergrecht_dlbmilvergbcc CHECK (dlbmilvergbcc IS NOT NULL),
 CONSTRAINT cnn_milvergrecht_dlbmilvergwznedt CHECK (dlbmilvergwznedt IS NOT NULL),
 CONSTRAINT cnn_milvergrecht_dlbmilvergztedt CHECK (dlbmilvergztedt IS NOT NULL),
 CONSTRAINT cnn_milvergrecht_dlcmilvergcorregtent CHECK (dlcmilvergcorregtent IS NOT NULL),
 CONSTRAINT cnn_milvergrecht_dlcmilvergprddel CHECK (dlcmilvergprddel IS NOT NULL),
 CONSTRAINT cnn_milvergrecht_dlcmilvergprdedt CHECK (dlcmilvergprdedt IS NOT NULL),
 CONSTRAINT cnn_milvergrecht_dlcmilvergprdins CHECK (dlcmilvergprdins IS NOT NULL),
 CONSTRAINT cnn_milvergrechten_dlverzendl CHECK (dlbmilvergverzledt IS NOT NULL),
 CONSTRAINT cnn_milvgrecht_dlcmilvgcordms CHECK (dlcmilvergcordms IS NOT NULL),
 CONSTRAINT cnn_milvgrecht_dlcmilvgcorodt CHECK (dlcmilvergcorodt IS NOT NULL),
 CONSTRAINT cnn_milvgrechten_dlcmivbezwdms CHECK (dlcmilvergbezwdms IS NOT NULL),
 CONSTRAINT cnn_milvgrechten_dlcmlvgcrghnm CHECK (dlcmilvergcorreghnm IS NOT NULL),
 CONSTRAINT cnn_milvrecht_dlcmilvcorwmo CHECK (dlcmilvergcorwmo IS NOT NULL),
 CONSTRAINT cnn_milvrechten_dlbmvsnelins CHECK (dlbmilvergsnelins IS NOT NULL),
 CONSTRAINT cnn_milvrechten_dlcmivbezwdel CHECK (dlcmilvergbezwdel IS NOT NULL),
 CONSTRAINT cnn_milvrechten_dlcmivbezwedt CHECK (dlcmilvergbezwedt IS NOT NULL),
 CONSTRAINT cnn_milvrechten_dlcmivbezwins CHECK (dlcmilvergbezwins IS NOT NULL),
 CONSTRAINT cnn_milvrechten_dlcmivbezwvsb CHECK (dlcmilvergbezwvsb IS NOT NULL),
 CONSTRAINT cnn_mlvrct_dlcmilvergcordocdel CHECK (dlcmilvergcordocdel IS NOT NULL),
 CONSTRAINT cnn_mlvrct_dlcmilvergcorregdwl CHECK (dlcmilvergcorregdwl IS NOT NULL),
 CONSTRAINT cnn_mlvrct_dlcmilvergcorregvsb CHECK (dlcmilvergcorregvsb IS NOT NULL),
 CONSTRAINT cnn_mvrechten_dlbmilvergafsedt CHECK (dlbmilvergafsedt IS NOT NULL),
 CONSTRAINT cnn_mvrechten_dlcmilverguurdel CHECK (dlcmilverguurdel IS NOT NULL),
 CONSTRAINT cnn_mvrechten_dlcmilverguuredt CHECK (dlcmilverguuredt IS NOT NULL),
 CONSTRAINT cnn_mvrechten_dlcmilverguurins CHECK (dlcmilverguurins IS NOT NULL),
 CONSTRAINT cnn_mvrechten_dlcmilverguurvsb CHECK (dlcmilverguurvsb IS NOT NULL),
 CONSTRAINT cnn_mvrechten_dlcmlvgadvuurvsb CHECK (dlcmilvergadvuurvsb IS NOT NULL),
 CONSTRAINT cnn_mvrechten_dlcmlvgbezuurvsb CHECK (dlcmilvergbezwuurvsb IS NOT NULL),
 CONSTRAINT cnn_mvrechten_dlcmlvginsuurvsb CHECK (dlcmilverginsuurvsb IS NOT NULL),
 CONSTRAINT cfk_tbmilvergrecht_keyrechten FOREIGN KEY (dnkeyrechten)
   REFERENCES public.tbrechten(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) ;

COMMENT ON TABLE public.tbmilvergrechten
IS 'Rechtentabel voor de module inrichtingen (rechten op de milieu- en gebruiksvergunningen)';

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

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

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergedt
IS 'Niveau B Milieu vergunning Wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergins
IS 'Niveau B Milieu vergunning Nieuwrecht (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergdel
IS 'Niveau B Milieu vergunning Verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergblokkedt
IS 'Niveau B Milieu vergunning Blokkeerrecht (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilverggroepedt
IS 'Niveau B Milieu vergunning (T of F) Groepvergunnigen maken.';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergmemovsb
IS 'Niveau B Milieu vergunning Memo zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergkopie
IS 'Niveau B Milieu vergunning. Kopieerrecht.';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergmemoedt
IS 'Niveau B. Milieu vergunning. Memo wijzigen.';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergwetvsb
IS 'Niveau C Milieu vergunning Wetten zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergwetedt
IS 'Niveau C Milieu vergunning Wetten wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergwetins
IS 'Niveau C Milieu vergunning Wetten nieuw (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergwetdel
IS 'Niveau C Milieu vergunning Wetten verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcorvsb
IS 'Niveau C Milieu vergunning alle correspondentie zichtbaar (T of F). default T';

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

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcorins
IS 'Niveau C Milieu vergunning correspondentie creeren en uploaden van document (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcordel
IS 'Niveau C Milieu vergunning correspondentie geregisteerde correspondentie verwijderen metadata (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcadvsb
IS 'Niveau C Milieu vergunning contactadressen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcadins
IS 'Niveau C Milieu vergunning contactadressen koppeling maken (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcaddel
IS 'Niveau C Milieu vergunning contactadressen koppeling verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergadvvsb
IS 'Niveau C Milieu vergunning adviezen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergadvedt
IS 'Niveau C Milieu vergunning adviezen wijzigen (T of F).';

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

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergadvdel
IS 'Niveau C Milieu vergunning adviezen verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcinvsb
IS 'Niveau C Milieu vergunning Correspondentie Binnen Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcinedt
IS 'Niveau C Milieu vergunning Correspondentie Binnen Wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcinins
IS 'Niveau C Milieu vergunning Correspondentie Binnen Nieuw (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcindel
IS 'Niveau C Milieu vergunning Correspondentie Binnen Verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergibbvsb
IS 'Niveau C Milieu vergunning in behandeling bij zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergibbedt
IS 'Niveau C Milieu vergunning in behandeling bij  wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergibbins
IS 'Niveau C Milieu vergunning in behandeling bij nieuw (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergprovsb
IS 'Niveau C Milieu vergunning Procedures zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergproedt
IS 'Niveau C Milieu vergunning Procedures wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergproins
IS 'Niveau C Milieu vergunning Procedures nieuw (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergprodel
IS 'Niveau C Milieu vergunning procedures verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergproahn
IS 'Wordt niet meer gebruikt';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergprovdg
IS 'Wordt niet meer gebruikt';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergadvdatedt
IS 'Niveau C. Adviezen. Wijzigrecht kolom DdDateringadvies van tabel TbAdviezen bij milieuvergunningen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergadvinedt
IS 'Niveau C. Milieuvergunningen. Adviesinstantie wijzigbaar bij adviezen.';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergverzledt
IS 'Niveau B milieu vergunning Verzendlijst maken (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergbrwvsb
IS 'Niveau C Milieuvergunningen Brandweer (Preparaties en installaties) zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergbrwedt
IS 'Niveau C Milieuvergunningen Brandweer (Preparaties en installaties) wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergbrwins
IS 'Niveau C Milieuvergunningen Brandweer (Preparaties en installaties) nieuw (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergbrwdel
IS 'Niveau C Milieuvergunningen Brandweer (Preparaties en installaties) verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcordms
IS 'Niveau C. Milieuvergunnningen. Correspondentie. DMS-kolom muteerbaar';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcorodt
IS 'Niveau C. Milieuvergunningen. Correspondentie. Opgeslagen document-kolom muteerbaar.';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergsnelins
IS 'Niveau B. Milieuvergunningen. Mag externe zaakcode wijzigen.';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergolovsb
IS 'Niveau C Milieu vergunning oloberichten zichtbaar (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergoloedt
IS 'Niveau C Milieu vergunning oloberichten wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergoloins
IS 'Niveau C Milieu vergunning oloberichten nieuw (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergolodel
IS 'Niveau C Milieu vergunning oloberichten verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergadvdms
IS 'Niveau C. Milieu vergunning. Adviezen. Dmscode muteren (T of F). ';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergodedt
IS 'Niveau B. Milieu/gebruik. Mag ontvangsdatum wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilverghlink
IS 'Niveau B. Milieu/gebruik. Mag hyperlink starten vanuit powerportal milieu/gebruikdetail.';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergverplaats
IS 'Niveau B. Milieu/gebruik. Mag zaak verplaatsen naar ander locatieadres';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergbezwvsb
IS 'Niveau C. Milieu/gebruik. Bezwaar/beroep inzien (T of F)';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergbezwedt
IS 'Niveau C. Milieu/gebruik. Bezwaar/beroep wijzgen (T of F)';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergbezwins
IS 'Niveau C. Milieu/gebruik. Bezwaar/beroep insert (T of F)';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergbezwdel
IS 'Niveau C. Milieu/gebruik. Bezwaar/beroep delete (T of F)';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergbezwdms
IS 'Niveau C. Milieu/gebruik. Bezwaar/beroep. dmscode (extern zaakidentificatie) muteren (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilverguurvsb
IS 'Niveau C. Milieu/gebruik... uren inzien (T of F)';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilverguurins
IS 'Niveau C. Milieu/gebruik... uren insert (T of F)';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilverguurdel
IS 'Niveau C. Milieu/gebruik... uren delete (T of F)';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilverguuredt
IS 'Niveau C. Milieu/gebruik... uren wijzgen (T of F)';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilverginsuurvsb
IS 'Niveau C. inspecties bij Milieu/gebruik... uren inzien (T of F), edit- insert- delrechten via dlcmilverguuredt, dlcmilverguurins,dlcmilverguurdel';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergbezwuurvsb
IS 'Niveau C. bezwaar/beroep bij Milieu/gebruik... uren inzien (T of F), edit- insert- delrechten via dlcmilverguuredt, dlcmilverguurins,dlcmilverguurdel';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergadvuurvsb
IS 'Niveau C. adviezen bij Milieu/gebruik... uren inzien (T of F), edit- insert- delrechten via dlcmilverguuredt, dlcmilverguurins,dlcmilverguurdel';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergafsedt
IS 'Niveau B  Milieu/Gebruik gevulde afhandeldatum wijzgen en dit geldt ook voor gevulde externe zaak einddatum (dddmsafgehandeld) bij deelzaken advies en bezwaarberoep die aan  Milieu/Gebruik zijn gekoppeld(T of F)';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcorregvsb
IS 'Niveau C Milieu/Gebruik Geregistreerde documenten zichtbaar (T of F) Default T';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcorregdwl
IS 'Niveau C Milieu/Gebruik Geregistreerde documenten Mag geforceerd downloaden (T of F) Default F';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcordocdel
IS 'Niveau C Milieu/Gebruik geregisteerde correspondentie verwijderen fysiek document(T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcorwmo
IS 'Niveau C Milieu/Gebruik Wijzigen metadata (hernoemen filenaam) ongeregistreerde documenten (T of F)';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcorreghnm
IS 'Niveau C Milieu/Gebruik Hernoemen geregistreerde documenten';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergprdedt
IS 'Niveau C Milieu/Gebruik Product/Dienst wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergprdins
IS 'Niveau C Milieu/Gebruik Product/Dienst toevoegen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergprddel
IS 'Niveau C Milieu/Gebruik Product/Dienst verwijderen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergwznedt
IS 'Niveau B. Milieu/gebruik. Mag Wavezaakcode (dvvergnummer) wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlbmilvergztedt
IS 'Niveau B. Milieu/gebruik. Mag soort vergunning wijzigen (T of F).';

COMMENT ON COLUMN public.tbmilvergrechten.dlcmilvergcorregtent
IS 'Niveau C. Milieu/Gebruuk... wijzigrecht (externe) tbcorrespondentie.dvexttracktrace';

CREATE UNIQUE INDEX idu_milvergrechten_keyrechten ON public.tbmilvergrechten
 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