Datadictionary OpenWave 3.1.25
 Previous topic Chapter index Next topic

Table: tbovrechten

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Rechtentabel voor de module overige vergunningen

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbovrechten_dnkey_seq'::regclass)

Primary.

 

dnkeyrechten

integer

 

 

 

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

 

 

dlbovvedt

char(1)

 

 

 

'F'::bpchar

Niveau BOvVerg Wijzigrecht (T of F).

 

 

dlbovvins

char(1)

 

 

 

'F'::bpchar

Niveau BOvVerg Nieuwrecht (T of F).

 

 

dlbovvdel

char(1)

 

 

 

'F'::bpchar

Niveau BOvVerg Verwijderrecht (T of F).

 

 

dlbovvblokkedt

char(1)

 

 

 

'F'::bpchar

Niveau BOvVerg Verwijderrecht (T of F).

 

 

dlbovvverzledt

char(1)

 

 

 

'F'::bpchar

Niveau BOvVerg Verwijderrecht (T of F).

 

 

dlbovvgroepedt

char(1)

 

 

 

'F'::bpchar

Niveau B OvVerg (T of F) Groepvergunnigen maken.

 

 

dlbovvmemovsb

char(1)

 

 

 

'F'::bpchar

Niveau B OvVerg Memo zichtbaar (T of F).

 

 

dlbovvverplaats

char(1)

 

 

 

'F'::bpchar

Niveau BOvVerg Verplaatsrecht.

 

 

dlbovvabedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Overige vergunningen Aard Besluit wijzigen.

 

 

dlbovvmemoedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Overige vergunningen. Memo wijzigen.

 

 

dlbovvsnelins

char(1)

 

 

 

'T'::bpchar

Niveau B. Overige vergunningen. Mag externe zaaknummers wijzigen (dvdmszaakcode, dvintzaakcode, dvzaaknrbevgezag) (T of F).

 

 

dlbovvodedt

char(1)

 

 

 

'T'::bpchar

Niveau B. Overige vergunningen. Mag ontvangsdatum wijzigen (T of F).

 

 

dlbovvkopie

char(1)

 

 

 

'F'::bpchar

Niveau B Overige vergunningen. Kopieerrecht.

 

 

dlcovvibbvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Ibb zichtbaar (T of F).

 

 

dlcovvibbedt

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Ibb wijzigen (T of F).

 

 

dlcovvibbins

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Ibb nieuw (T of F).

 

 

dlcovvibbdel

char(1)

 

 

 

'F'::bpchar

Niet meer in gebruik.

 

 

dlcovvprovsb

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Procedures zichtbaar (T of F).

 

 

dlcovvproedt

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Procedures zichtbaar (T of F).

 

 

dlcovvproins

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Procedures nieuw (T of F).

 

 

dlcovvprodel

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Procedures verwijderen (T of F).

 

 

dlcovvbspvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Bestemmingsplannen (afw en vrijst) zichtbaar (T of F).

 

 

dlcovvbspedt

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Bestemmingsplannen (afw en vrijst) wijzigen (T of F).

 

 

dlcovvbspins

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Bestemminghsplannen (afw en vrijst) nieuw (T of F).

 

 

dlcovvbspdel

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvvergunning Bestemmingsplan (afw en vrijst) verwijderen (T of F).

 

 

dlcovvadvvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Adviezen zichtbaar (T of F).

 

 

dlcovvadvedt

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Adviezen wijzigen (T of F).

 

 

dlcovvadvins

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Adviezen nieuw (T of F).

 

 

dlcovvadvdel

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Adviezen verwijderen (T of F).

 

 

dlcovvinsvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Inspecties zichtbaar (T of F).

 

 

dlcovvinsedt

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Inspecties wijzigen (T of F).

 

 

dlcovvinsins

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Inspecties nieuw (T of F).

 

 

dlcovvinsdel

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Inspecties verwijderrecht (trajecten, overtredingen en bezoeken) (T of F).

 

 

dlcovvcorvsb

char(1)

 

 

 

'T'::bpchar

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

 

 

dlcovvcoredt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcovvcorins

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcovvcordel

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcovvcadvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning contactadressen zichtbaar (T of F).

 

 

dlcovvcadins

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning contactadressen koppeling maken (T of F).

 

 

dlcovvcaddel

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning contactadressen koppeling verwijderen (T of F).

 

 

dlcovvlegvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Leges zichtbaar (T of F).

 

 

dlcovvlegedt

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Leges wijzigen (T of F).

 

 

dlcovvlegins

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Leges nieuw (T of F).

 

 

dlcovvlegdel

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Leges verwijderen (T of F).

 

 

dlcovvlogvsb

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlcovvlogedt

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlcovvlogins

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlcovvlogdel

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlcovvcinvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Overige vergunningen Correspondentie Binnen Zichtbaar (T of F).

 

 

dlcovvcinedt

char(1)

 

 

 

'F'::bpchar

Niveau C Overige vergunningen Correspondentie Binnen Wijzigen (T of F).

 

 

dlcovvcinins

char(1)

 

 

 

'F'::bpchar

Niveau C Overige vergunningen Correspondentie Binnen Nieuw (T of F).

 

 

dlcovvcindel

char(1)

 

 

 

'F'::bpchar

Niveau C Overige vergunningen Correspondentie Binnen Verwijderen (T of F).

 

 

dlcovvcompr

char(1)

 

 

 

'F'::bpchar

(Niveau C Overige vergunningen Compressie Termijnbewaking). Wordt niet gebruikt.

 

 

dlcovvproahn

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning Procedures aanhouden en termijn van orde (T of F).

 

 

dlcovvprovdg

char(1)

 

 

 

'F'::bpchar

Niveau C OvVergunning Procedures verdagen (T of F).

 

 

dlcovvadvinedt

char(1)

 

 

 

'T'::bpchar

(Niveau C Overige vergunningen Compressie Termijnbewaking.) Wordt niet gebruikt.

 

 

dlcovvlegexpnot

char(1)

 

 

 

'F'::bpchar

Niveau C. Overig vergunningen Leges Notanummer en Exportdatum muteerbaar.

 

 

dlcovvadvdatedt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcovvwelstandvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. kolommen op subtabblad Welstandadviezen bij adviezen. Zichtbaar (T of F).

 

 

dlcovvwelstandedt

char(1)

 

 

 

'F'::bpchar

Niveau C. kolommen op subtabblad Welstandadviezen bij adviezen muteerbaar (T of F).

 

 

dlcovvwelstanddel

char(1)

 

 

 

'F'::bpchar

Niveau C. kolommen op subtabblad Welstandadviezen bij adviezen verwijderrecht (T of F).

 

 

dlcovvwelstandins

char(1)

 

 

 

'F'::bpchar

Niveau C. kolommen op subtabblad Welstandadviezen bij adviezen. Nieuw maken (T of F).

 

 

dlbovvwelsttabvsb

char(1)

 

 

 

'F'::bpchar

Niveau B. tabblad van detailscherm met de welstandskolommen van Tbovverg. Zichtbaar (T of F).

 

 

dlbovvwelsttabedt

char(1)

 

 

 

'F'::bpchar

Niveau B.tabblad van detailscherm met de welstandskolommen van Tbovverg. Muteerbaar (T of F).

 

 

dlbovvmdedt

char(1)

 

 

 

'T'::bpchar

Niveau B. Overige vergunningen. Meetdatum en herberekenen termijnbewaking recht.

 

 

dlcovvcordms

char(1)

 

 

 

'F'::bpchar

Niveau C. APV/Overig. Correspondentie. DMS-kolom muteerbaar

 

 

dlcovvcorodt

char(1)

 

 

 

'F'::bpchar

Niveau C. APV/Overig. Correspondentie. Opgeslagen document-kolom muteerbaar.

 

 

dlcovvinsdms

char(1)

 

 

 

'F'::bpchar

Niveau C.APV/Overig. Inspecties. Mag externe zaakcode van Inspectie muteren (dvdmszaakcode, dvintzaakcode)(T of F).

 

 

dlcovvadvdms

char(1)

 

 

 

'F'::bpchar

Niveau C. APV/Overig. Adviezen. Mag externe zaakcode van Advies muteren (dvdmszaakcode, dvintzaakcode)(T of F).

 

 

dlbovvhlink

char(1)

 

 

 

'F'::bpchar

Niveau B. APV/Overig. Mag hyperlink starten vanuit powerportal apvoverigdetail.

 

 

dlcovvbezwvsb

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcovvbezwedt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcovvbezwins

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcovvbezwdel

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcovvbezwdms

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcovvuurvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. APV/Overig... uren inzien (T of F)

 

 

dlcovvuurins

char(1)

 

 

 

'F'::bpchar

Niveau C. APV/Overig... uren insert (T of F)

 

 

dlcovvuurdel

char(1)

 

 

 

'F'::bpchar

Niveau C. APV/Overig... uren delete (T of F)

 

 

dlcovvuuredt

char(1)

 

 

 

'F'::bpchar

Niveau C. APV/Overig... uren wijzgen (T of F)

 

 

dlcovvinsuurvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. inspecties bij APV/Overig... uren inzien (T of F), edit- insert- delrechten via dlcovvuuredt, dlcovvuurins,dlcovvuurdel

 

 

dlcovvbezwuurvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. bezwaar/beroep bij APV/Overig... uren inzien (T of F), edit- insert- delrechten via dlcovvuuredt, dlcovvuurins,dlcovvuurdel

 

 

dlcovvadvuurvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. adviezen bij APV/Overig... uren inzien (T of F), edit- insert- delrechten via dlcovvuuredt, dlcovvuurins,dlcovvuurdel

 

 

dlbovvafsedt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcovvcorregvsb

char(1)

 

 

 

'T'::bpchar

Niveau C APV/Overig Geregistreerde documenten zichtbaar (T of F) Default T

 

 

dlcovvcorregdwl

char(1)

 

 

 

'F'::bpchar

Niveau C APV/Overig Geregistreerde documenten Mag geforceerd downloaden (T of F) Default F

 

 

dlcovvcordocdel

char(1)

 

 

 

'F'::bpchar

Niveau C APV/Overig geregisteerde correspondentie verwijderen fysiek document(T of F).

 

 

dlcovvcorwmo

char(1)

 

 

 

'F'::bpchar

Niveau C APV/Overig Wijzigen metadata (hernoemen filenaam) ongeregistreerde documenten (T of F)

 

 

dlcovvcorreghnm

char(1)

 

 

 

'F'::bpchar

Niveau C APV/Overig Hernoemen geregistreerde documenten

 

 

dlcovvprdedt

char(1)

 

 

 

'F'::bpchar

Niveau C Overige vergunningen. Product/Dienst wijzigen (T of F).

 

 

dlcovvinsovbzdel

char(1)

 

 

 

'F'::bpchar

Niveau C APV/Overig. Alleen inspectiebezoeken en overtredingen verwijderen (T of F).

 

 

dlcovvprdins

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcovvprddel

char(1)

 

 

 

'F'::bpchar

Niveau C Overige vergunningen. Product/Dienst verwijderen (T of F).

 

 

dlbovvwznedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Overige vergunningen. Mag Wavezaakcode (dvvergunningsnr) wijzigen (T of F).

 

 

dlbovvztedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Overige vergunningen. Mag soort vergunning wijzigen (T of F).

 

 

dlcovvcorregtent

char(1)

 

 

 

'F'::bpchar

Niveau C. APV/Overig... wijzigrecht (externe) tbcorrespondentie.dvexttracktrace

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

cfk_ovrechten_keyrechten

dnkeyrechten

public.tbrechten

dnkey

Cascade

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

chk_ovrecht_dlcovvcordocdel

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

 

chk_ovrecht_dlcovvcorregdwl

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

 

chk_ovrecht_dlcovvcorregtent

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

 

chk_ovrecht_dlcovvcorregvsb

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

 

chk_ovrechten_dlbovvabedt

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

 

chk_ovrechten_dlbovvafsedt

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

 

chk_ovrechten_dlbovvblokkedt

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

 

chk_ovrechten_dlbovvdel

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

 

chk_ovrechten_dlbovvedt

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

 

chk_ovrechten_dlbovvgroepedt

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

 

chk_ovrechten_dlbovvins

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

 

chk_ovrechten_dlbovvkopie

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

 

chk_ovrechten_dlbovvmdedt

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

 

chk_ovrechten_dlbovvmemoedt

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

 

chk_ovrechten_dlbovvmemovsb

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

 

chk_ovrechten_dlbovvodedt

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

 

chk_ovrechten_dlbovvsnelins

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

 

chk_ovrechten_dlbovvverplaats

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

 

chk_ovrechten_dlbovvverzledt

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

 

chk_ovrechten_dlbovvwznedt

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

 

chk_ovrechten_dlbovvztedt

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

 

chk_ovrechten_dlcovvadvdel

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

 

chk_ovrechten_dlcovvadvedt

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

 

chk_ovrechten_dlcovvadvinedt

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

 

chk_ovrechten_dlcovvadvins

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

 

chk_ovrechten_dlcovvadvuurvsb

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

 

chk_ovrechten_dlcovvadvvsb

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

 

chk_ovrechten_dlcovvbezwdel

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

 

chk_ovrechten_dlcovvbezwdms

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

 

chk_ovrechten_dlcovvbezwedt

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

 

chk_ovrechten_dlcovvbezwins

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

 

chk_ovrechten_dlcovvbezwuurvsb

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

 

chk_ovrechten_dlcovvbezwvsb

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

 

chk_ovrechten_dlcovvbspdel

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

 

chk_ovrechten_dlcovvbspedt

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

 

chk_ovrechten_dlcovvbspins

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

 

chk_ovrechten_dlcovvbspvsb

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

 

chk_ovrechten_dlcovvcaddel

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

 

chk_ovrechten_dlcovvcadins

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

 

chk_ovrechten_dlcovvcadvsb

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

 

chk_ovrechten_dlcovvcindel

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

 

chk_ovrechten_dlcovvcinedt

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

 

chk_ovrechten_dlcovvcinins

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

 

chk_ovrechten_dlcovvcinvsb

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

 

chk_ovrechten_dlcovvcompr

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

 

chk_ovrechten_dlcovvcordel

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

 

chk_ovrechten_dlcovvcordms

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

 

chk_ovrechten_dlcovvcoredt

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

 

chk_ovrechten_dlcovvcorins

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

 

chk_ovrechten_dlcovvcorodt

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

 

chk_ovrechten_dlcovvcorreghnm

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

 

chk_ovrechten_dlcovvcorvsb

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

 

chk_ovrechten_dlcovvcorwmo

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

 

chk_ovrechten_dlcovvibbdel

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

 

chk_ovrechten_dlcovvibbedt

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

 

chk_ovrechten_dlcovvibbins

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

 

chk_ovrechten_dlcovvibbvsb

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

 

chk_ovrechten_dlcovvinsdel

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

 

chk_ovrechten_dlcovvinsedt

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

 

chk_ovrechten_dlcovvinsins

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

 

chk_ovrechten_dlcovvinsovbzdel

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

 

chk_ovrechten_dlcovvinsuurvsb

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

 

chk_ovrechten_dlcovvinsvsb

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

 

chk_ovrechten_dlcovvlegdel

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

 

chk_ovrechten_dlcovvlegedt

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

 

chk_ovrechten_dlcovvlegexpnot

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

 

chk_ovrechten_dlcovvlegins

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

 

chk_ovrechten_dlcovvlegvsb

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

 

chk_ovrechten_dlcovvlogdel

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

 

chk_ovrechten_dlcovvlogedt

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

 

chk_ovrechten_dlcovvlogins

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

 

chk_ovrechten_dlcovvlogvsb

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

 

chk_ovrechten_dlcovvprddel

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

 

chk_ovrechten_dlcovvprdedt

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

 

chk_ovrechten_dlcovvprdins

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

 

chk_ovrechten_dlcovvproahn

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

 

chk_ovrechten_dlcovvprodel

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

 

chk_ovrechten_dlcovvproedt

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

 

chk_ovrechten_dlcovvproins

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

 

chk_ovrechten_dlcovvprovdg

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

 

chk_ovrechten_dlcovvprovsb

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

 

chk_ovrechten_dlcovvuurdel

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

 

chk_ovrechten_dlcovvuuredt

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

 

chk_ovrechten_dlcovvuurins

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

 

chk_ovrechten_dlcovvuurvsb

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

 

chk_ovrechten_ovvadvdatedt

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

 

chk_ovrechten_welstdel

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

 

chk_ovrechten_welstedt

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

 

chk_ovrechten_welstins

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

 

chk_ovrechten_welsttabedt

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

 

chk_ovrechten_welsttabvsb

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

 

chk_ovrechten_welstvsb

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

 

chk_tbovrechten_dlbovvhlink

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

 

chk_tbovrechten_dlcovvadvdms

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

 

chk_tbovrechten_dlcovvinsdms

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

 

cnn_ovrecht_dlcovvcordocdel

dlcovvcordocdel IS NOT NULL

 

cnn_ovrecht_dlcovvcorregdwl

dlcovvcorregdwl IS NOT NULL

 

cnn_ovrecht_dlcovvcorregtent

dlcovvcorregtent IS NOT NULL

 

cnn_ovrecht_dlcovvcorregvsb

dlcovvcorregvsb IS NOT NULL

 

cnn_ovrechten_dlbovvafsedt

dlbovvafsedt IS NOT NULL

 

cnn_ovrechten_dlbovvwznedt

dlbovvwznedt IS NOT NULL

 

cnn_ovrechten_dlbovvztedt

dlbovvztedt IS NOT NULL

 

cnn_ovrechten_dlcovvadvuurvsb

dlcovvadvuurvsb IS NOT NULL

 

cnn_ovrechten_dlcovvbezwdel

dlcovvbezwdel IS NOT NULL

 

cnn_ovrechten_dlcovvbezwdms

dlcovvbezwdms IS NOT NULL

 

cnn_ovrechten_dlcovvbezwedt

dlcovvbezwedt IS NOT NULL

 

cnn_ovrechten_dlcovvbezwins

dlcovvbezwins IS NOT NULL

 

cnn_ovrechten_dlcovvbezwuurvsb

dlcovvbezwuurvsb IS NOT NULL

 

cnn_ovrechten_dlcovvbezwvsb

dlcovvbezwvsb IS NOT NULL

 

cnn_ovrechten_dlcovvcordms

dlcovvcordms IS NOT NULL

 

cnn_ovrechten_dlcovvcorodt

dlcovvcorodt IS NOT NULL

 

cnn_ovrechten_dlcovvcorreghnm

dlcovvcorreghnm IS NOT NULL

 

cnn_ovrechten_dlcovvcorwmo

dlcovvcorwmo IS NOT NULL

 

cnn_ovrechten_dlcovvinsovbzdel

dlcovvinsovbzdel IS NOT NULL

 

cnn_ovrechten_dlcovvinsuurvsb

dlcovvinsuurvsb IS NOT NULL

 

cnn_ovrechten_dlcovvprddel

dlcovvprddel IS NOT NULL

 

cnn_ovrechten_dlcovvprdedt

dlcovvprdedt IS NOT NULL

 

cnn_ovrechten_dlcovvprdins

dlcovvprdins IS NOT NULL

 

cnn_ovrechten_dlcovvuurdel

dlcovvuurdel IS NOT NULL

 

cnn_ovrechten_dlcovvuuredt

dlcovvuuredt IS NOT NULL

 

cnn_ovrechten_dlcovvuurins

dlcovvuurins IS NOT NULL

 

cnn_ovrechten_dlcovvuurvsb

dlcovvuurvsb IS NOT NULL

 

cnn_ovrechten_dnkeyrechten

dnkeyrechten IS NOT NULL

 

cnn_tbovrechten_dlbovvhlink

dlbovvhlink IS NOT NULL

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbovrechten

btree

 

dnkey

 

idu_ovrechten_keyrechten

btree

 

dnkeyrechten

 

 

 

Triggers

There are no triggers for table tbovrechten

 

Rules

There are no rules for table tbovrechten

 

Policies

There are no policies for table tbovrechten

 

Referenced

There are no tables referenced by table tbovrechten

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.tbovrechten (
 dnkey SERIAL,
 dnkeyrechten INTEGER,
 dlbovvedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvins CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvblokkedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvverzledt CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvgroepedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvmemovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvverplaats CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvabedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvmemoedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvsnelins CHAR(1) DEFAULT 'T'::bpchar,
 dlbovvodedt CHAR(1) DEFAULT 'T'::bpchar,
 dlbovvkopie CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvibbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvibbedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvibbins CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvibbdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvprovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvproedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvproins CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvprodel CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvbspvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvbspedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvbspins CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvbspdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvadvvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvadvedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvadvins CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvadvdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvinsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvinsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvinsins CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvinsdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcorvsb CHAR(1) DEFAULT 'T'::bpchar,
 dlcovvcoredt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcorins CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcordel CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcadvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcadins CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcaddel CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvlegvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvlegedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvlegins CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvlegdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvlogvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvlogedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvlogins CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvlogdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcinvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcinins CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcindel CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcompr CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvproahn CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvprovdg CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvadvinedt CHAR(1) DEFAULT 'T'::bpchar,
 dlcovvlegexpnot CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvadvdatedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvwelstandvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvwelstandedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvwelstanddel CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvwelstandins CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvwelsttabvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvwelsttabedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvmdedt CHAR(1) DEFAULT 'T'::bpchar,
 dlcovvcordms CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcorodt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvinsdms CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvadvdms CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvhlink CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvbezwvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvbezwedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvbezwins CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvbezwdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvbezwdms CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvuurins CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvuurdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvuuredt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvinsuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvbezwuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvadvuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvafsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcorregvsb CHAR(1) DEFAULT 'T'::bpchar,
 dlcovvcorregdwl CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcordocdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcorwmo CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcorreghnm CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvprdedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvinsovbzdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvprdins CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvprddel CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvwznedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbovvztedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcovvcorregtent CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tbovrechten PRIMARY KEY(dnkey),
 CONSTRAINT chk_ovrecht_dlcovvcordocdel CHECK (dlcovvcordocdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrecht_dlcovvcorregdwl CHECK (dlcovvcorregdwl = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrecht_dlcovvcorregtent CHECK (dlcovvcorregtent = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrecht_dlcovvcorregvsb CHECK (dlcovvcorregvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvabedt CHECK (dlbovvabedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvafsedt CHECK (dlbovvafsedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvblokkedt CHECK (dlbovvblokkedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvdel CHECK (dlbovvdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvedt CHECK (dlbovvedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvgroepedt CHECK (dlbovvgroepedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvins CHECK (dlbovvins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvkopie CHECK (dlbovvkopie = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvmdedt CHECK (dlbovvmdedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvmemoedt CHECK (dlbovvmemoedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvmemovsb CHECK (dlbovvmemovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvodedt CHECK (dlbovvodedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvsnelins CHECK (dlbovvsnelins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvverplaats CHECK (dlbovvverplaats = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvverzledt CHECK (dlbovvverzledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvwznedt CHECK (dlbovvwznedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlbovvztedt CHECK (dlbovvztedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvadvdel CHECK (dlcovvadvdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvadvedt CHECK (dlcovvadvedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvadvinedt CHECK (dlcovvadvinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvadvins CHECK (dlcovvadvins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvadvuurvsb CHECK (dlcovvadvuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvadvvsb CHECK (dlcovvadvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvbezwdel CHECK (dlcovvbezwdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvbezwdms CHECK (dlcovvbezwdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvbezwedt CHECK (dlcovvbezwedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvbezwins CHECK (dlcovvbezwins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvbezwuurvsb CHECK (dlcovvbezwuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvbezwvsb CHECK (dlcovvbezwvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvbspdel CHECK (dlcovvbspdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvbspedt CHECK (dlcovvbspedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvbspins CHECK (dlcovvbspins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvbspvsb CHECK (dlcovvbspvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvcaddel CHECK (dlcovvcaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvcadins CHECK (dlcovvcadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvcadvsb CHECK (dlcovvcadvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvcindel CHECK (dlcovvcindel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvcinedt CHECK (dlcovvcinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvcinins CHECK (dlcovvcinins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvcinvsb CHECK (dlcovvcinvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvcompr CHECK (dlcovvcompr = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvcordel CHECK (dlcovvcordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvcordms CHECK (dlcovvcordms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvcoredt CHECK (dlcovvcoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvcorins CHECK (dlcovvcorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvcorodt CHECK (dlcovvcorodt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvcorreghnm CHECK (dlcovvcorreghnm = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvcorvsb CHECK (dlcovvcorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvcorwmo CHECK (dlcovvcorwmo = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvibbdel CHECK (dlcovvibbdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvibbedt CHECK (dlcovvibbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvibbins CHECK (dlcovvibbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvibbvsb CHECK (dlcovvibbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvinsdel CHECK (dlcovvinsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvinsedt CHECK (dlcovvinsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvinsins CHECK (dlcovvinsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvinsovbzdel CHECK (dlcovvinsovbzdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvinsuurvsb CHECK (dlcovvinsuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvinsvsb CHECK (dlcovvinsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvlegdel CHECK (dlcovvlegdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvlegedt CHECK (dlcovvlegedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvlegexpnot CHECK (dlcovvlegexpnot = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvlegins CHECK (dlcovvlegins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvlegvsb CHECK (dlcovvlegvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvlogdel CHECK (dlcovvlogdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvlogedt CHECK (dlcovvlogedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvlogins CHECK (dlcovvlogins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvlogvsb CHECK (dlcovvlogvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvprddel CHECK (dlcovvprddel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvprdedt CHECK (dlcovvprdedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvprdins CHECK (dlcovvprdins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvproahn CHECK (dlcovvproahn = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvprodel CHECK (dlcovvprodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvproedt CHECK (dlcovvproedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvproins CHECK (dlcovvproins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvprovdg CHECK (dlcovvprovdg = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvprovsb CHECK (dlcovvprovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvuurdel CHECK (dlcovvuurdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvuuredt CHECK (dlcovvuuredt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvuurins CHECK (dlcovvuurins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_dlcovvuurvsb CHECK (dlcovvuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_ovrechten_ovvadvdatedt CHECK (dlcovvadvdatedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_welstdel CHECK (dlcovvwelstanddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_welstedt CHECK (dlcovvwelstandedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_welstins CHECK (dlcovvwelstandins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_welsttabedt CHECK (dlbovvwelsttabedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_welsttabvsb CHECK (dlbovvwelsttabvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_ovrechten_welstvsb CHECK (dlcovvwelstandvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbovrechten_dlbovvhlink CHECK (dlbovvhlink = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbovrechten_dlcovvadvdms CHECK (dlcovvadvdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbovrechten_dlcovvinsdms CHECK (dlcovvinsdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT cnn_ovrecht_dlcovvcordocdel CHECK (dlcovvcordocdel IS NOT NULL),
 CONSTRAINT cnn_ovrecht_dlcovvcorregdwl CHECK (dlcovvcorregdwl IS NOT NULL),
 CONSTRAINT cnn_ovrecht_dlcovvcorregtent CHECK (dlcovvcorregtent IS NOT NULL),
 CONSTRAINT cnn_ovrecht_dlcovvcorregvsb CHECK (dlcovvcorregvsb IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlbovvafsedt CHECK (dlbovvafsedt IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlbovvwznedt CHECK (dlbovvwznedt IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlbovvztedt CHECK (dlbovvztedt IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvadvuurvsb CHECK (dlcovvadvuurvsb IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvbezwdel CHECK (dlcovvbezwdel IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvbezwdms CHECK (dlcovvbezwdms IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvbezwedt CHECK (dlcovvbezwedt IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvbezwins CHECK (dlcovvbezwins IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvbezwuurvsb CHECK (dlcovvbezwuurvsb IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvbezwvsb CHECK (dlcovvbezwvsb IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvcordms CHECK (dlcovvcordms IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvcorodt CHECK (dlcovvcorodt IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvcorreghnm CHECK (dlcovvcorreghnm IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvcorwmo CHECK (dlcovvcorwmo IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvinsovbzdel CHECK (dlcovvinsovbzdel IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvinsuurvsb CHECK (dlcovvinsuurvsb IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvprddel CHECK (dlcovvprddel IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvprdedt CHECK (dlcovvprdedt IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvprdins CHECK (dlcovvprdins IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvuurdel CHECK (dlcovvuurdel IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvuuredt CHECK (dlcovvuuredt IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvuurins CHECK (dlcovvuurins IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvuurvsb CHECK (dlcovvuurvsb IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dnkeyrechten CHECK (dnkeyrechten IS NOT NULL),
 CONSTRAINT cnn_tbovrechten_dlbovvhlink CHECK (dlbovvhlink IS NOT NULL),
 CONSTRAINT cfk_ovrechten_keyrechten FOREIGN KEY (dnkeyrechten)
   REFERENCES public.tbrechten(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) ;

COMMENT ON TABLE public.tbovrechten
IS 'Rechtentabel voor de module overige vergunningen';

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

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

COMMENT ON COLUMN public.tbovrechten.dlbovvedt
IS 'Niveau BOvVerg Wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlbovvins
IS 'Niveau BOvVerg Nieuwrecht (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlbovvdel
IS 'Niveau BOvVerg Verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlbovvblokkedt
IS 'Niveau BOvVerg Verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlbovvverzledt
IS 'Niveau BOvVerg Verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlbovvgroepedt
IS 'Niveau B OvVerg (T of F) Groepvergunnigen maken.';

COMMENT ON COLUMN public.tbovrechten.dlbovvmemovsb
IS 'Niveau B OvVerg Memo zichtbaar (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlbovvverplaats
IS 'Niveau BOvVerg Verplaatsrecht.';

COMMENT ON COLUMN public.tbovrechten.dlbovvabedt
IS 'Niveau B. Overige vergunningen Aard Besluit wijzigen.';

COMMENT ON COLUMN public.tbovrechten.dlbovvmemoedt
IS 'Niveau B. Overige vergunningen. Memo wijzigen.';

COMMENT ON COLUMN public.tbovrechten.dlbovvsnelins
IS 'Niveau B. Overige vergunningen. Mag externe zaaknummers wijzigen (dvdmszaakcode, dvintzaakcode, dvzaaknrbevgezag) (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlbovvodedt
IS 'Niveau B. Overige vergunningen. Mag ontvangsdatum wijzigen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlbovvkopie
IS 'Niveau B Overige vergunningen. Kopieerrecht.';

COMMENT ON COLUMN public.tbovrechten.dlcovvibbvsb
IS 'Niveau C Ovvergunning Ibb zichtbaar (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvibbedt
IS 'Niveau C Ovvergunning Ibb wijzigen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvibbins
IS 'Niveau C Ovvergunning Ibb nieuw (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvibbdel
IS 'Niet meer in gebruik.';

COMMENT ON COLUMN public.tbovrechten.dlcovvprovsb
IS 'Niveau C Ovvergunning Procedures zichtbaar (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvproedt
IS 'Niveau C Ovvergunning Procedures zichtbaar (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvproins
IS 'Niveau C Ovvergunning Procedures nieuw (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvprodel
IS 'Niveau C Ovvergunning Procedures verwijderen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvbspvsb
IS 'Niveau C Ovvergunning Bestemmingsplannen (afw en vrijst) zichtbaar (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvbspedt
IS 'Niveau C Ovvergunning Bestemmingsplannen (afw en vrijst) wijzigen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvbspins
IS 'Niveau C Ovvergunning Bestemminghsplannen (afw en vrijst) nieuw (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvbspdel
IS 'Niveau C Ovvvergunning Bestemmingsplan (afw en vrijst) verwijderen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvadvvsb
IS 'Niveau C Ovvergunning Adviezen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvadvedt
IS 'Niveau C Ovvergunning Adviezen wijzigen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvadvins
IS 'Niveau C Ovvergunning Adviezen nieuw (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvadvdel
IS 'Niveau C Ovvergunning Adviezen verwijderen  (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvinsvsb
IS 'Niveau C Ovvergunning Inspecties zichtbaar (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvinsedt
IS 'Niveau C Ovvergunning Inspecties wijzigen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvinsins
IS 'Niveau C Ovvergunning Inspecties nieuw (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvinsdel
IS 'Niveau C Ovvergunning Inspecties verwijderrecht (trajecten, overtredingen en bezoeken) (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvcorvsb
IS 'Niveau C Ovvergunning alle correspondentie zichtbaar (T of F). default T';

COMMENT ON COLUMN public.tbovrechten.dlcovvcoredt
IS 'Niveau C Ovvergunning correspondentie Registreren van doucmenten en geregistreerde correspondentie wijzigen metadata(T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvcorins
IS 'Niveau C Ovvergunning correspondentie creeren en uploaden document (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvcordel
IS 'Niveau C Ovvergunning correspondentie geregisteerde correspondentie verwijderen metadata(T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvcadvsb
IS 'Niveau C Ovvergunning contactadressen zichtbaar (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvcadins
IS 'Niveau C Ovvergunning contactadressen koppeling maken (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvcaddel
IS 'Niveau C Ovvergunning contactadressen koppeling verwijderen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvlegvsb
IS 'Niveau C Ovvergunning Leges zichtbaar (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvlegedt
IS 'Niveau C Ovvergunning Leges wijzigen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvlegins
IS 'Niveau C Ovvergunning Leges nieuw (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvlegdel
IS 'Niveau C Ovvergunning Leges verwijderen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvlogvsb
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbovrechten.dlcovvlogedt
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbovrechten.dlcovvlogins
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbovrechten.dlcovvlogdel
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbovrechten.dlcovvcinvsb
IS 'Niveau C Overige vergunningen Correspondentie Binnen Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvcinedt
IS 'Niveau C Overige vergunningen Correspondentie Binnen Wijzigen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvcinins
IS 'Niveau C Overige vergunningen Correspondentie Binnen Nieuw (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvcindel
IS 'Niveau C Overige vergunningen Correspondentie Binnen Verwijderen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvcompr
IS '(Niveau C Overige vergunningen Compressie Termijnbewaking). Wordt niet gebruikt.';

COMMENT ON COLUMN public.tbovrechten.dlcovvproahn
IS 'Niveau C Ovvergunning Procedures aanhouden en termijn van orde (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvprovdg
IS 'Niveau C OvVergunning Procedures verdagen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvadvinedt
IS '(Niveau C Overige vergunningen Compressie Termijnbewaking.) Wordt niet gebruikt.';

COMMENT ON COLUMN public.tbovrechten.dlcovvlegexpnot
IS 'Niveau C. Overig vergunningen Leges Notanummer en Exportdatum muteerbaar.';

COMMENT ON COLUMN public.tbovrechten.dlcovvadvdatedt
IS 'Niveau C. Adviezen. Wijzigrecht kolom DdDateringadvies van tabel TbAdviezen bij ov-verguningen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvwelstandvsb
IS 'Niveau C. kolommen op subtabblad Welstandadviezen bij adviezen. Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvwelstandedt
IS 'Niveau C. kolommen op subtabblad Welstandadviezen bij adviezen muteerbaar (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvwelstanddel
IS 'Niveau C. kolommen op subtabblad Welstandadviezen bij adviezen verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvwelstandins
IS 'Niveau C. kolommen op subtabblad Welstandadviezen bij adviezen. Nieuw maken (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlbovvwelsttabvsb
IS 'Niveau B. tabblad van detailscherm met de welstandskolommen van Tbovverg. Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlbovvwelsttabedt
IS 'Niveau B.tabblad van detailscherm met de welstandskolommen van Tbovverg. Muteerbaar (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlbovvmdedt
IS 'Niveau B. Overige vergunningen. Meetdatum en herberekenen termijnbewaking recht.';

COMMENT ON COLUMN public.tbovrechten.dlcovvcordms
IS 'Niveau C. APV/Overig. Correspondentie. DMS-kolom muteerbaar';

COMMENT ON COLUMN public.tbovrechten.dlcovvcorodt
IS 'Niveau C. APV/Overig. Correspondentie. Opgeslagen document-kolom muteerbaar.';

COMMENT ON COLUMN public.tbovrechten.dlcovvinsdms
IS 'Niveau C.APV/Overig. Inspecties. Mag externe zaakcode van Inspectie muteren (dvdmszaakcode, dvintzaakcode)(T of F). ';

COMMENT ON COLUMN public.tbovrechten.dlcovvadvdms
IS 'Niveau C. APV/Overig. Adviezen. Mag externe zaakcode van Advies muteren (dvdmszaakcode, dvintzaakcode)(T of F). ';

COMMENT ON COLUMN public.tbovrechten.dlbovvhlink
IS 'Niveau B. APV/Overig. Mag hyperlink starten vanuit powerportal apvoverigdetail.';

COMMENT ON COLUMN public.tbovrechten.dlcovvbezwvsb
IS 'Niveau C. APV/Overig.. Bezwaar/beroep inzien (T of F)';

COMMENT ON COLUMN public.tbovrechten.dlcovvbezwedt
IS 'Niveau C. APV/Overig.. Bezwaar/beroep wijzgen (T of F)';

COMMENT ON COLUMN public.tbovrechten.dlcovvbezwins
IS 'Niveau C. APV/Overig. Bezwaar/beroep insert (T of F)';

COMMENT ON COLUMN public.tbovrechten.dlcovvbezwdel
IS 'Niveau C. APV/Overig.. Bezwaar/beroep delete (T of F)';

COMMENT ON COLUMN public.tbovrechten.dlcovvbezwdms
IS 'Niveau C. APV/Overig.. Bezwaar/beroep. dmscode (extern zaakidentificatie) muteren (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvuurvsb
IS 'Niveau C. APV/Overig... uren inzien (T of F)';

COMMENT ON COLUMN public.tbovrechten.dlcovvuurins
IS 'Niveau C. APV/Overig... uren insert (T of F)';

COMMENT ON COLUMN public.tbovrechten.dlcovvuurdel
IS 'Niveau C. APV/Overig... uren delete (T of F)';

COMMENT ON COLUMN public.tbovrechten.dlcovvuuredt
IS 'Niveau C. APV/Overig... uren wijzgen (T of F)';

COMMENT ON COLUMN public.tbovrechten.dlcovvinsuurvsb
IS 'Niveau C. inspecties bij APV/Overig... uren inzien (T of F), edit- insert- delrechten via dlcovvuuredt, dlcovvuurins,dlcovvuurdel';

COMMENT ON COLUMN public.tbovrechten.dlcovvbezwuurvsb
IS 'Niveau C. bezwaar/beroep bij APV/Overig... uren inzien (T of F), edit- insert- delrechten via dlcovvuuredt, dlcovvuurins,dlcovvuurdel';

COMMENT ON COLUMN public.tbovrechten.dlcovvadvuurvsb
IS 'Niveau C. adviezen bij APV/Overig... uren inzien (T of F), edit- insert- delrechten via dlcovvuuredt, dlcovvuurins,dlcovvuurdel';

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

COMMENT ON COLUMN public.tbovrechten.dlcovvcorregvsb
IS 'Niveau C APV/Overig Geregistreerde documenten zichtbaar (T of F) Default T';

COMMENT ON COLUMN public.tbovrechten.dlcovvcorregdwl
IS 'Niveau C APV/Overig Geregistreerde documenten Mag geforceerd downloaden (T of F) Default F';

COMMENT ON COLUMN public.tbovrechten.dlcovvcordocdel
IS 'Niveau C APV/Overig geregisteerde correspondentie verwijderen fysiek document(T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvcorwmo
IS 'Niveau C APV/Overig Wijzigen metadata (hernoemen filenaam) ongeregistreerde documenten (T of F)';

COMMENT ON COLUMN public.tbovrechten.dlcovvcorreghnm
IS 'Niveau C APV/Overig Hernoemen geregistreerde documenten';

COMMENT ON COLUMN public.tbovrechten.dlcovvprdedt
IS 'Niveau C Overige vergunningen. Product/Dienst wijzigen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvinsovbzdel
IS 'Niveau C APV/Overig. Alleen inspectiebezoeken en overtredingen verwijderen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvprdins
IS 'Niveau C Overige vergunningen. Product/Dienst toevoegen(T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvprddel
IS 'Niveau C Overige vergunningen. Product/Dienst verwijderen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlbovvwznedt
IS 'Niveau B. Overige vergunningen. Mag Wavezaakcode (dvvergunningsnr) wijzigen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlbovvztedt
IS 'Niveau B. Overige vergunningen. Mag soort vergunning wijzigen (T of F).';

COMMENT ON COLUMN public.tbovrechten.dlcovvcorregtent
IS 'Niveau C. APV/Overig... wijzigrecht (externe) tbcorrespondentie.dvexttracktrace';

CREATE UNIQUE INDEX idu_ovrechten_keyrechten ON public.tbovrechten
 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