Datadictionary OpenWave 3.1.11
 Previous topic Chapter index Next topic

Table: tbhorrechten

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Rechtentabel voor de module horeca

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbhorrechten_dnkey_seq'::regclass)

Primary Key.

 

dnkeyrechten

integer

 

 

 

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

 

 

dlbhoredt

char(1)

 

 

 

'F'::bpchar

Niveau B. Horeca. Editscherm wijzigbaar.

 

 

dlbhorins

char(1)

 

 

 

'F'::bpchar

Niveau B. Horeca. Editscherm InsertRecht.

 

 

dlbhordel

char(1)

 

 

 

'F'::bpchar

Niveau B. Horeca. Editscherm Verwijderecht.

 

 

dlbhorblokkedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Horeca. Editscherm Blokkeerecht.

 

 

dlbhorverzledt

char(1)

 

 

 

'F'::bpchar

Niveau B. Horeca. Editscherm Verzendlijstsrecht.

 

 

dlbhorgroepedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Horeca. Editscherm Groepsvergunningrecht.

 

 

dlbhormemovsb

char(1)

 

 

 

'F'::bpchar

Niveau B. Horeca. Editscherm Memo zichtbaar.

 

 

dlbhorkopie

char(1)

 

 

 

'F'::bpchar

Niveau B. Horeca. Editscherm Kopieerrecht.

 

 

dlbhorverplaats

char(1)

 

 

 

'F'::bpchar

Niveau B. Horeca. Editscherm verplaatsrecht.

 

 

dlchoribbvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. In behandeling Bij zichtbaar.

 

 

dlchoribbedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. In behandeling Bij muteerbaar.

 

 

dlchoribbins

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. In behandeling Bij Insertrecht.

 

 

dlchoribbdel

char(1)

 

 

 

'F'::bpchar

Niet meer in gebruik.

 

 

dlchorprovsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Procedures zichtbaar.

 

 

dlchorproedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Procedures muteerbaar.

 

 

dlchorproins

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Procedures Insertrecht.

 

 

dlchorprodel

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Procedures verwijderrecht.

 

 

dlchorproahn

char(1)

 

 

 

'F'::bpchar

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

 

 

dlchorprovdg

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Procedures Verdagen.

 

 

dlchoradvvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Adviezen zichtbaar.

 

 

dlchoradvedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Adviezen muteerrecht.

 

 

dlchoradvins

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Adviezen Insertrecht.

 

 

dlchoradvdel

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Adviezen verwijderrecht.

 

 

dlchorinsvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Inspecties zichtbaar.

 

 

dlchorinsedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Inspecties muteerrecht.

 

 

dlchorinsins

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Inspecties Insertrecht.

 

 

dlchorinsdel

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Inspecties Verwijderrecht.

 

 

dlchorcorvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Correspondentie zichtbaar.

 

 

dlchorcoredt

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Correspondentie muteerbaar.

 

 

dlchorcorins

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Correspondentie insertrecht.

 

 

dlchorcordel

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Correspondentie verwijdererecht.

 

 

dlchorcadvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Contactadressen zichtbaar.

 

 

dlchorcadins

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Contactadressen Insertrecht.

 

 

dlchorcaddel

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Contactadressen ontkoppelrecht.

 

 

dlchorlegvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Leges zichtbaar.

 

 

dlchorlegedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Leges muteerbaar.

 

 

dlchorlegins

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Leges Insertrecht.

 

 

dlchorlegdel

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Leges verwijderrecht.

 

 

dlchorlogvsb

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlchorlogedt

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlchorlogins

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlchorlogdel

char(1)

 

 

 

'F'::bpchar

Wordt niet meer gebruikt sinds versie 307

 

 

dlchorcinvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Correspondentie binnenkomend zichtbaar.

 

 

dlchorcinedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Correspondentie binnenkomend muteerrecht.

 

 

dlchorcinins

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Correspondentie binnenkomend Insertrecht.

 

 

dlchorcindel

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Correspondentie binnenkomend verwijderrecht.

 

 

dlchorexplvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Expoitatie zichtbaar.

 

 

dlchorexpledt

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Expoitatie muteerrecht.

 

 

dlchorexplins

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Expoitatie InsertRecht.

 

 

dlchorexpldel

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Expoitatie Verwijdedrrecht.

 

 

dlchorklavsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Klachten zichtbaar.

 

 

dlchorklaedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Klachten muteerecht.

 

 

dlchorklains

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Klachten Insertrecht.

 

 

dlchorkladel

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Klachten verwijderrecht.

 

 

dlchorohfvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Ontheffingen zichtbaar. Wordt niet gebruikt.

 

 

dlchorohfedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Ontheffingen muteerrecht. Wordt niet gebruikt.

 

 

dlchorohfins

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Ontheffingen Insertrecht. Wordt niet gebruikt.

 

 

dlchorohfdel

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Ontheffingen verwijderrecht. Wordt niet gebruikt.

 

 

dlchortervsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Terras zichtbaar.

 

 

dlchorteredt

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Terras muteerbaar.

 

 

dlchorterins

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Terras Insertrecht.

 

 

dlchorterdel

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Terras verwijderrecht.

 

 

dlchorsptvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Speelautomaten zichtbaar.

 

 

dlchorsptedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Speelautomaten muteerrecht.

 

 

dlchorsptins

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Speelautomaten Insertrecht.

 

 

dlchorsptdel

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Speelautomaten Verwijderrecht.

 

 

dlchorsltvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Sluitingstijden muteerbaar.

 

 

dlchorsltedt

char(1)

 

 

 

'F'::bpchar

 

 

 

dlchorsltins

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Sluitingstijden Insertrecht.

 

 

dlchorsltdel

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Sluitingstijden verwijderrecht.

 

 

dlchorcompr

char(1)

 

 

 

'F'::bpchar

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

 

 

dlchoradvinedt

char(1)

 

 

 

'F'::bpchar

Niveau C Horeca. Adviezen. Mag kolom Adviesinstantie wijzigen.

 

 

dlchorlegexpnot

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Leges Notanummer en Exportdatum muteerbaar.

 

 

dlbhormemoedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Horeca. Memo wijzigen.

 

 

dlbhorabedt

char(1)

 

 

 

'F'::bpchar

Niveau B. Horeca. Aard besluit en besluitdatum wijzigbaar.

 

 

dlchoradvdatedt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlchorbepedt

char(1)

 

 

 

'F'::bpchar

Niveau C. HorecaBeperkingen wijzigrecht (T of F).

 

 

dlchorbepvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. HorecaBeperkingen Zichtbaar (T of F).

 

 

dlchorbepins

char(1)

 

 

 

'F'::bpchar

Niveau C. HorecaBeperkingen insertrecht (T of F).

 

 

dlchorbepdel

char(1)

 

 

 

'F'::bpchar

Niveau C. HorecaBeperkingen verwijderrecht (T of F).

 

 

dlchorlokedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca Lokaliteiten wijzigrecht (T of F).

 

 

dlchorlokvsb

char(1)

 

 

 

'F'::bpchar

niveau c. Horeca Lokaliteiten zichtbaar (T of F).

 

 

dlchorlokins

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca Lokaliteiten insertrecht (T of F).

 

 

dlchorlokdel

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca Lokalieiten verwijderrecht (T of F).

 

 

dlchorontedt

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca Ontheffingen wijzigrecht (T of F).

 

 

dlchorontvsb

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca Ontheffingen Zichtbaar (T of F).

 

 

dlchorontins

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca Ontheffingen insertrecht (T of F).

 

 

dlchorontdel

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca Ontheffingen verwijderrecht (T of F).

 

 

dlbhoradedt

char(1)

 

 

 

'T'::bpchar

Niveau B Horeca. Aanvraagdatum vergnr, en soortvergunning wijzigen recht.

 

 

dlchorcordms

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Correspondentie. DMS-kolom muteerbaar

 

 

dlchorcorodt

char(1)

 

 

 

'F'::bpchar

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

 

 

dlbhorsnelins

char(1)

 

 

 

'T'::bpchar

Niveau B. Horeca. Mag dvdmszaakcode wijzigen.

 

 

dlchoradvdms

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Adviezen. Mag dvdmscode wijzigen.

 

 

dlchorinsdms

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Inspecties. Mag dvdmscode wijzigen.

 

 

dlchorkladms

char(1)

 

 

 

'F'::bpchar

Niveau C. Horeca. Klachten. Mag dvdmscode wijzigen.

 

 

dlbhorhlink

char(1)

 

 

 

'F'::bpchar

Niveau B. Horeca. Mag hyperlink starten vanuit powerportal horecadetail.

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

cfk_horrechten_keyrechten

dnkeyrechten

public.tbrechten

dnkey

Cascade

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

chk_horrechten_dlbhorabedt

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

 

chk_horrechten_dlbhoradedt

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

 

chk_horrechten_dlbhorblokkedt

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

 

chk_horrechten_dlbhordel

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

 

chk_horrechten_dlbhoredt

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

 

chk_horrechten_dlbhorgroepedt

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

 

chk_horrechten_dlbhorins

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

 

chk_horrechten_dlbhorkopie

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

 

chk_horrechten_dlbhormemoedt

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

 

chk_horrechten_dlbhormemovsb

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

 

chk_horrechten_dlbhorsnelins

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

 

chk_horrechten_dlbhorverplaats

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

 

chk_horrechten_dlbhorverzledt

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

 

chk_horrechten_dlchoradvdel

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

 

chk_horrechten_dlchoradvedt

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

 

chk_horrechten_dlchoradvinedt

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

 

chk_horrechten_dlchoradvins

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

 

chk_horrechten_dlchoradvvsb

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

 

chk_horrechten_dlchorcaddel

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

 

chk_horrechten_dlchorcadins

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

 

chk_horrechten_dlchorcadvsb

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

 

chk_horrechten_dlchorcindel

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

 

chk_horrechten_dlchorcinedt

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

 

chk_horrechten_dlchorcinins

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

 

chk_horrechten_dlchorcinvsb

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

 

chk_horrechten_dlchorcompr

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

 

chk_horrechten_dlchorcordel

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

 

chk_horrechten_dlchorcordms

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

 

chk_horrechten_dlchorcoredt

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

 

chk_horrechten_dlchorcorins

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

 

chk_horrechten_dlchorcorodt

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

 

chk_horrechten_dlchorcorvsb

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

 

chk_horrechten_dlchorexpldel

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

 

chk_horrechten_dlchorexpledt

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

 

chk_horrechten_dlchorexplins

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

 

chk_horrechten_dlchorexplvsb

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

 

chk_horrechten_dlchoribbdel

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

 

chk_horrechten_dlchoribbedt

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

 

chk_horrechten_dlchoribbins

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

 

chk_horrechten_dlchoribbvsb

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

 

chk_horrechten_dlchorinsdel

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

 

chk_horrechten_dlchorinsedt

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

 

chk_horrechten_dlchorinsins

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

 

chk_horrechten_dlchorinsvsb

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

 

chk_horrechten_dlchorkladel

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

 

chk_horrechten_dlchorklaedt

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

 

chk_horrechten_dlchorklains

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

 

chk_horrechten_dlchorklavsb

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

 

chk_horrechten_dlchorlegdel

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

 

chk_horrechten_dlchorlegedt

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

 

chk_horrechten_dlchorlegexpnot

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

 

chk_horrechten_dlchorlegins

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

 

chk_horrechten_dlchorlegvsb

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

 

chk_horrechten_dlchorlogdel

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

 

chk_horrechten_dlchorlogedt

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

 

chk_horrechten_dlchorlogins

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

 

chk_horrechten_dlchorlogvsb

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

 

chk_horrechten_dlchorohfdel

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

 

chk_horrechten_dlchorohfedt

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

 

chk_horrechten_dlchorohfins

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

 

chk_horrechten_dlchorohfvsb

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

 

chk_horrechten_dlchorproahn

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

 

chk_horrechten_dlchorprodel

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

 

chk_horrechten_dlchorproedt

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

 

chk_horrechten_dlchorproins

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

 

chk_horrechten_dlchorprovdg

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

 

chk_horrechten_dlchorprovsb

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

 

chk_horrechten_dlchorsltdel

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

 

chk_horrechten_dlchorsltedt

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

 

chk_horrechten_dlchorsltins

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

 

chk_horrechten_dlchorsltvsb

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

 

chk_horrechten_dlchorsptdel

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

 

chk_horrechten_dlchorsptedt

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

 

chk_horrechten_dlchorsptins

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

 

chk_horrechten_dlchorsptvsb

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

 

chk_horrechten_dlchorterdel

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

 

chk_horrechten_dlchorteredt

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

 

chk_horrechten_dlchorterins

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

 

chk_horrechten_dlchortervsb

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

 

chk_horrechten_horadvdatedt

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

 

chk_horrechten_horbepdel

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

 

chk_horrechten_horbepedt

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

 

chk_horrechten_horbepins

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

 

chk_horrechten_horbepvsb

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

 

chk_horrechten_horlokdel

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

 

chk_horrechten_horlokedt

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

 

chk_horrechten_horlokins

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

 

chk_horrechten_horlokvsb

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

 

chk_horrechten_horontdel

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

 

chk_horrechten_horontedt

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

 

chk_horrechten_horontins

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

 

chk_horrechten_horontvsb

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

 

chk_tbhorrechten_dlbhorhlink

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

 

chk_tbhorrechten_dlchoradvdms

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

 

chk_tbhorrechten_dlchorinsdms

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

 

chk_tbhorrechten_dlchorkladms

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

 

cnn_horrechten_dlbhorsnelins

dlbhorsnelins IS NOT NULL

 

cnn_horrechten_dlchorcordms

dlchorcordms IS NOT NULL

 

cnn_horrechten_dlchorcorodt

dlchorcorodt IS NOT NULL

 

cnn_horrechten_dnkeyrechten

dnkeyrechten IS NOT NULL

 

cnn_tbhorrechten_dlbhorhlink

dlbhorhlink IS NOT NULL

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbhorrechten

btree

 

dnkey

 

idu_horrechten_keyrechten

btree

 

dnkeyrechten

 

 

 

Triggers

There are no triggers for table tbhorrechten

 

Rules

There are no rules for table tbhorrechten

 

Referenced

There are no tables referenced by table tbhorrechten

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE public.tbhorrechten (
 dnkey SERIAL,
 dnkeyrechten INTEGER,
 dlbhoredt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorins CHAR(1) DEFAULT 'F'::bpchar,
 dlbhordel CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorblokkedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorverzledt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorgroepedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhormemovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorkopie CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorverplaats CHAR(1) DEFAULT 'F'::bpchar,
 dlchoribbvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchoribbedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchoribbins CHAR(1) DEFAULT 'F'::bpchar,
 dlchoribbdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorprovsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorproedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorproins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorprodel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorproahn CHAR(1) DEFAULT 'F'::bpchar,
 dlchorprovdg CHAR(1) DEFAULT 'F'::bpchar,
 dlchoradvvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchoradvedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchoradvins CHAR(1) DEFAULT 'F'::bpchar,
 dlchoradvdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorinsvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorinsedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorinsins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorinsdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcorvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcoredt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcorins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcordel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcadvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcadins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcaddel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlegvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlegedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlegins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlegdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlogvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlogedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlogins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlogdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcinvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcinins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcindel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorexplvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorexpledt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorexplins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorexpldel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorklavsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorklaedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorklains CHAR(1) DEFAULT 'F'::bpchar,
 dlchorkladel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorohfvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorohfedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorohfins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorohfdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchortervsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorteredt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorterins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorterdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorsptvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorsptedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorsptins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorsptdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorsltvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorsltedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorsltins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorsltdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcompr CHAR(1) DEFAULT 'F'::bpchar,
 dlchoradvinedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlegexpnot CHAR(1) DEFAULT 'F'::bpchar,
 dlbhormemoedt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorabedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchoradvdatedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorbepedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorbepvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorbepins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorbepdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlokedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlokvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlokins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorlokdel CHAR(1) DEFAULT 'F'::bpchar,
 dlchorontedt CHAR(1) DEFAULT 'F'::bpchar,
 dlchorontvsb CHAR(1) DEFAULT 'F'::bpchar,
 dlchorontins CHAR(1) DEFAULT 'F'::bpchar,
 dlchorontdel CHAR(1) DEFAULT 'F'::bpchar,
 dlbhoradedt CHAR(1) DEFAULT 'T'::bpchar,
 dlchorcordms CHAR(1) DEFAULT 'F'::bpchar,
 dlchorcorodt CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorsnelins CHAR(1) DEFAULT 'T'::bpchar,
 dlchoradvdms CHAR(1) DEFAULT 'F'::bpchar,
 dlchorinsdms CHAR(1) DEFAULT 'F'::bpchar,
 dlchorkladms CHAR(1) DEFAULT 'F'::bpchar,
 dlbhorhlink CHAR(1) DEFAULT 'F'::bpchar,
 CONSTRAINT cpk_tbhorrechten PRIMARY KEY(dnkey),
 CONSTRAINT chk_horrechten_dlbhorabedt CHECK (dlbhorabedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhoradedt CHECK (dlbhoradedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorblokkedt CHECK (dlbhorblokkedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhordel CHECK (dlbhordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhoredt CHECK (dlbhoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorgroepedt CHECK (dlbhorgroepedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorins CHECK (dlbhorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorkopie CHECK (dlbhorkopie = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhormemoedt CHECK (dlbhormemoedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhormemovsb CHECK (dlbhormemovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorsnelins CHECK (dlbhorsnelins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorverplaats CHECK (dlbhorverplaats = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlbhorverzledt CHECK (dlbhorverzledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoradvdel CHECK (dlchoradvdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoradvedt CHECK (dlchoradvedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoradvinedt CHECK (dlchoradvinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoradvins CHECK (dlchoradvins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoradvvsb CHECK (dlchoradvvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcaddel CHECK (dlchorcaddel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcadins CHECK (dlchorcadins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcadvsb CHECK (dlchorcadvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcindel CHECK (dlchorcindel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcinedt CHECK (dlchorcinedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcinins CHECK (dlchorcinins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcinvsb CHECK (dlchorcinvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcompr CHECK (dlchorcompr = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcordel CHECK (dlchorcordel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcordms CHECK (dlchorcordms = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcoredt CHECK (dlchorcoredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcorins CHECK (dlchorcorins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcorodt CHECK (dlchorcorodt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorcorvsb CHECK (dlchorcorvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorexpldel CHECK (dlchorexpldel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorexpledt CHECK (dlchorexpledt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorexplins CHECK (dlchorexplins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorexplvsb CHECK (dlchorexplvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoribbdel CHECK (dlchoribbdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoribbedt CHECK (dlchoribbedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoribbins CHECK (dlchoribbins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchoribbvsb CHECK (dlchoribbvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorinsdel CHECK (dlchorinsdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorinsedt CHECK (dlchorinsedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorinsins CHECK (dlchorinsins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorinsvsb CHECK (dlchorinsvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorkladel CHECK (dlchorkladel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorklaedt CHECK (dlchorklaedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorklains CHECK (dlchorklains = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorklavsb CHECK (dlchorklavsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlegdel CHECK (dlchorlegdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlegedt CHECK (dlchorlegedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlegexpnot CHECK (dlchorlegexpnot = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlegins CHECK (dlchorlegins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlegvsb CHECK (dlchorlegvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlogdel CHECK (dlchorlogdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlogedt CHECK (dlchorlogedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlogins CHECK (dlchorlogins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorlogvsb CHECK (dlchorlogvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorohfdel CHECK (dlchorohfdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorohfedt CHECK (dlchorohfedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorohfins CHECK (dlchorohfins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorohfvsb CHECK (dlchorohfvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorproahn CHECK (dlchorproahn = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorprodel CHECK (dlchorprodel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorproedt CHECK (dlchorproedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorproins CHECK (dlchorproins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorprovdg CHECK (dlchorprovdg = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorprovsb CHECK (dlchorprovsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorsltdel CHECK (dlchorsltdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorsltedt CHECK (dlchorsltedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorsltins CHECK (dlchorsltins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorsltvsb CHECK (dlchorsltvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorsptdel CHECK (dlchorsptdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorsptedt CHECK (dlchorsptedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorsptins CHECK (dlchorsptins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorsptvsb CHECK (dlchorsptvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorterdel CHECK (dlchorterdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorteredt CHECK (dlchorteredt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchorterins CHECK (dlchorterins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_dlchortervsb CHECK (dlchortervsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horadvdatedt CHECK (dlchoradvdatedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horbepdel CHECK (dlchorbepdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horbepedt CHECK (dlchorbepedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horbepins CHECK (dlchorbepins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horbepvsb CHECK (dlchorbepvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horlokdel CHECK (dlchorlokdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horlokedt CHECK (dlchorlokedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horlokins CHECK (dlchorlokins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horlokvsb CHECK (dlchorlokvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horontdel CHECK (dlchorontdel = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horontedt CHECK (dlchorontedt = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horontins CHECK (dlchorontins = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_horrechten_horontvsb CHECK (dlchorontvsb = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbhorrechten_dlbhorhlink CHECK (dlbhorhlink = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
 CONSTRAINT chk_tbhorrechten_dlchoradvdms CHECK (dlchoradvdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbhorrechten_dlchorinsdms CHECK (dlchorinsdms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT chk_tbhorrechten_dlchorkladms CHECK (dlchorkladms = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
 CONSTRAINT cnn_horrechten_dlbhorsnelins CHECK (dlbhorsnelins IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlchorcordms CHECK (dlchorcordms IS NOT NULL),
 CONSTRAINT cnn_horrechten_dlchorcorodt CHECK (dlchorcorodt IS NOT NULL),
 CONSTRAINT cnn_horrechten_dnkeyrechten CHECK (dnkeyrechten IS NOT NULL),
 CONSTRAINT cnn_tbhorrechten_dlbhorhlink CHECK (dlbhorhlink IS NOT NULL),
 CONSTRAINT cfk_horrechten_keyrechten FOREIGN KEY (dnkeyrechten)
   REFERENCES public.tbrechten(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
)
WITH (oids = false);

COMMENT ON TABLE public.tbhorrechten
IS 'Rechtentabel voor de module horeca';

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

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

COMMENT ON COLUMN public.tbhorrechten.dlbhoredt
IS 'Niveau B. Horeca. Editscherm wijzigbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorins
IS 'Niveau B. Horeca. Editscherm InsertRecht.';

COMMENT ON COLUMN public.tbhorrechten.dlbhordel
IS 'Niveau B. Horeca. Editscherm Verwijderecht.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorblokkedt
IS 'Niveau B. Horeca. Editscherm Blokkeerecht.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorverzledt
IS 'Niveau B. Horeca. Editscherm Verzendlijstsrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorgroepedt
IS 'Niveau B. Horeca. Editscherm Groepsvergunningrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlbhormemovsb
IS 'Niveau B. Horeca. Editscherm Memo zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorkopie
IS 'Niveau B. Horeca. Editscherm Kopieerrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorverplaats
IS 'Niveau B. Horeca. Editscherm verplaatsrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchoribbvsb
IS 'Niveau C. Horeca. In behandeling Bij zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchoribbedt
IS 'Niveau C. Horeca. In behandeling Bij muteerbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchoribbins
IS 'Niveau C. Horeca. In behandeling Bij Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchoribbdel
IS 'Niet meer in gebruik.';

COMMENT ON COLUMN public.tbhorrechten.dlchorprovsb
IS 'Niveau C. Horeca. Procedures zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorproedt
IS 'Niveau C. Horeca. Procedures muteerbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorproins
IS 'Niveau C. Horeca. Procedures Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorprodel
IS 'Niveau C. Horeca. Procedures verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorproahn
IS 'Niveau C. Horeca. Procedures aanhouden en termijn van orde.';

COMMENT ON COLUMN public.tbhorrechten.dlchorprovdg
IS 'Niveau C. Horeca. Procedures Verdagen.';

COMMENT ON COLUMN public.tbhorrechten.dlchoradvvsb
IS 'Niveau C. Horeca. Adviezen zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchoradvedt
IS 'Niveau C. Horeca. Adviezen muteerrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchoradvins
IS 'Niveau C. Horeca. Adviezen Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchoradvdel
IS 'Niveau C. Horeca. Adviezen verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorinsvsb
IS 'Niveau C. Horeca. Inspecties zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorinsedt
IS 'Niveau C. Horeca. Inspecties muteerrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorinsins
IS 'Niveau C. Horeca. Inspecties Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorinsdel
IS 'Niveau C. Horeca. Inspecties Verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcorvsb
IS 'Niveau C. Horeca. Correspondentie zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcoredt
IS 'Niveau C. Horeca. Correspondentie muteerbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcorins
IS 'Niveau C. Horeca. Correspondentie insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcordel
IS 'Niveau C. Horeca. Correspondentie verwijdererecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcadvsb
IS 'Niveau C. Horeca. Contactadressen zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcadins
IS 'Niveau C. Horeca. Contactadressen Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcaddel
IS 'Niveau C. Horeca. Contactadressen ontkoppelrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorlegvsb
IS 'Niveau C. Horeca. Leges zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorlegedt
IS 'Niveau C. Horeca. Leges muteerbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorlegins
IS 'Niveau C. Horeca. Leges Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorlegdel
IS 'Niveau C. Horeca. Leges verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorlogvsb
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbhorrechten.dlchorlogedt
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbhorrechten.dlchorlogins
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbhorrechten.dlchorlogdel
IS 'Wordt niet meer gebruikt sinds versie 307';

COMMENT ON COLUMN public.tbhorrechten.dlchorcinvsb
IS 'Niveau C. Horeca. Correspondentie binnenkomend zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcinedt
IS 'Niveau C. Horeca. Correspondentie binnenkomend muteerrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcinins
IS 'Niveau C. Horeca. Correspondentie binnenkomend Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcindel
IS 'Niveau C. Horeca. Correspondentie binnenkomend verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorexplvsb
IS 'Niveau C. Horeca. Expoitatie zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorexpledt
IS 'Niveau C. Horeca. Expoitatie muteerrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorexplins
IS 'Niveau C. Horeca. Expoitatie InsertRecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorexpldel
IS 'Niveau C. Horeca. Expoitatie Verwijdedrrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorklavsb
IS 'Niveau C. Horeca. Klachten zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorklaedt
IS 'Niveau C. Horeca. Klachten muteerecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorklains
IS 'Niveau C. Horeca. Klachten Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorkladel
IS 'Niveau C. Horeca. Klachten verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorohfvsb
IS 'Niveau C. Horeca. Ontheffingen zichtbaar. Wordt niet gebruikt.';

COMMENT ON COLUMN public.tbhorrechten.dlchorohfedt
IS 'Niveau C. Horeca. Ontheffingen muteerrecht. Wordt niet gebruikt.';

COMMENT ON COLUMN public.tbhorrechten.dlchorohfins
IS 'Niveau C. Horeca. Ontheffingen Insertrecht. Wordt niet gebruikt.';

COMMENT ON COLUMN public.tbhorrechten.dlchorohfdel
IS 'Niveau C. Horeca. Ontheffingen verwijderrecht. Wordt niet gebruikt.';

COMMENT ON COLUMN public.tbhorrechten.dlchortervsb
IS 'Niveau C. Horeca. Terras zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorteredt
IS 'Niveau C. Horeca. Terras muteerbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorterins
IS 'Niveau C. Horeca. Terras Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorterdel
IS 'Niveau C. Horeca. Terras verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorsptvsb
IS 'Niveau C. Horeca. Speelautomaten zichtbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorsptedt
IS 'Niveau C. Horeca. Speelautomaten muteerrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorsptins
IS 'Niveau C. Horeca. Speelautomaten Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorsptdel
IS 'Niveau C. Horeca. Speelautomaten Verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorsltvsb
IS 'Niveau C. Horeca. Sluitingstijden muteerbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchorsltins
IS 'Niveau C. Horeca. Sluitingstijden Insertrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorsltdel
IS 'Niveau C. Horeca. Sluitingstijden verwijderrecht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcompr
IS 'Niveau C. Horeca. Procedures ComprimeerRecht. Wordt niet gebruikt.';

COMMENT ON COLUMN public.tbhorrechten.dlchoradvinedt
IS 'Niveau C Horeca. Adviezen. Mag kolom Adviesinstantie wijzigen.';

COMMENT ON COLUMN public.tbhorrechten.dlchorlegexpnot
IS 'Niveau C. Horeca. Leges Notanummer en Exportdatum muteerbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlbhormemoedt
IS 'Niveau B. Horeca. Memo wijzigen.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorabedt
IS 'Niveau B. Horeca. Aard besluit en besluitdatum wijzigbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlchoradvdatedt
IS 'Niveau C. Adviezen. Wijzigrecht kolom DdDateringadvies van tabel TbAdviezen bij horeca (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorbepedt
IS 'Niveau C. HorecaBeperkingen wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorbepvsb
IS 'Niveau C. HorecaBeperkingen Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorbepins
IS 'Niveau C. HorecaBeperkingen insertrecht (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorbepdel
IS 'Niveau C. HorecaBeperkingen verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorlokedt
IS 'Niveau C. Horeca Lokaliteiten wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorlokvsb
IS 'niveau c. Horeca Lokaliteiten zichtbaar (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorlokins
IS 'Niveau C. Horeca Lokaliteiten insertrecht (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorlokdel
IS 'Niveau C. Horeca Lokalieiten  verwijderrecht (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorontedt
IS 'Niveau C. Horeca Ontheffingen  wijzigrecht (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorontvsb
IS 'Niveau C. Horeca Ontheffingen Zichtbaar (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorontins
IS 'Niveau C. Horeca Ontheffingen insertrecht (T of F).';

COMMENT ON COLUMN public.tbhorrechten.dlchorontdel
IS 'Niveau C. Horeca Ontheffingen verwijderrecht (T of F). ';

COMMENT ON COLUMN public.tbhorrechten.dlbhoradedt
IS 'Niveau B Horeca. Aanvraagdatum vergnr, en soortvergunning wijzigen recht.';

COMMENT ON COLUMN public.tbhorrechten.dlchorcordms
IS 'Niveau C. Horeca. Correspondentie. DMS-kolom muteerbaar';

COMMENT ON COLUMN public.tbhorrechten.dlchorcorodt
IS 'Niveau C. Horeca. Correspondentie. Opgeslagen document-kolom muteerbaar.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorsnelins
IS 'Niveau B. Horeca. Mag dvdmszaakcode wijzigen.';

COMMENT ON COLUMN public.tbhorrechten.dlchoradvdms
IS 'Niveau C. Horeca. Adviezen. Mag dvdmscode wijzigen.';

COMMENT ON COLUMN public.tbhorrechten.dlchorinsdms
IS 'Niveau C. Horeca. Inspecties. Mag dvdmscode wijzigen.';

COMMENT ON COLUMN public.tbhorrechten.dlchorkladms
IS 'Niveau C. Horeca. Klachten. Mag dvdmscode wijzigen.';

COMMENT ON COLUMN public.tbhorrechten.dlbhorhlink
IS 'Niveau B. Horeca. Mag hyperlink starten vanuit powerportal horecadetail.';

CREATE UNIQUE INDEX idu_horrechten_keyrechten ON public.tbhorrechten
 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