Datadictionary OpenWave 3.1.11
 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)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Correspondentie zichtbaar.

 

 

dlcinfocoredt

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Correspondentie muteerbaar.

 

 

dlcinfocorins

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Correspondentie insertrecht.

 

 

dlcinfocordel

char(1)

 

 

 

'F'::bpchar

Niveau C. InfoModule. Correspondentie verwijdererecht.

 

 

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. InfoMoudle. Aanvraagdatum wijzigen.

 

 

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).

 

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_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_dlcinfocoredt

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

 

chk_inforecht_dlcinfocorins

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

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

 

chk_inforechten_dlcinfocordms

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

 

chk_inforechten_dlcinfocorodt

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

 

chk_infrechten_infadvdatedt

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

 

chk_tbinfor_dlcinfoadvdms

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

 

cnn_inforecht_keyrechten

dnkeyrechten IS NOT NULL

 

cnn_inforechten_dlbinfosnelins

dlbinfosnelins IS NOT NULL

 

cnn_inforechten_dlcinfocordms

dlcinfocordms IS NOT NULL

 

cnn_inforechten_dlcinfocorodt

dlcinfocorodt 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

 

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 'F'::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,
 CONSTRAINT cpk_tbinforechten PRIMARY KEY(dnkey),
 CONSTRAINT chk_inforecht_dlbinfoadedt CHECK (dlbinfoadedt = ANY (ARRAY['T'::bpchar, 'F'::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_dlcinfocoredt CHECK (dlcinfocoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_inforecht_dlcinfocorins CHECK (dlcinfocorins = ANY (ARRAY['T'::bpchar, 'F'::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_dlbinfosnelins CHECK (dlbinfosnelins = ANY (ARRAY['T'::bpchar, 'F'::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_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_keyrechten CHECK (dnkeyrechten IS NOT NULL),
 CONSTRAINT cnn_inforechten_dlbinfosnelins CHECK (dlbinfosnelins IS NOT NULL),
 CONSTRAINT cnn_inforechten_dlcinfocordms CHECK (dlcinfocordms IS NOT NULL),
 CONSTRAINT cnn_inforechten_dlcinfocorodt CHECK (dlcinfocorodt IS NOT NULL),
 CONSTRAINT cfk_inforechten_keyrechten FOREIGN KEY (dnkeyrechten)
   REFERENCES public.tbrechten(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
)
WITH (oids = false);

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. Correspondentie zichtbaar.';

COMMENT ON COLUMN public.tbinforechten.dlcinfocoredt
IS 'Niveau C. InfoModule. Correspondentie muteerbaar.';

COMMENT ON COLUMN public.tbinforechten.dlcinfocorins
IS 'Niveau C. InfoModule. Correspondentie insertrecht.';

COMMENT ON COLUMN public.tbinforechten.dlcinfocordel
IS 'Niveau C. InfoModule. Correspondentie verwijdererecht.';

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. InfoMoudle. Aanvraagdatum wijzigen.';

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). ';

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