Datadictionary OpenWave 3.1.11
 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. Wavezaakcode (dvvergunningsnr),Ontvangsdatum en soort vergunning wijzigbaar. 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 verwijderen (T of F).

 

 

dlcovvcorvsb

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning correspondentie zichtbaar (T of F).

 

 

dlcovvcoredt

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning correspondentie wijzigen (T of F).

 

 

dlcovvcorins

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning correspondentie nieuw (T of F).

 

 

dlcovvcordel

char(1)

 

 

 

'F'::bpchar

Niveau C Ovvergunning correspondentie verwijderen (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. Overige vergunningen. Correspondentie. DMS-kolom muteerbaar

 

 

dlcovvcorodt

char(1)

 

 

 

'F'::bpchar

Niveau C. Overige vergunningen. Correspondentie. Opgeslagen document-kolom muteerbaar.

 

 

dlcovvinsdms

char(1)

 

 

 

'F'::bpchar

Niveau C. Overige vergunningen. Inspecties. Mag externe zaakcode van Inspectie muteren (dvdmszaakcode, dvintzaakcode)(T of F).

 

 

dlcovvadvdms

char(1)

 

 

 

'F'::bpchar

Niveau C. Overige vergunningen. Adviezen. Mag externe zaakcode van Advies muteren (dvdmszaakcode, dvintzaakcode)(T of F).

 

 

dlbovvhlink

char(1)

 

 

 

'F'::bpchar

Niveau B. Overige vergunningen. Mag hyperlink starten vanuit powerportal apvoverigdetail.

 

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_ovrechten_dlbovvabedt

dlbovvabedt = ANY (ARRAY['T'::bpchar, 'F'::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_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_dlcovvadvvsb

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

dlcovvcorvsb = 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_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_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_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_ovrechten_dlcovvcordms

dlcovvcordms IS NOT NULL

 

cnn_ovrechten_dlcovvcorodt

dlcovvcorodt 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

 

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 'F'::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,
 CONSTRAINT cpk_tbovrechten PRIMARY KEY(dnkey),
 CONSTRAINT chk_ovrechten_dlbovvabedt CHECK (dlbovvabedt = ANY (ARRAY['T'::bpchar, 'F'::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_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_dlcovvadvvsb CHECK (dlcovvadvvsb = ANY (ARRAY['T'::bpchar, 'F'::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_dlcovvcorvsb CHECK (dlcovvcorvsb = 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_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_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_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_ovrechten_dlcovvcordms CHECK (dlcovvcordms IS NOT NULL),
 CONSTRAINT cnn_ovrechten_dlcovvcorodt CHECK (dlcovvcorodt 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
)
WITH (oids = false);

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. Wavezaakcode (dvvergunningsnr),Ontvangsdatum en soort vergunning wijzigbaar. 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 verwijderen (T of F).';

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

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

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

COMMENT ON COLUMN public.tbovrechten.dlcovvcordel
IS 'Niveau C Ovvergunning correspondentie verwijderen (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. Overige vergunningen. Correspondentie. DMS-kolom muteerbaar';

COMMENT ON COLUMN public.tbovrechten.dlcovvcorodt
IS 'Niveau C. Overige vergunningen. Correspondentie. Opgeslagen document-kolom muteerbaar.';

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

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

COMMENT ON COLUMN public.tbovrechten.dlbovvhlink
IS 'Niveau B. Overige vergunningen. Mag hyperlink starten vanuit powerportal apvoverigdetail.';

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 22-2-2017 10:50
 Previous topic Chapter index Next topic