Datadictionary OpenWave 3.1.25
 Previous topic Chapter index Next topic

Table: tbinforechten

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Rechtentabel voor de module info-aanvragen

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbinforechten_dnkey_seq'::regclass)

Primary Key.

 

dnkeyrechten

integer

 

 

 

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

 

 

dlbinfoedt

char(1)

 

 

 

'F'::bpchar

Niveau B. InfoModule. Editscherm wijzigbaar.

 

 

dlbinfoins

char(1)

 

 

 

'F'::bpchar

Niveau B. InfoModule. Editscherm InsertRecht.

 

 

dlbinfodel

char(1)

 

 

 

'F'::bpchar

Niveau B. InfoModule. Editscherm Verwijderecht.

 

 

dlbinfoblokkedt

char(1)

 

 

 

'F'::bpchar

Niveau B. InfoModule. Editscherm Blokkeerecht.

 

 

dlbinfokopie

char(1)

 

 

 

'F'::bpchar

Niveau B. InfoModule. Editscherm Kopieerrecht.

 

 

dlbinfoverplaats

char(1)

 

 

 

'F'::bpchar

Niveau B. InfoModule. Editscherm verplaatsrecht.

 

 

dlcinfoibbvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. In behandeling Bij zichtbaar.

 

 

dlcinfoibbedt

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. In behandeling Bij muteerbaar.

 

 

dlcinfoibbins

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. In behandeling Bij Insertrecht.

 

 

dlcinfoibbdel

char(1)

 

 

 

'F'::bpchar

Niet meer in gebruik.

 

 

dlcinfoadvvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Adviezen zichtbaar.

 

 

dlcinfoadvedt

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Adviezen muteerrecht.

 

 

dlcinfoadvins

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Adviezen Insertrecht.

 

 

dlcinfoadvdel

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Adviezen verwijderrecht.

 

 

dlcinfocadvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Contactadressen zichtbaar.

 

 

dlcinfocadins

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Contactadressen Insertrecht.

 

 

dlcinfocaddel

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Contactadressen ontkoppelrecht.

 

 

dlcinfocorvsb

char(1)

 

 

 

'T'::bpchar

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

 

 

dlcinfocoredt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcinfocorins

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Correspondentie creeren en uploaden van documenten.

 

 

dlcinfocordel

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcinfocinvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Correspondentie binnenkomend zichtbaar.

 

 

dlcinfocinedt

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Correspondentie binnenkomend muteerrecht.

 

 

dlcinfocinins

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Correspondentie binnenkomend Insertrecht.

 

 

dlcinfocindel

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Correspondentie binnenkomend verwijderrecht.

 

 

dlcinfologvsb

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlcinfologedt

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlcinfologins

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlcinfologdel

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlcinfolegvsb

char(1)

 

 

 

'F'::bpchar

Niveau C InfoModule Leges zichtbaar (T of F).

 

 

dlcinfolegedt

char(1)

 

 

 

'F'::bpchar

Niveau C InfoModule Leges wijzigen (T of F).

 

 

dlcinfolegins

char(1)

 

 

 

'F'::bpchar

Niveau C InfoModule Leges nieuw (T of F).

 

 

dlcinfolegdel

char(1)

 

 

 

'F'::bpchar

Niveau C InfoModule Leges verwijderen (T of F).

 

 

dlcinfoprovsb

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Procedures zichtbaar.

 

 

dlcinfoproedt

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Procedures muteerbaar.

 

 

dlcinfoproins

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Procedures Insertrecht.

 

 

dlcinfoprodel

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Procedures verwijderrecht.

 

 

dlcinfoproahn

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Procedures aanhouden en termijn van orde.

 

 

dlcinfoprovdg

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Procedures Verdagen.

 

 

dlcinfotrwvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Trefwoord zichtbaar.

 

 

dlcinfotrwedt

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Trefwoord muteerrecht.

 

 

dlcinfotrwins

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Trefwoord Insertrecht.

 

 

dlcinfotrwdel

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. TrefwoordVerwijderrecht.

 

 

dlbinfogroepedt

char(1)

 

 

 

'F'::bpchar

Niveau B Infomodule Groepvergunnigen maken (T of F).

 

 

dlbinfoverzledt

char(1)

 

 

 

'F'::bpchar

Niveau B InfoModule verzendlijst maken (T of F).

 

 

dlbinfomemovsb

char(1)

 

 

 

'F'::bpchar

Niveau B. InfoModule. Editscherm Memo zichtbaar.

 

 

dlbinfomemoedt

char(1)

 

 

 

'F'::bpchar

Niveau B. InfoModule. Memo wijzigen.

 

 

dlcinfoadvinedt

char(1)

 

 

 

'F'::bpchar

Niveau C InfoModule. Adviezen. Mag kolom Adviesinstantie wijzigen.

 

 

dlcinfolegexpnot

char(1)

 

 

 

'F'::bpchar

Niveau C. Infomodule Leges Notanummer en Exportdatum muteerbaar.

 

 

dlbinfoadedt

char(1)

 

 

 

'F'::bpchar

Niveau B. InfoModule. Mag startdatum wijzigen (T of F).

 

 

dlcinfadvdatedt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcinfocordms

char(1)

 

 

 

'F'::bpchar

Niveau C. Infomodule. Correspondentie. DMS-kolom muteerbaar

 

 

dlcinfocorodt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlbinfosnelins

char(1)

 

 

 

'T'::bpchar

Niveau B. Infomodule. Mag dvdmscode wijzigen.

 

 

dlcinfoadvdms

char(1)

 

 

 

'F'::bpchar

Niveau C. Infomodule. Adviezen. Dmscode muteren (T of F).

 

 

dlbinfohlink

char(1)

 

 

 

'F'::bpchar

Niveau B. Infomodule. Mag hyperlink starten vanuit powerportal infodetail.

 

 

dlcinfouurvsb

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcinfouurins

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcinfouurdel

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcinfouuredt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcinfoadvuurvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. adviezen bij Infomodule... uren inzien (T of F), edit- insert- delrechten via dlcinfouuredt, dlcinfouurins,dlcinfouurdel

 

 

dlbinfoafsedt

char(1)

 

 

 

'F'::bpchar

Niveau B Infomodule gevulde afhandeldatum wijzgen en dit geldt ook voor gevulde externe zaak einddatum (dddmsafgehandeld) bij deelzaak advies die aan info zijn gekoppeld(T of F)

 

 

dlcinfocorregvsb

char(1)

 

 

 

'T'::bpchar

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

 

 

dlcinfocorregdwl

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcinfocordocdel

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcinfocorwmo

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcinfocorreghnm

char(1)

 

 

 

'F'::bpchar

Niveau C Info Hernoemen geregistreerde documenten

 

 

dlcinfoprdedt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcinfoprdins

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcinfoprddel

char(1)

 

 

 

'F'::bpchar

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

 

 

dlbinfowznedt

char(1)

 

 

 

'F'::bpchar

Niveau B. InfoModule. Mag Openwave zaaknummer wijzigen (T of F).

 

 

dlbinfoztedt

char(1)

 

 

 

'F'::bpchar

Niveau B. InfoModule. Mag zaaktype wijzigen (T of F).

 

 

dlcinfocorregtent

char(1)

 

 

 

'F'::bpchar

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

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

cfk_inforechten_keyrechten

dnkeyrechten

public.tbrechten

dnkey

Cascade

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

chk_inforecht_dlbinfoadedt

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

 

chk_inforecht_dlbinfoafsedt

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

 

chk_inforecht_dlbinfoblokkedt

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

 

chk_inforecht_dlbinfodel

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

 

chk_inforecht_dlbinfoedt

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

 

chk_inforecht_dlbinfogroepedt

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

 

chk_inforecht_dlbinfoins

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

 

chk_inforecht_dlbinfokopie

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

 

chk_inforecht_dlbinfomemoedt

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

 

chk_inforecht_dlbinfomemovsb

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

 

chk_inforecht_dlbinfoverplaats

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

 

chk_inforecht_dlbinfoverzledt

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

 

chk_inforecht_dlcinfoadvdel

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

 

chk_inforecht_dlcinfoadvedt

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

 

chk_inforecht_dlcinfoadvinedt

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

 

chk_inforecht_dlcinfoadvins

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

 

chk_inforecht_dlcinfoadvvsb

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

 

chk_inforecht_dlcinfocaddel

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

 

chk_inforecht_dlcinfocadins

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

 

chk_inforecht_dlcinfocadvsb

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

 

chk_inforecht_dlcinfocindel

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

 

chk_inforecht_dlcinfocinedt

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

 

chk_inforecht_dlcinfocinins

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

 

chk_inforecht_dlcinfocinvsb

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

 

chk_inforecht_dlcinfocordel

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

 

chk_inforecht_dlcinfocordocdel

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

 

chk_inforecht_dlcinfocoredt

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

 

chk_inforecht_dlcinfocorins

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

 

chk_inforecht_dlcinfocorregdwl

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

 

chk_inforecht_dlcinfocorregtent

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

 

chk_inforecht_dlcinfocorregvsb

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

 

chk_inforecht_dlcinfocorvsb

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

 

chk_inforecht_dlcinfoibbdel

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

 

chk_inforecht_dlcinfoibbedt

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

 

chk_inforecht_dlcinfoibbins

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

 

chk_inforecht_dlcinfoibbvsb

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

 

chk_inforecht_dlcinfolegdel

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

 

chk_inforecht_dlcinfolegedt

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

 

chk_inforecht_dlcinfolegexpnot

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

 

chk_inforecht_dlcinfolegins

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

 

chk_inforecht_dlcinfolegvsb

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

 

chk_inforecht_dlcinfologdel

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

 

chk_inforecht_dlcinfologedt

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

 

chk_inforecht_dlcinfologins

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

 

chk_inforecht_dlcinfologvsb

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

 

chk_inforecht_dlcinfoproahn

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

 

chk_inforecht_dlcinfoprodel

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

 

chk_inforecht_dlcinfoproedt

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

 

chk_inforecht_dlcinfoproins

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

 

chk_inforecht_dlcinfoprovdg

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

 

chk_inforecht_dlcinfoprovsb

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

 

chk_inforecht_dlcinfotrwdel

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

 

chk_inforecht_dlcinfotrwedt

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

 

chk_inforecht_dlcinfotrwins

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

 

chk_inforecht_dlcinfotrwvsb

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

 

chk_inforechten_dlbinfohlink

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

 

chk_inforechten_dlbinfosnelins

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

 

chk_inforechten_dlbinfowznedt

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

 

chk_inforechten_dlbinfoztedt

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

 

chk_inforechten_dlcinfocordms

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

 

chk_inforechten_dlcinfocorodt

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

 

chk_inforechten_dlcinfocorwmo

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

 

chk_inforechten_dlcinfoprddel

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

 

chk_inforechten_dlcinfoprdedt

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

 

chk_inforechten_dlcinfoprdins

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

 

chk_infrechten_dlcinfadvuurvsb

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

 

chk_infrechten_dlcinfcorreghnm

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

 

chk_infrechten_dlcinfouurdel

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

 

chk_infrechten_dlcinfouuredt

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

 

chk_infrechten_dlcinfouurins

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

 

chk_infrechten_dlcinfouurvsb

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

 

chk_infrechten_infadvdatedt

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

 

chk_tbinfor_dlcinfoadvdms

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

 

cnn_inforecht_dlbinfoafsedt

dlbinfoafsedt IS NOT NULL

 

cnn_inforecht_dlcinfocordocdel

dlcinfocordocdel IS NOT NULL

 

cnn_inforecht_dlcinfocorregdwl

dlcinfocorregdwl IS NOT NULL

 

cnn_inforecht_dlcinfocorregtent

dlcinfocorregtent IS NOT NULL

 

cnn_inforecht_dlcinfocorregvsb

dlcinfocorregvsb IS NOT NULL

 

cnn_inforecht_keyrechten

dnkeyrechten IS NOT NULL

 

cnn_inforechten_dlbinfohlink

dlbinfohlink IS NOT NULL

 

cnn_inforechten_dlbinfosnelins

dlbinfosnelins IS NOT NULL

 

cnn_inforechten_dlbinfowznedt

dlbinfowznedt IS NOT NULL

 

cnn_inforechten_dlbinfoztedt

dlbinfoztedt IS NOT NULL

 

cnn_inforechten_dlcinfocordms

dlcinfocordms IS NOT NULL

 

cnn_inforechten_dlcinfocorodt

dlcinfocorodt IS NOT NULL

 

cnn_inforechten_dlcinfocorwmo

dlcinfocorwmo IS NOT NULL

 

cnn_inforechten_dlcinfoprddel

dlcinfoprddel IS NOT NULL

 

cnn_inforechten_dlcinfoprdedt

dlcinfoprdedt IS NOT NULL

 

cnn_inforechten_dlcinfoprdins

dlcinfoprdins IS NOT NULL

 

cnn_infrechten_dlcinfadvuurvsb

dlcinfoadvuurvsb IS NOT NULL

 

cnn_infrechten_dlcinfcorreghnm

dlcinfocorreghnm IS NOT NULL

 

cnn_infrechten_dlcinfouurdel

dlcinfouurdel IS NOT NULL

 

cnn_infrechten_dlcinfouuredt

dlcinfouuredt IS NOT NULL

 

cnn_infrechten_dlcinfouurins

dlcinfouurins IS NOT NULL

 

cnn_infrechten_dlcinfouurvsb

dlcinfouurvsb IS NOT NULL

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbinforechten

btree

 

dnkey

 

idu_inforechten_keyrechten

btree

 

dnkeyrechten

 

 

 

Triggers

There are no triggers for table tbinforechten

 

Rules

There are no rules for table tbinforechten

 

Policies

There are no policies for table tbinforechten

 

Referenced

There are no tables referenced by table tbinforechten

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.tbinforechten (
 dnkey SERIAL,
 dnkeyrechten INTEGER,
 dlbinfoedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbinfoins CHAR(1) DEFAULT 'F'::bpchar,
 dlbinfodel CHAR(1) DEFAULT 'F'::bpchar,
 dlbinfoblokkedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbinfokopie CHAR(1) DEFAULT 'F'::bpchar,
 dlbinfoverplaats CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoibbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoibbedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoibbins CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoibbdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoadvvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoadvedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoadvins CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoadvdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocadvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocadins CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocaddel CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocorvsb CHAR(1) DEFAULT 'T'::bpchar,
 dlcinfocoredt CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocorins CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocordel CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocinvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocinins CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocindel CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfologvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfologedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfologins CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfologdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfolegvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfolegedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfolegins CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfolegdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoprovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoproedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoproins CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoprodel CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoproahn CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoprovdg CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfotrwvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfotrwedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfotrwins CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfotrwdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbinfogroepedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbinfoverzledt CHAR(1) DEFAULT 'F'::bpchar,
 dlbinfomemovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbinfomemoedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoadvinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfolegexpnot CHAR(1) DEFAULT 'F'::bpchar,
 dlbinfoadedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfadvdatedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocordms CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocorodt CHAR(1) DEFAULT 'F'::bpchar,
 dlbinfosnelins CHAR(1) DEFAULT 'T'::bpchar,
 dlcinfoadvdms CHAR(1) DEFAULT 'F'::bpchar,
 dlbinfohlink CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfouurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfouurins CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfouurdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfouuredt CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoadvuurvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbinfoafsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocorregvsb CHAR(1) DEFAULT 'T'::bpchar,
 dlcinfocorregdwl CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocordocdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocorwmo CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocorreghnm CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoprdedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoprdins CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfoprddel CHAR(1) DEFAULT 'F'::bpchar,
 dlbinfowznedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbinfoztedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcinfocorregtent CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tbinforechten PRIMARY KEY(dnkey),
 CONSTRAINT chk_inforecht_dlbinfoadedt CHECK (dlbinfoadedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlbinfoafsedt CHECK (dlbinfoafsedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_inforecht_dlbinfoblokkedt CHECK (dlbinfoblokkedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlbinfodel CHECK (dlbinfodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlbinfoedt CHECK (dlbinfoedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlbinfogroepedt CHECK (dlbinfogroepedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlbinfoins CHECK (dlbinfoins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlbinfokopie CHECK (dlbinfokopie = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlbinfomemoedt CHECK (dlbinfomemoedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlbinfomemovsb CHECK (dlbinfomemovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlbinfoverplaats CHECK (dlbinfoverplaats = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlbinfoverzledt CHECK (dlbinfoverzledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfoadvdel CHECK (dlcinfoadvdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfoadvedt CHECK (dlcinfoadvedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfoadvinedt CHECK (dlcinfoadvinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfoadvins CHECK (dlcinfoadvins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfoadvvsb CHECK (dlcinfoadvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfocaddel CHECK (dlcinfocaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfocadins CHECK (dlcinfocadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfocadvsb CHECK (dlcinfocadvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfocindel CHECK (dlcinfocindel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfocinedt CHECK (dlcinfocinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfocinins CHECK (dlcinfocinins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfocinvsb CHECK (dlcinfocinvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfocordel CHECK (dlcinfocordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfocordocdel CHECK (dlcinfocordocdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfocoredt CHECK (dlcinfocoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfocorins CHECK (dlcinfocorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfocorregdwl CHECK (dlcinfocorregdwl = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfocorregtent CHECK (dlcinfocorregtent = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfocorregvsb CHECK (dlcinfocorregvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfocorvsb CHECK (dlcinfocorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfoibbdel CHECK (dlcinfoibbdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfoibbedt CHECK (dlcinfoibbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfoibbins CHECK (dlcinfoibbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfoibbvsb CHECK (dlcinfoibbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfolegdel CHECK (dlcinfolegdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfolegedt CHECK (dlcinfolegedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfolegexpnot CHECK (dlcinfolegexpnot = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfolegins CHECK (dlcinfolegins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfolegvsb CHECK (dlcinfolegvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfologdel CHECK (dlcinfologdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfologedt CHECK (dlcinfologedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfologins CHECK (dlcinfologins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfologvsb CHECK (dlcinfologvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfoproahn CHECK (dlcinfoproahn = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfoprodel CHECK (dlcinfoprodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfoproedt CHECK (dlcinfoproedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfoproins CHECK (dlcinfoproins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfoprovdg CHECK (dlcinfoprovdg = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfoprovsb CHECK (dlcinfoprovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfotrwdel CHECK (dlcinfotrwdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfotrwedt CHECK (dlcinfotrwedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfotrwins CHECK (dlcinfotrwins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfotrwvsb CHECK (dlcinfotrwvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforechten_dlbinfohlink CHECK (dlbinfohlink = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_inforechten_dlbinfosnelins CHECK (dlbinfosnelins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforechten_dlbinfowznedt CHECK (dlbinfowznedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_inforechten_dlbinfoztedt CHECK (dlbinfoztedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_inforechten_dlcinfocordms CHECK (dlcinfocordms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforechten_dlcinfocorodt CHECK (dlcinfocorodt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforechten_dlcinfocorwmo CHECK (dlcinfocorwmo = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforechten_dlcinfoprddel CHECK (dlcinfoprddel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_inforechten_dlcinfoprdedt CHECK (dlcinfoprdedt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_inforechten_dlcinfoprdins CHECK (dlcinfoprdins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_infrechten_dlcinfadvuurvsb CHECK (dlcinfoadvuurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_infrechten_dlcinfcorreghnm CHECK (dlcinfocorreghnm = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_infrechten_dlcinfouurdel CHECK (dlcinfouurdel = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_infrechten_dlcinfouuredt CHECK (dlcinfouuredt = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_infrechten_dlcinfouurins CHECK (dlcinfouurins = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_infrechten_dlcinfouurvsb CHECK (dlcinfouurvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_infrechten_infadvdatedt CHECK (dlcinfadvdatedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbinfor_dlcinfoadvdms CHECK (dlcinfoadvdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT cnn_inforecht_dlbinfoafsedt CHECK (dlbinfoafsedt IS NOT NULL),
 CONSTRAINT cnn_inforecht_dlcinfocordocdel CHECK (dlcinfocordocdel IS NOT NULL),
 CONSTRAINT cnn_inforecht_dlcinfocorregdwl CHECK (dlcinfocorregdwl IS NOT NULL),
 CONSTRAINT cnn_inforecht_dlcinfocorregtent CHECK (dlcinfocorregtent IS NOT NULL),
 CONSTRAINT cnn_inforecht_dlcinfocorregvsb CHECK (dlcinfocorregvsb IS NOT NULL),
 CONSTRAINT cnn_inforecht_keyrechten CHECK (dnkeyrechten IS NOT NULL),
 CONSTRAINT cnn_inforechten_dlbinfohlink CHECK (dlbinfohlink IS NOT NULL),
 CONSTRAINT cnn_inforechten_dlbinfosnelins CHECK (dlbinfosnelins IS NOT NULL),
 CONSTRAINT cnn_inforechten_dlbinfowznedt CHECK (dlbinfowznedt IS NOT NULL),
 CONSTRAINT cnn_inforechten_dlbinfoztedt CHECK (dlbinfoztedt IS NOT NULL),
 CONSTRAINT cnn_inforechten_dlcinfocordms CHECK (dlcinfocordms IS NOT NULL),
 CONSTRAINT cnn_inforechten_dlcinfocorodt CHECK (dlcinfocorodt IS NOT NULL),
 CONSTRAINT cnn_inforechten_dlcinfocorwmo CHECK (dlcinfocorwmo IS NOT NULL),
 CONSTRAINT cnn_inforechten_dlcinfoprddel CHECK (dlcinfoprddel IS NOT NULL),
 CONSTRAINT cnn_inforechten_dlcinfoprdedt CHECK (dlcinfoprdedt IS NOT NULL),
 CONSTRAINT cnn_inforechten_dlcinfoprdins CHECK (dlcinfoprdins IS NOT NULL),
 CONSTRAINT cnn_infrechten_dlcinfadvuurvsb CHECK (dlcinfoadvuurvsb IS NOT NULL),
 CONSTRAINT cnn_infrechten_dlcinfcorreghnm CHECK (dlcinfocorreghnm IS NOT NULL),
 CONSTRAINT cnn_infrechten_dlcinfouurdel CHECK (dlcinfouurdel IS NOT NULL),
 CONSTRAINT cnn_infrechten_dlcinfouuredt CHECK (dlcinfouuredt IS NOT NULL),
 CONSTRAINT cnn_infrechten_dlcinfouurins CHECK (dlcinfouurins IS NOT NULL),
 CONSTRAINT cnn_infrechten_dlcinfouurvsb CHECK (dlcinfouurvsb IS NOT NULL),
 CONSTRAINT cfk_inforechten_keyrechten FOREIGN KEY (dnkeyrechten)
   REFERENCES public.tbrechten(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) ;

COMMENT ON TABLE public.tbinforechten
IS 'Rechtentabel voor de module info-aanvragen';

COMMENT ON COLUMN public.tbinforechten.dnkey
IS 'Primary Key.';

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

COMMENT ON COLUMN public.tbinforechten.dlbinfoedt
IS 'Niveau B. InfoModule. Editscherm wijzigbaar.';

COMMENT ON COLUMN public.tbinforechten.dlbinfoins
IS 'Niveau B. InfoModule. Editscherm InsertRecht.';

COMMENT ON COLUMN public.tbinforechten.dlbinfodel
IS 'Niveau B. InfoModule. Editscherm Verwijderecht.';

COMMENT ON COLUMN public.tbinforechten.dlbinfoblokkedt
IS 'Niveau B. InfoModule. Editscherm Blokkeerecht.';

COMMENT ON COLUMN public.tbinforechten.dlbinfokopie
IS 'Niveau B. InfoModule. Editscherm Kopieerrecht.';

COMMENT ON COLUMN public.tbinforechten.dlbinfoverplaats
IS 'Niveau B. InfoModule. Editscherm verplaatsrecht.';

COMMENT ON COLUMN public.tbinforechten.dlcinfoibbvsb
IS 'Niveau C. InfoModule. In behandeling Bij zichtbaar.';

COMMENT ON COLUMN public.tbinforechten.dlcinfoibbedt
IS 'Niveau C. InfoModule. In behandeling Bij muteerbaar.';

COMMENT ON COLUMN public.tbinforechten.dlcinfoibbins
IS 'Niveau C. InfoModule. In behandeling Bij Insertrecht.';

COMMENT ON COLUMN public.tbinforechten.dlcinfoibbdel
IS 'Niet meer in gebruik.';

COMMENT ON COLUMN public.tbinforechten.dlcinfoadvvsb
IS 'Niveau C. InfoModule. Adviezen zichtbaar.';

COMMENT ON COLUMN public.tbinforechten.dlcinfoadvedt
IS 'Niveau C. InfoModule. Adviezen muteerrecht.';

COMMENT ON COLUMN public.tbinforechten.dlcinfoadvins
IS 'Niveau C. InfoModule. Adviezen Insertrecht.';

COMMENT ON COLUMN public.tbinforechten.dlcinfoadvdel
IS 'Niveau C. InfoModule. Adviezen verwijderrecht.';

COMMENT ON COLUMN public.tbinforechten.dlcinfocadvsb
IS 'Niveau C. InfoModule. Contactadressen zichtbaar.';

COMMENT ON COLUMN public.tbinforechten.dlcinfocadins
IS 'Niveau C. InfoModule. Contactadressen Insertrecht.';

COMMENT ON COLUMN public.tbinforechten.dlcinfocaddel
IS 'Niveau C. InfoModule. Contactadressen ontkoppelrecht.';

COMMENT ON COLUMN public.tbinforechten.dlcinfocorvsb
IS 'Niveau C. InfoModule. alle correspondentie zichtbaar (T of F). default T';

COMMENT ON COLUMN public.tbinforechten.dlcinfocoredt
IS 'Niveau C. InfoModule. Registreren van doucmenten en geregistreerde correspondentie wijzigen metadata(T of F).';

COMMENT ON COLUMN public.tbinforechten.dlcinfocorins
IS 'Niveau C. InfoModule. Correspondentie creeren en uploaden van documenten.';

COMMENT ON COLUMN public.tbinforechten.dlcinfocordel
IS 'Niveau C. InfoModule. geregisteerde correspondentie verwijderen metadata(T of F).';

COMMENT ON COLUMN public.tbinforechten.dlcinfocinvsb
IS 'Niveau C. InfoModule. Correspondentie binnenkomend zichtbaar.';

COMMENT ON COLUMN public.tbinforechten.dlcinfocinedt
IS 'Niveau C. InfoModule. Correspondentie binnenkomend muteerrecht.';

COMMENT ON COLUMN public.tbinforechten.dlcinfocinins
IS 'Niveau C. InfoModule. Correspondentie binnenkomend Insertrecht.';

COMMENT ON COLUMN public.tbinforechten.dlcinfocindel
IS 'Niveau C. InfoModule. Correspondentie binnenkomend verwijderrecht.';

COMMENT ON COLUMN public.tbinforechten.dlcinfologvsb
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbinforechten.dlcinfologedt
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbinforechten.dlcinfologins
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbinforechten.dlcinfologdel
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbinforechten.dlcinfolegvsb
IS 'Niveau C InfoModule Leges zichtbaar (T of F).';

COMMENT ON COLUMN public.tbinforechten.dlcinfolegedt
IS 'Niveau C InfoModule Leges wijzigen (T of F).';

COMMENT ON COLUMN public.tbinforechten.dlcinfolegins
IS 'Niveau C InfoModule Leges nieuw (T of F).';

COMMENT ON COLUMN public.tbinforechten.dlcinfolegdel
IS 'Niveau C InfoModule Leges verwijderen  (T of F).';

COMMENT ON COLUMN public.tbinforechten.dlcinfoprovsb
IS 'Niveau C. InfoModule. Procedures zichtbaar.';

COMMENT ON COLUMN public.tbinforechten.dlcinfoproedt
IS 'Niveau C. InfoModule. Procedures muteerbaar.';

COMMENT ON COLUMN public.tbinforechten.dlcinfoproins
IS 'Niveau C. InfoModule. Procedures Insertrecht.';

COMMENT ON COLUMN public.tbinforechten.dlcinfoprodel
IS 'Niveau C. InfoModule. Procedures verwijderrecht.';

COMMENT ON COLUMN public.tbinforechten.dlcinfoproahn
IS 'Niveau C. InfoModule. Procedures aanhouden en termijn van orde.';

COMMENT ON COLUMN public.tbinforechten.dlcinfoprovdg
IS 'Niveau C. InfoModule. Procedures Verdagen.';

COMMENT ON COLUMN public.tbinforechten.dlcinfotrwvsb
IS 'Niveau C. InfoModule. Trefwoord zichtbaar.';

COMMENT ON COLUMN public.tbinforechten.dlcinfotrwedt
IS 'Niveau C. InfoModule. Trefwoord muteerrecht.';

COMMENT ON COLUMN public.tbinforechten.dlcinfotrwins
IS 'Niveau C. InfoModule. Trefwoord Insertrecht.';

COMMENT ON COLUMN public.tbinforechten.dlcinfotrwdel
IS 'Niveau C. InfoModule. TrefwoordVerwijderrecht.';

COMMENT ON COLUMN public.tbinforechten.dlbinfogroepedt
IS 'Niveau B Infomodule Groepvergunnigen maken (T  of F).';

COMMENT ON COLUMN public.tbinforechten.dlbinfoverzledt
IS 'Niveau B InfoModule verzendlijst maken (T  of F).';

COMMENT ON COLUMN public.tbinforechten.dlbinfomemovsb
IS 'Niveau B. InfoModule. Editscherm Memo zichtbaar.';

COMMENT ON COLUMN public.tbinforechten.dlbinfomemoedt
IS 'Niveau B. InfoModule.  Memo wijzigen.';

COMMENT ON COLUMN public.tbinforechten.dlcinfoadvinedt
IS 'Niveau C InfoModule. Adviezen. Mag kolom Adviesinstantie wijzigen.';

COMMENT ON COLUMN public.tbinforechten.dlcinfolegexpnot
IS 'Niveau C. Infomodule Leges Notanummer en Exportdatum muteerbaar.';

COMMENT ON COLUMN public.tbinforechten.dlbinfoadedt
IS 'Niveau B. InfoModule. Mag startdatum wijzigen (T of F).';

COMMENT ON COLUMN public.tbinforechten.dlcinfadvdatedt
IS 'Niveau C. Adviezen. Wijzigrecht kolom DdDateringadvies van tabel TbAdviezen bij info (T of F).';

COMMENT ON COLUMN public.tbinforechten.dlcinfocordms
IS 'Niveau C. Infomodule. Correspondentie. DMS-kolom muteerbaar';

COMMENT ON COLUMN public.tbinforechten.dlcinfocorodt
IS 'Niveau C. Infomodule. Correspondentie. Opgeslagen document-kolom muteerbaar.';

COMMENT ON COLUMN public.tbinforechten.dlbinfosnelins
IS 'Niveau B. Infomodule. Mag dvdmscode wijzigen.';

COMMENT ON COLUMN public.tbinforechten.dlcinfoadvdms
IS 'Niveau C. Infomodule. Adviezen. Dmscode muteren (T of F). ';

COMMENT ON COLUMN public.tbinforechten.dlbinfohlink
IS 'Niveau B. Infomodule. Mag hyperlink starten vanuit powerportal infodetail.';

COMMENT ON COLUMN public.tbinforechten.dlcinfouurvsb
IS 'Niveau C. Infomodule... uren inzien (T of F)';

COMMENT ON COLUMN public.tbinforechten.dlcinfouurins
IS 'Niveau C. Infomodule... uren insert (T of F)';

COMMENT ON COLUMN public.tbinforechten.dlcinfouurdel
IS 'Niveau C. Infomodule... uren delete (T of F)';

COMMENT ON COLUMN public.tbinforechten.dlcinfouuredt
IS 'Niveau C. Infomodule... uren wijzgen (T of F)';

COMMENT ON COLUMN public.tbinforechten.dlcinfoadvuurvsb
IS 'Niveau C. adviezen bij Infomodule... uren inzien (T of F), edit- insert- delrechten via dlcinfouuredt, dlcinfouurins,dlcinfouurdel';

COMMENT ON COLUMN public.tbinforechten.dlbinfoafsedt
IS 'Niveau B Infomodule gevulde afhandeldatum wijzgen en dit geldt ook voor gevulde externe zaak einddatum (dddmsafgehandeld) bij deelzaak advies die aan info zijn gekoppeld(T of F)';

COMMENT ON COLUMN public.tbinforechten.dlcinfocorregvsb
IS 'Niveau C Info Geregistreerde documenten zichtbaar (T of F) Default T';

COMMENT ON COLUMN public.tbinforechten.dlcinfocorregdwl
IS 'Niveau C Info Geregistreerde documenten Mag geforceerd downloaden (T of F) Default F';

COMMENT ON COLUMN public.tbinforechten.dlcinfocordocdel
IS 'Niveau C Info geregisteerde correspondentie verwijderen fysiek document(T of F).';

COMMENT ON COLUMN public.tbinforechten.dlcinfocorwmo
IS 'Niveau C Info Wijzigen metadata (hernoemen filenaam) ongeregistreerde documenten (T of F)';

COMMENT ON COLUMN public.tbinforechten.dlcinfocorreghnm
IS 'Niveau C Info Hernoemen geregistreerde documenten';

COMMENT ON COLUMN public.tbinforechten.dlcinfoprdedt
IS 'Niveau C Info Product/Dienst wijzigen (T of F).';

COMMENT ON COLUMN public.tbinforechten.dlcinfoprdins
IS 'Niveau C Info Product/Dienst toevoegen (T of F).';

COMMENT ON COLUMN public.tbinforechten.dlcinfoprddel
IS 'Niveau C Info Product/Dienst verwijderen (T of F).';

COMMENT ON COLUMN public.tbinforechten.dlbinfowznedt
IS 'Niveau B. InfoModule. Mag Openwave zaaknummer wijzigen (T of F).';

COMMENT ON COLUMN public.tbinforechten.dlbinfoztedt
IS 'Niveau B. InfoModule. Mag zaaktype wijzigen (T of F).';

COMMENT ON COLUMN public.tbinforechten.dlcinfocorregtent
IS 'Niveau C. Info... wijzigrecht (externe) tbcorrespondentie.dvexttracktrace';

CREATE UNIQUE INDEX idu_inforechten_keyrechten ON public.tbinforechten
 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