Datadictionary OpenWave 3.1.35 |
|
Table: tbrechten
Datadictionary OpenWave 3.1.35 |
|
Table: tbrechten
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Rechtentabel voor moduleoverstijgende rechten
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbrechten_dnkey_seq'::regclass) |
Primary key. |
|
|
dvgroep |
varchar(20) |
|
|
|
|
Groepsaanduiding. Uniek. |
|
|
dvgroepoms |
varchar(100) |
|
|
|
|
Groepsomschrijving. |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Vervaldatum. |
|
|
dnrapportageniveau |
integer |
|
|
|
|
Rapportageniveau. Wordt niet meer gebruikt. Zie tbmedewerkers. |
|
|
dlaovvvsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau A OverigeVergunningen. Zichtbaar (T of F). |
|
|
dlahahvsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau A Handhavingen. Zichtbaar (T of F). |
|
|
dlahorvsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau A HorecaVergunningen. Zichtbaar (T of F). |
|
|
dlabplvsb |
char(1) |
|
|
|
'F'::bpchar |
Wordt niet gebruikt. Niveau A Bestemmingsplannen. Zichtbaar (T of F). |
|
|
dlaextvsb |
char(1) |
|
|
|
'F'::bpchar |
Wordt niet gebruikt. Niveau A Externe koppelingen. Zichtbaar (T of F). |
|
|
dlainfovsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau A Infovergunningen zichtbaar (Tof F). |
|
|
dlaadrvsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau A. Adresboek zichtbaar (Tof F). |
|
|
dlamldavsb |
char(1) |
|
|
|
'F'::bpchar |
Wordt niet gebruikt.Niveau A Recht op takenlijst Allen (T of F). |
|
|
dlamldivsb |
char(1) |
|
|
|
'F'::bpchar |
Wordt niet gebruikt. Niveau A Recht op takenlijst Individueel (T of F). |
|
|
dlaspvvsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau A. Lokatieadressen zichtbaar. |
|
|
dlaexpvsb |
char(1) |
|
|
|
'F'::bpchar |
Wordt niet gebruikt.Niveau A Exporteren Zichtbaar (T of F). |
|
|
dlcextcbs11vsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau C CBS-11 Inzien vanuit omgevingzaken (T of F). |
|
|
dlcextcbs11edt |
char(1) |
|
|
|
'F'::bpchar |
Niveau C CBS-11 wijzigen vanuit omgevingzaken(T of F). |
|
|
dlcextcbs11ins |
char(1) |
|
|
|
'F'::bpchar |
Niveau C CBS-11 nieuw vanuit omgevingzaken(T of F). |
|
|
dlcextcbs11del |
char(1) |
|
|
|
'F'::bpchar |
Niveau C CBS-11 verwijderen vanuit omgevingzaken(T of F). |
|
|
dlcextcbs11disk |
char(1) |
|
|
|
'F'::bpchar |
Niveau C CBS-11 maken exportfile maken recht vanuit omgevingzaken(T of F). |
|
|
dlcextfisimp |
char(1) |
|
|
|
'F'::bpchar |
Wordt niet gebruikt.Niveau C FIS Import (T of F). |
|
|
dlcextfisexp |
char(1) |
|
|
|
'F'::bpchar |
Niveau C FIS Export (T of F). |
|
|
dldvgdedt |
char(1) |
|
|
|
'F'::bpchar |
Niveau D. Perceeladressen samenvoegen (T of F). |
|
|
dldpcledt |
char(1) |
|
|
|
'F'::bpchar |
Niveau D Perceeladres wijzigen (T of F). |
|
|
dldcadins |
char(1) |
|
|
|
'F'::bpchar |
Niveau D Contactadres nieuw (T of F). |
|
|
dldcadedt |
char(1) |
|
|
|
'F'::bpchar |
Niveau D Contactadres wijzig (T of F). |
|
|
dldcaddel |
char(1) |
|
|
|
'F'::bpchar |
Niveau D Contactadres vervallen (T of F) |
|
|
dldpclins |
char(1) |
|
|
|
'F'::bpchar |
Niveau D Perceeladres toevoegen (T of F). |
|
|
dldpcldel |
char(1) |
|
|
|
'F'::bpchar |
Niveau D Perceeladres Vervallen (T of F). |
|
|
dlamilvsb |
char(1) |
|
|
|
'F'::bpchar |
Milieuinrichtingen zichtbaar (T of F). |
|
|
dlaomgvsb |
char(1) |
|
|
|
'F'::bpchar |
Omgevingsvergunning zichtbaar (T of F). |
|
|
dldpclbag |
char(1) |
|
|
|
'F'::bpchar |
Niveau D Perceeladressen BAG (basisreg Adressen/gebouwen Ophaalrechten (T of F). |
|
|
dldcadbra |
char(1) |
|
|
|
'F'::bpchar |
Niveau D Contactadressen BRA (basisreg. Adressen) Ophaalrechten (T of F). |
|
|
dldcasam |
char(1) |
|
|
|
'F'::bpchar |
Niveau D Contactadressen Samenvoegrecht (T of F). |
|
|
dlaispubliekgroep |
char(1) |
|
|
|
'F'::bpchar |
Niveau A. De rechtengroep is bedoeld voor publieksfuncties (privacygevoelige gegevens niet zichtbaar). |
|
|
dlamilvergvsb |
char(1) |
|
|
|
'F'::bpchar |
Niveau A milieu.gebruiksvergunningen. Zichtbaar (T of F). |
|
|
dlmappenhyperlink |
char(1) |
|
|
|
'F'::bpchar |
F of T. Indien T dan mag een hyperlink gestart worden (via kolom dvhyperlink bij tbomgvergunning, tbovvergunningen, tbmilinrichtingen, tbhandhavingen ) EN mag gedownload en gupload worden naar alle mappen behorende bij de zaak. |
|
|
dlcdoclinkexp |
char(1) |
|
|
|
'F'::bpchar |
Niveau C. Alert bij locatie muteerbaar |
|
|
dldcadkopbedrf |
char(1) |
|
|
|
'F'::bpchar |
Niveau D. Mag contactadres koppelen aan bedrijf (T of F). Default F. |
|
|
dldcadontkopbedrf |
char(1) |
|
|
|
'F'::bpchar |
Niveau D. Mag contactadres ontkoppelen van bedrijf (T of F). Default F. |
Foreign Keys
There are no foreign keys for table tbrechten
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_rechten_dlaadrvsb |
dlaadrvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlabplvsb |
dlabplvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlaexpvsb |
dlaexpvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlaextvsb |
dlaextvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlahahvsb |
dlahahvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlahorvsb |
dlahorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlainfovsb |
dlainfovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlaispubliekgroep |
dlaispubliekgroep = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
chk_rechten_dlamilvergvsb |
dlamilvergvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
chk_rechten_dlamilvsb |
dlamilvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlamldavsb |
dlamldavsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlamldivsb |
dlamldivsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlaomgvsb |
dlaomgvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlaovvvsb |
dlaovvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlaspvvsb |
dlaspvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlcdoclinkexp |
dlcdoclinkexp = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
chk_rechten_dlcextcbs11del |
dlcextcbs11del = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlcextcbs11disk |
dlcextcbs11disk = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlcextcbs11edt |
dlcextcbs11edt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlcextcbs11ins |
dlcextcbs11ins = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlcextcbs11vsb |
dlcextcbs11vsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlcextfisexp |
dlcextfisexp = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlcextfisimp |
dlcextfisimp = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dldcadbra |
dldcadbra = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dldcaddel |
dldcaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dldcadedt |
dldcadedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dldcadins |
dldcadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dldcadkopbedrf |
dldcadkopbedrf = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
chk_rechten_dldcadontkopbedrf |
dldcadontkopbedrf = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
chk_rechten_dldcasam |
dldcasam = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dldpclbag |
dldpclbag = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dldpcldel |
dldpcldel = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dldpcledt |
dldpcledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dldpclins |
dldpclins = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dldvgdedt |
dldvgdedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_rechten_dlmappenhyperlink |
dlmappenhyperlink = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
cnn_rechten_dlaispubliekgroep |
dlaispubliekgroep IS NOT NULL |
|
cnn_rechten_dlamilvergvsb |
dlamilvergvsb IS NOT NULL |
|
cnn_rechten_dlcdoclinkexpb |
dlcdoclinkexp IS NOT NULL |
|
cnn_rechten_dldcadkopbedrf |
dldcadkopbedrf IS NOT NULL |
|
cnn_rechten_dldcadontkopbedrf |
dldcadontkopbedrf IS NOT NULL |
|
cnn_rechten_dlmappenhyperlink |
dlmappenhyperlink IS NOT NULL |
|
cnn_rechten_groep |
dvgroep IS NOT NULL |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbrechten |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbrechten
Rules
There are no rules for table tbrechten
Policies
There are no policies for table tbrechten
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_bestrechten_keyrechten |
dnkeyrechten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
||
public |
cfk_hhrechten_keyrechten |
dnkeyrechten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
||
public |
cfk_horrechten_keyrechten |
dnkeyrechten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
||
public |
cfk_inforechten_keyrechten |
dnkeyrechten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
||
public |
cfk_medewerkers_keyrechten |
dnkeyrechten |
dnkey |
No Action |
No Action |
|
Immediate |
|
||
public |
cfk_tbmilrechten_keyrechten |
dnkeyrechten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
||
public |
cfk_tbmilvergrecht_keyrechten |
dnkeyrechten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
||
public |
cfk_tbomgrechten_keyrechten |
dnkeyrechten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
||
public |
cfk_ovrechten_keyrechten |
dnkeyrechten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
||
public |
cfk_rechtengrmap_keyrechten |
dnkeyrechten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvgroep VARCHAR(20),
dvgroepoms VARCHAR(100),
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE STORAGE PLAIN,
dnrapportageniveau INTEGER STORAGE PLAIN,
dlaovvvsb CHAR(1) DEFAULT 'F'::bpchar,
dlahahvsb CHAR(1) DEFAULT 'F'::bpchar,
dlahorvsb CHAR(1) DEFAULT 'F'::bpchar,
dlabplvsb CHAR(1) DEFAULT 'F'::bpchar,
dlaextvsb CHAR(1) DEFAULT 'F'::bpchar,
dlainfovsb CHAR(1) DEFAULT 'F'::bpchar,
dlaadrvsb CHAR(1) DEFAULT 'F'::bpchar,
dlamldavsb CHAR(1) DEFAULT 'F'::bpchar,
dlamldivsb CHAR(1) DEFAULT 'F'::bpchar,
dlaspvvsb CHAR(1) DEFAULT 'F'::bpchar,
dlaexpvsb CHAR(1) DEFAULT 'F'::bpchar,
dlcextcbs11vsb CHAR(1) DEFAULT 'F'::bpchar,
dlcextcbs11edt CHAR(1) DEFAULT 'F'::bpchar,
dlcextcbs11ins CHAR(1) DEFAULT 'F'::bpchar,
dlcextcbs11del CHAR(1) DEFAULT 'F'::bpchar,
dlcextcbs11disk CHAR(1) DEFAULT 'F'::bpchar,
dlcextfisimp CHAR(1) DEFAULT 'F'::bpchar,
dlcextfisexp CHAR(1) DEFAULT 'F'::bpchar,
dldvgdedt CHAR(1) DEFAULT 'F'::bpchar,
dldpcledt CHAR(1) DEFAULT 'F'::bpchar,
dldcadins CHAR(1) DEFAULT 'F'::bpchar,
dldcadedt CHAR(1) DEFAULT 'F'::bpchar,
dldcaddel CHAR(1) DEFAULT 'F'::bpchar,
dldpclins CHAR(1) DEFAULT 'F'::bpchar,
dldpcldel CHAR(1) DEFAULT 'F'::bpchar,
dlamilvsb CHAR(1) DEFAULT 'F'::bpchar,
dlaomgvsb CHAR(1) DEFAULT 'F'::bpchar,
dldpclbag CHAR(1) DEFAULT 'F'::bpchar,
dldcadbra CHAR(1) DEFAULT 'F'::bpchar,
dldcasam CHAR(1) DEFAULT 'F'::bpchar,
dlaispubliekgroep CHAR(1) DEFAULT 'F'::bpchar,
dlamilvergvsb CHAR(1) DEFAULT 'F'::bpchar,
dlmappenhyperlink CHAR(1) DEFAULT 'F'::bpchar,
dlcdoclinkexp CHAR(1) DEFAULT 'F'::bpchar,
dldcadkopbedrf CHAR(1) DEFAULT 'F'::bpchar,
dldcadontkopbedrf CHAR(1) DEFAULT 'F'::bpchar,
CONSTRAINT cpk_tbrechten PRIMARY KEY(dnkey),
CONSTRAINT chk_rechten_dlaadrvsb CHECK (dlaadrvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlabplvsb CHECK (dlabplvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlaexpvsb CHECK (dlaexpvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlaextvsb CHECK (dlaextvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlahahvsb CHECK (dlahahvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlahorvsb CHECK (dlahorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlainfovsb CHECK (dlainfovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlaispubliekgroep CHECK (dlaispubliekgroep = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT chk_rechten_dlamilvergvsb CHECK (dlamilvergvsb = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT chk_rechten_dlamilvsb CHECK (dlamilvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlamldavsb CHECK (dlamldavsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlamldivsb CHECK (dlamldivsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlaomgvsb CHECK (dlaomgvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlaovvvsb CHECK (dlaovvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlaspvvsb CHECK (dlaspvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlcdoclinkexp CHECK (dlcdoclinkexp = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT chk_rechten_dlcextcbs11del CHECK (dlcextcbs11del = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlcextcbs11disk CHECK (dlcextcbs11disk = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlcextcbs11edt CHECK (dlcextcbs11edt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlcextcbs11ins CHECK (dlcextcbs11ins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlcextcbs11vsb CHECK (dlcextcbs11vsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlcextfisexp CHECK (dlcextfisexp = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlcextfisimp CHECK (dlcextfisimp = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dldcadbra CHECK (dldcadbra = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dldcaddel CHECK (dldcaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dldcadedt CHECK (dldcadedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dldcadins CHECK (dldcadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dldcadkopbedrf CHECK (dldcadkopbedrf = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT chk_rechten_dldcadontkopbedrf CHECK (dldcadontkopbedrf = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT chk_rechten_dldcasam CHECK (dldcasam = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dldpclbag CHECK (dldpclbag = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dldpcldel CHECK (dldpcldel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dldpcledt CHECK (dldpcledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dldpclins CHECK (dldpclins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dldvgdedt CHECK (dldvgdedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_rechten_dlmappenhyperlink CHECK (dlmappenhyperlink = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT cnn_rechten_dlaispubliekgroep CHECK (dlaispubliekgroep IS NOT NULL),
CONSTRAINT cnn_rechten_dlamilvergvsb CHECK (dlamilvergvsb IS NOT NULL),
CONSTRAINT cnn_rechten_dlcdoclinkexpb CHECK (dlcdoclinkexp IS NOT NULL),
CONSTRAINT cnn_rechten_dldcadkopbedrf CHECK (dldcadkopbedrf IS NOT NULL),
CONSTRAINT cnn_rechten_dldcadontkopbedrf CHECK (dldcadontkopbedrf IS NOT NULL),
CONSTRAINT cnn_rechten_dlmappenhyperlink CHECK (dlmappenhyperlink IS NOT NULL),
CONSTRAINT cnn_rechten_groep CHECK (dvgroep IS NOT NULL)
) ;
COMMENT ON TABLE public.tbrechten
IS 'Rechtentabel voor moduleoverstijgende rechten';
COMMENT ON COLUMN public.tbrechten.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbrechten.dvgroep
IS 'Groepsaanduiding. Uniek.';
COMMENT ON COLUMN public.tbrechten.dvgroepoms
IS 'Groepsomschrijving.';
COMMENT ON COLUMN public.tbrechten.ddvervaldatum
IS 'Vervaldatum.';
COMMENT ON COLUMN public.tbrechten.dnrapportageniveau
IS 'Rapportageniveau. Wordt niet meer gebruikt. Zie tbmedewerkers.';
COMMENT ON COLUMN public.tbrechten.dlaovvvsb
IS 'Niveau A OverigeVergunningen. Zichtbaar (T of F).';
COMMENT ON COLUMN public.tbrechten.dlahahvsb
IS 'Niveau A Handhavingen. Zichtbaar (T of F).';
COMMENT ON COLUMN public.tbrechten.dlahorvsb
IS 'Niveau A HorecaVergunningen. Zichtbaar (T of F).';
COMMENT ON COLUMN public.tbrechten.dlabplvsb
IS 'Wordt niet gebruikt. Niveau A Bestemmingsplannen. Zichtbaar (T of F).';
COMMENT ON COLUMN public.tbrechten.dlaextvsb
IS 'Wordt niet gebruikt. Niveau A Externe koppelingen. Zichtbaar (T of F).';
COMMENT ON COLUMN public.tbrechten.dlainfovsb
IS 'Niveau A Infovergunningen zichtbaar (Tof F).';
COMMENT ON COLUMN public.tbrechten.dlaadrvsb
IS 'Niveau A. Adresboek zichtbaar (Tof F).';
COMMENT ON COLUMN public.tbrechten.dlamldavsb
IS 'Wordt niet gebruikt.Niveau A Recht op takenlijst Allen (T of F).';
COMMENT ON COLUMN public.tbrechten.dlamldivsb
IS 'Wordt niet gebruikt. Niveau A Recht op takenlijst Individueel (T of F).';
COMMENT ON COLUMN public.tbrechten.dlaspvvsb
IS 'Niveau A. Lokatieadressen zichtbaar.';
COMMENT ON COLUMN public.tbrechten.dlaexpvsb
IS 'Wordt niet gebruikt.Niveau A Exporteren Zichtbaar (T of F).';
COMMENT ON COLUMN public.tbrechten.dlcextcbs11vsb
IS 'Niveau C CBS-11 Inzien vanuit omgevingzaken (T of F).';
COMMENT ON COLUMN public.tbrechten.dlcextcbs11edt
IS 'Niveau C CBS-11 wijzigen vanuit omgevingzaken(T of F).';
COMMENT ON COLUMN public.tbrechten.dlcextcbs11ins
IS 'Niveau C CBS-11 nieuw vanuit omgevingzaken(T of F).';
COMMENT ON COLUMN public.tbrechten.dlcextcbs11del
IS 'Niveau C CBS-11 verwijderen vanuit omgevingzaken(T of F).';
COMMENT ON COLUMN public.tbrechten.dlcextcbs11disk
IS 'Niveau C CBS-11 maken exportfile maken recht vanuit omgevingzaken(T of F).';
COMMENT ON COLUMN public.tbrechten.dlcextfisimp
IS 'Wordt niet gebruikt.Niveau C FIS Import (T of F).';
COMMENT ON COLUMN public.tbrechten.dlcextfisexp
IS 'Niveau C FIS Export (T of F).';
COMMENT ON COLUMN public.tbrechten.dldvgdedt
IS 'Niveau D. Perceeladressen samenvoegen (T of F).';
COMMENT ON COLUMN public.tbrechten.dldpcledt
IS 'Niveau D Perceeladres wijzigen (T of F).';
COMMENT ON COLUMN public.tbrechten.dldcadins
IS 'Niveau D Contactadres nieuw (T of F).';
COMMENT ON COLUMN public.tbrechten.dldcadedt
IS 'Niveau D Contactadres wijzig (T of F).';
COMMENT ON COLUMN public.tbrechten.dldcaddel
IS 'Niveau D Contactadres vervallen (T of F)';
COMMENT ON COLUMN public.tbrechten.dldpclins
IS 'Niveau D Perceeladres toevoegen (T of F).';
COMMENT ON COLUMN public.tbrechten.dldpcldel
IS 'Niveau D Perceeladres Vervallen (T of F).';
COMMENT ON COLUMN public.tbrechten.dlamilvsb
IS 'Milieuinrichtingen zichtbaar (T of F).';
COMMENT ON COLUMN public.tbrechten.dlaomgvsb
IS 'Omgevingsvergunning zichtbaar (T of F).';
COMMENT ON COLUMN public.tbrechten.dldpclbag
IS 'Niveau D Perceeladressen BAG (basisreg Adressen/gebouwen Ophaalrechten (T of F).';
COMMENT ON COLUMN public.tbrechten.dldcadbra
IS 'Niveau D Contactadressen BRA (basisreg. Adressen) Ophaalrechten (T of F).';
COMMENT ON COLUMN public.tbrechten.dldcasam
IS 'Niveau D Contactadressen Samenvoegrecht (T of F).';
COMMENT ON COLUMN public.tbrechten.dlaispubliekgroep
IS 'Niveau A. De rechtengroep is bedoeld voor publieksfuncties (privacygevoelige gegevens niet zichtbaar).';
COMMENT ON COLUMN public.tbrechten.dlamilvergvsb
IS 'Niveau A milieu.gebruiksvergunningen. Zichtbaar (T of F).';
COMMENT ON COLUMN public.tbrechten.dlmappenhyperlink
IS 'F of T. Indien T dan mag een hyperlink gestart worden (via kolom dvhyperlink bij tbomgvergunning, tbovvergunningen, tbmilinrichtingen, tbhandhavingen ) EN mag gedownload en gupload worden naar alle mappen behorende bij de zaak.';
COMMENT ON COLUMN public.tbrechten.dlcdoclinkexp
IS 'Niveau C. Alert bij locatie muteerbaar';
COMMENT ON COLUMN public.tbrechten.dldcadkopbedrf
IS 'Niveau D. Mag contactadres koppelen aan bedrijf (T of F). Default F.';
COMMENT ON COLUMN public.tbrechten.dldcadontkopbedrf
IS 'Niveau D. Mag contactadres ontkoppelen van bedrijf (T of F). Default F.';
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 26/10/2026 11:10 |
|