Datadictionary OpenWave 3.1.11
 Previous topic Chapter index Next topic

Table: tbbestrechten

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Rechtentabel voor de module bestemmingsplannen

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbbestrechten_dnkey_seq'::regclass)

Primary Key.

 

dnkeyrechten

integer

 

 

 

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

 

 

dlbbesedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Bestemmingsplannen. Editscherm wijzigbaar.

 

 

dlbbesins

char(1)

 

 

 

'F'::bpchar

Niveau B. Bestemmingsplannen. Editscherm InsertRecht.

 

 

dlbbesdel

char(1)

 

 

 

'F'::bpchar

Niveau B. Bestemmingsplannen. Editscherm Verwijderecht.

 

 

dlbbesblokkedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Bestemmingsplannen. Editscherm Blokkeerecht.

 

 

dlbbesmemovsb

char(1)

 

 

 

'F'::bpchar

Niveau B. Bestemmingsplannen. Editscherm Memo zichtbaar.

 

 

dlbbeskopie

char(1)

 

 

 

'F'::bpchar

Niveau B. Bestemmingsplannen. Editscherm Kopieerrecht.

 

 

dlbbesverplaats

char(1)

 

 

 

'F'::bpchar

Niveau B. Bestemmingsplannen. Editscherm verplaatsrecht.

 

 

dlcbesibbvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. In behandeling Bij zichtbaar.

 

 

dlcbesibbedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. In behandeling Bij muteerbaar.

 

 

dlcbesibbins

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. In behandeling Bij Insertrecht.

 

 

dlcbesibbdel

char(1)

 

 

 

'F'::bpchar

Niet meer in gebruik.

 

 

dlcbesprovsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Procedures zichtbaar.

 

 

dlcbesproedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Procedures muteerbaar.

 

 

dlcbesproins

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Procedures Insertrecht.

 

 

dlcbesprodel

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Procedures verwijderrecht.

 

 

dlcbesproahn

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcbesprovdg

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Procedures Verdagen.

 

 

dlcbesadvvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Adviezen zichtbaar.

 

 

dlcbesadvedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Adviezen muteerrecht.

 

 

dlcbesadvins

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Adviezen Insertrecht.

 

 

dlcbesadvdel

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Adviezen verwijderrecht.

 

 

dlcbescorvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Correspondentie zichtbaar.

 

 

dlcbescoredt

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Correspondentie muteerbaar.

 

 

dlcbescorins

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Correspondentie insertrecht.

 

 

dlcbescordel

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Correspondentie verwijdererecht.

 

 

dlcbescadvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Contactadressen zichtbaar.

 

 

dlcbescadins

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Contactadressen Insertrecht.

 

 

dlcbescaddel

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Contactadressen ontkoppelrecht.

 

 

dlcbeslogvsb

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlcbeslogedt

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlcbeslogins

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlcbeslogdel

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlcbescinvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Correspondentie binnenkomend zichtbaar.

 

 

dlcbescinedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Correspondentie binnenkomend muteerrecht.

 

 

dlcbescinins

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Correspondentie binnenkomend Insertrecht.

 

 

dlcbescindel

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Correspondentie binnenkomend verwijderrecht.

 

 

dlcbescompr

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Procedures ComprimeerRecht. Wordt niet gebruikt.

 

 

dlcbesadvinedt

char(1)

 

 

 

'F'::bpchar

Niveau C Bestemmingsplannen. Adviezen. Mag kolom Adviesinstantie wijzigen.

 

 

dlbbesmemoedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Bestemmingsplannen. Memo wijzigen.

 

 

dlcbesadvdatedt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlcbescordms

char(1)

 

 

 

'F'::bpchar

Niveau C. Bestemmingsplannen. Correspondentie. DMS-kolom muteerbaar

 

 

dlcbescorodt

char(1)

 

 

 

'F'::bpchar

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

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

cfk_bestrechten_keyrechten

dnkeyrechten

public.tbrechten

dnkey

Cascade

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

chk_besrechten_besadvdatedt

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

 

chk_bestrechten_dlbbesblokkedt

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

 

chk_bestrechten_dlbbesdel

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

 

chk_bestrechten_dlbbesedt

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

 

chk_bestrechten_dlbbesins

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

 

chk_bestrechten_dlbbeskopie

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

 

chk_bestrechten_dlbbesmemoedt

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

 

chk_bestrechten_dlbbesmemovsb

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

 

chk_bestrechten_dlbbesverplts

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

 

chk_bestrechten_dlcbesadvdel

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

 

chk_bestrechten_dlcbesadvedt

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

 

chk_bestrechten_dlcbesadvinedt

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

 

chk_bestrechten_dlcbesadvins

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

 

chk_bestrechten_dlcbesadvvsb

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

 

chk_bestrechten_dlcbescaddel

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

 

chk_bestrechten_dlcbescadins

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

 

chk_bestrechten_dlcbescadvsb

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

 

chk_bestrechten_dlcbescindel

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

 

chk_bestrechten_dlcbescinedt

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

 

chk_bestrechten_dlcbescinins

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

 

chk_bestrechten_dlcbescinvsb

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

 

chk_bestrechten_dlcbescompr

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

 

chk_bestrechten_dlcbescordel

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

 

chk_bestrechten_dlcbescordms

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

 

chk_bestrechten_dlcbescoredt

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

 

chk_bestrechten_dlcbescorins

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

 

chk_bestrechten_dlcbescorodt

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

 

chk_bestrechten_dlcbescorvsb

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

 

chk_bestrechten_dlcbesibbdel

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

 

chk_bestrechten_dlcbesibbedt

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

 

chk_bestrechten_dlcbesibbins

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

 

chk_bestrechten_dlcbesibbvsb

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

 

chk_bestrechten_dlcbeslogdel

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

 

chk_bestrechten_dlcbeslogedt

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

 

chk_bestrechten_dlcbeslogins

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

 

chk_bestrechten_dlcbeslogvsb

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

 

chk_bestrechten_dlcbesproahn

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

 

chk_bestrechten_dlcbesprodel

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

 

chk_bestrechten_dlcbesproedt

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

 

chk_bestrechten_dlcbesproins

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

 

chk_bestrechten_dlcbesprovdg

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

 

chk_bestrechten_dlcbesprovsb

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

 

cnn_bestrechten_dlcbescordms

dlcbescordms IS NOT NULL

 

cnn_bestrechten_dlcbescorodt

dlcbescorodt IS NOT NULL

 

cnn_bestrechten_dnkeyrechten

dnkeyrechten IS NOT NULL

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbbestrechten

btree

 

dnkey

 

idu_bestrechten_keyrechten

btree

 

dnkeyrechten

 

 

 

Triggers

There are no triggers for table tbbestrechten

 

Rules

There are no rules for table tbbestrechten

 

Referenced

There are no tables referenced by table tbbestrechten

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.tbbestrechten (
 dnkey SERIAL,
 dnkeyrechten INTEGER,
 dlbbesedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbbesins CHAR(1) DEFAULT 'F'::bpchar,
 dlbbesdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbbesblokkedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbbesmemovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbbeskopie CHAR(1) DEFAULT 'F'::bpchar,
 dlbbesverplaats CHAR(1) DEFAULT 'F'::bpchar,
 dlcbesibbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbesibbedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbesibbins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbesibbdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcbesprovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbesproedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbesproins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbesprodel CHAR(1) DEFAULT 'F'::bpchar,
 dlcbesproahn CHAR(1) DEFAULT 'F'::bpchar,
 dlcbesprovdg CHAR(1) DEFAULT 'F'::bpchar,
 dlcbesadvvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbesadvedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbesadvins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbesadvdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcbescorvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbescoredt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbescorins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbescordel CHAR(1) DEFAULT 'F'::bpchar,
 dlcbescadvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbescadins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbescaddel CHAR(1) DEFAULT 'F'::bpchar,
 dlcbeslogvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbeslogedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbeslogins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbeslogdel CHAR(1) DEFAULT 'F'::bpchar,
 dlcbescinvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlcbescinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbescinins CHAR(1) DEFAULT 'F'::bpchar,
 dlcbescindel CHAR(1) DEFAULT 'F'::bpchar,
 dlcbescompr CHAR(1) DEFAULT 'F'::bpchar,
 dlcbesadvinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbbesmemoedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbesadvdatedt CHAR(1) DEFAULT 'F'::bpchar,
 dlcbescordms CHAR(1) DEFAULT 'F'::bpchar,
 dlcbescorodt CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tbbestrechten PRIMARY KEY(dnkey),
 CONSTRAINT chk_besrechten_besadvdatedt CHECK (dlcbesadvdatedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlbbesblokkedt CHECK (dlbbesblokkedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlbbesdel CHECK (dlbbesdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlbbesedt CHECK (dlbbesedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlbbesins CHECK (dlbbesins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlbbeskopie CHECK (dlbbeskopie = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlbbesmemoedt CHECK (dlbbesmemoedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlbbesmemovsb CHECK (dlbbesmemovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlbbesverplts CHECK (dlbbesverplaats = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbesadvdel CHECK (dlcbesadvdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbesadvedt CHECK (dlcbesadvedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbesadvinedt CHECK (dlcbesadvinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbesadvins CHECK (dlcbesadvins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbesadvvsb CHECK (dlcbesadvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbescaddel CHECK (dlcbescaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbescadins CHECK (dlcbescadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbescadvsb CHECK (dlcbescadvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbescindel CHECK (dlcbescindel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbescinedt CHECK (dlcbescinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbescinins CHECK (dlcbescinins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbescinvsb CHECK (dlcbescinvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbescompr CHECK (dlcbescompr = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbescordel CHECK (dlcbescordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbescordms CHECK (dlcbescordms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbescoredt CHECK (dlcbescoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbescorins CHECK (dlcbescorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbescorodt CHECK (dlcbescorodt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbescorvsb CHECK (dlcbescorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbesibbdel CHECK (dlcbesibbdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbesibbedt CHECK (dlcbesibbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbesibbins CHECK (dlcbesibbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbesibbvsb CHECK (dlcbesibbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbeslogdel CHECK (dlcbeslogdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbeslogedt CHECK (dlcbeslogedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbeslogins CHECK (dlcbeslogins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbeslogvsb CHECK (dlcbeslogvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbesproahn CHECK (dlcbesproahn = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbesprodel CHECK (dlcbesprodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbesproedt CHECK (dlcbesproedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbesproins CHECK (dlcbesproins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbesprovdg CHECK (dlcbesprovdg = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_bestrechten_dlcbesprovsb CHECK (dlcbesprovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT cnn_bestrechten_dlcbescordms CHECK (dlcbescordms IS NOT NULL),
 CONSTRAINT cnn_bestrechten_dlcbescorodt CHECK (dlcbescorodt IS NOT NULL),
 CONSTRAINT cnn_bestrechten_dnkeyrechten CHECK (dnkeyrechten IS NOT NULL),
 CONSTRAINT cfk_bestrechten_keyrechten FOREIGN KEY (dnkeyrechten)
   REFERENCES public.tbrechten(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
)
WITH (oids = false);

COMMENT ON TABLE public.tbbestrechten
IS 'Rechtentabel voor de module bestemmingsplannen';

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

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

COMMENT ON COLUMN public.tbbestrechten.dlbbesedt
IS 'Niveau B. Bestemmingsplannen. Editscherm wijzigbaar.';

COMMENT ON COLUMN public.tbbestrechten.dlbbesins
IS 'Niveau B. Bestemmingsplannen. Editscherm InsertRecht.';

COMMENT ON COLUMN public.tbbestrechten.dlbbesdel
IS 'Niveau B. Bestemmingsplannen. Editscherm Verwijderecht.';

COMMENT ON COLUMN public.tbbestrechten.dlbbesblokkedt
IS 'Niveau B. Bestemmingsplannen. Editscherm Blokkeerecht.';

COMMENT ON COLUMN public.tbbestrechten.dlbbesmemovsb
IS 'Niveau B. Bestemmingsplannen. Editscherm Memo zichtbaar.';

COMMENT ON COLUMN public.tbbestrechten.dlbbeskopie
IS 'Niveau B. Bestemmingsplannen. Editscherm Kopieerrecht.';

COMMENT ON COLUMN public.tbbestrechten.dlbbesverplaats
IS 'Niveau B. Bestemmingsplannen. Editscherm verplaatsrecht.';

COMMENT ON COLUMN public.tbbestrechten.dlcbesibbvsb
IS 'Niveau C. Bestemmingsplannen. In behandeling Bij zichtbaar.';

COMMENT ON COLUMN public.tbbestrechten.dlcbesibbedt
IS 'Niveau C. Bestemmingsplannen. In behandeling Bij muteerbaar.';

COMMENT ON COLUMN public.tbbestrechten.dlcbesibbins
IS 'Niveau C. Bestemmingsplannen. In behandeling Bij Insertrecht.';

COMMENT ON COLUMN public.tbbestrechten.dlcbesibbdel
IS 'Niet meer in gebruik.';

COMMENT ON COLUMN public.tbbestrechten.dlcbesprovsb
IS 'Niveau C. Bestemmingsplannen. Procedures zichtbaar.';

COMMENT ON COLUMN public.tbbestrechten.dlcbesproedt
IS 'Niveau C. Bestemmingsplannen. Procedures muteerbaar.';

COMMENT ON COLUMN public.tbbestrechten.dlcbesproins
IS 'Niveau C. Bestemmingsplannen. Procedures Insertrecht.';

COMMENT ON COLUMN public.tbbestrechten.dlcbesprodel
IS 'Niveau C. Bestemmingsplannen. Procedures verwijderrecht.';

COMMENT ON COLUMN public.tbbestrechten.dlcbesproahn
IS 'Niveau C. Bestemmingsplannen. Procedures aanhouden en termijn van orde.';

COMMENT ON COLUMN public.tbbestrechten.dlcbesprovdg
IS 'Niveau C. Bestemmingsplannen. Procedures Verdagen.';

COMMENT ON COLUMN public.tbbestrechten.dlcbesadvvsb
IS 'Niveau C. Bestemmingsplannen. Adviezen zichtbaar.';

COMMENT ON COLUMN public.tbbestrechten.dlcbesadvedt
IS 'Niveau C. Bestemmingsplannen. Adviezen muteerrecht.';

COMMENT ON COLUMN public.tbbestrechten.dlcbesadvins
IS 'Niveau C. Bestemmingsplannen. Adviezen Insertrecht.';

COMMENT ON COLUMN public.tbbestrechten.dlcbesadvdel
IS 'Niveau C. Bestemmingsplannen. Adviezen verwijderrecht.';

COMMENT ON COLUMN public.tbbestrechten.dlcbescorvsb
IS 'Niveau C. Bestemmingsplannen. Correspondentie zichtbaar.';

COMMENT ON COLUMN public.tbbestrechten.dlcbescoredt
IS 'Niveau C. Bestemmingsplannen. Correspondentie muteerbaar.';

COMMENT ON COLUMN public.tbbestrechten.dlcbescorins
IS 'Niveau C. Bestemmingsplannen. Correspondentie insertrecht.';

COMMENT ON COLUMN public.tbbestrechten.dlcbescordel
IS 'Niveau C. Bestemmingsplannen. Correspondentie verwijdererecht.';

COMMENT ON COLUMN public.tbbestrechten.dlcbescadvsb
IS 'Niveau C. Bestemmingsplannen. Contactadressen zichtbaar.';

COMMENT ON COLUMN public.tbbestrechten.dlcbescadins
IS 'Niveau C. Bestemmingsplannen. Contactadressen Insertrecht.';

COMMENT ON COLUMN public.tbbestrechten.dlcbescaddel
IS 'Niveau C. Bestemmingsplannen. Contactadressen ontkoppelrecht.';

COMMENT ON COLUMN public.tbbestrechten.dlcbeslogvsb
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbbestrechten.dlcbeslogedt
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbbestrechten.dlcbeslogins
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbbestrechten.dlcbeslogdel
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbbestrechten.dlcbescinvsb
IS 'Niveau C. Bestemmingsplannen. Correspondentie binnenkomend zichtbaar.';

COMMENT ON COLUMN public.tbbestrechten.dlcbescinedt
IS 'Niveau C. Bestemmingsplannen. Correspondentie binnenkomend muteerrecht.';

COMMENT ON COLUMN public.tbbestrechten.dlcbescinins
IS 'Niveau C. Bestemmingsplannen. Correspondentie binnenkomend Insertrecht.';

COMMENT ON COLUMN public.tbbestrechten.dlcbescindel
IS 'Niveau C. Bestemmingsplannen. Correspondentie binnenkomend verwijderrecht.';

COMMENT ON COLUMN public.tbbestrechten.dlcbescompr
IS 'Niveau C. Bestemmingsplannen. Procedures ComprimeerRecht. Wordt niet gebruikt.';

COMMENT ON COLUMN public.tbbestrechten.dlcbesadvinedt
IS 'Niveau C Bestemmingsplannen. Adviezen. Mag kolom Adviesinstantie wijzigen.';

COMMENT ON COLUMN public.tbbestrechten.dlbbesmemoedt
IS 'Niveau B. Bestemmingsplannen. Memo wijzigen.';

COMMENT ON COLUMN public.tbbestrechten.dlcbesadvdatedt
IS 'Niveau C. Adviezen. Wijzigrecht kolom DdDateringadvies van tabel TbAdviezen bij bestemmingsplannen (T of F).';

COMMENT ON COLUMN public.tbbestrechten.dlcbescordms
IS 'Niveau C. Bestemmingsplannen. Correspondentie. DMS-kolom muteerbaar';

COMMENT ON COLUMN public.tbbestrechten.dlcbescorodt
IS 'Niveau C. Bestemmingsplannen. Correspondentie. Opgeslagen document-kolom muteerbaar.';

CREATE UNIQUE INDEX idu_bestrechten_keyrechten ON public.tbbestrechten
 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