Datadictionary OpenWave 3.1.33 |
|
Table: tbhorexploitatie
Datadictionary OpenWave 3.1.33 |
|
Table: tbhorexploitatie
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel van exploitatievergunningen per horecavergunning
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbhorexploitatie_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyhorecavergunningen |
integer |
|
|
|
|
Foreign key naar TbHorecavergunningen.dnkey. |
|
|
dvvergnummer |
varchar(20) |
|
|
|
|
Exploitatie vergunning nummer. |
|
|
ddverleendvan |
timestamp |
|
|
|
|
Vergunning geldig vanaf datum. |
|
|
ddverleendtot |
timestamp |
|
|
|
|
Vergunning geldig t/m datum (vervaldatum). |
|
|
dvomschrijving |
varchar(2000) |
|
|
|
|
Omschrijving exploitatie. |
|
|
dnkeysoortexpl |
integer |
|
|
|
|
Foreign key naar TbHorSoortExploitatie.dnkey. |
|
|
dvmemo |
text |
|
|
|
|
Memo. LET OP Deze memo wordt sedert databaseversie 3.1.28 NIET meer gezipt/gecrypt opgeslagen. |
|
|
dvsoortoverig |
varchar(50) |
|
|
|
|
Vrije omschrijving. |
|
|
dnkeyomgvergunningen |
integer |
|
|
|
|
Foreign key naar omgevingszaak waarin de bovenliggende zaak is opgegaan (tbomgvergunning.dnkey). |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_horexpl_horecaverg |
dnkeyhorecavergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_horexploit_soortexpl |
dnkeysoortexpl |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbhorexploitatie_dnkeyomgverg |
dnkeyomgvergunningen |
dnkey |
Set Null |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_horexpl_dnkeyhorverg |
dnkeyhorecavergunningen IS NOT NULL |
|
cnn_horexpl_dvvergnummer |
dvvergnummer IS NOT NULL |
|
cnn_horexpl_keysoortexpl |
dnkeysoortexpl IS NOT NULL |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbhorexploitatie |
btree |
|
dnkey |
|
|
|
idx_horexpl_horecaverg |
btree |
|
dnkeyhorecavergunningen |
|
|
|
idx_horexploitatie_soortexpl |
btree |
|
dnkeysoortexpl |
|
|
|
Triggers
There are no triggers for table tbhorexploitatie
Rules
There are no rules for table tbhorexploitatie
Policies
There are no policies for table tbhorexploitatie
Referenced
There are no tables referenced by table tbhorexploitatie
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyhorecavergunningen INTEGER STORAGE PLAIN,
dvvergnummer VARCHAR(20),
ddverleendvan TIMESTAMP WITHOUT TIME ZONE STORAGE PLAIN,
ddverleendtot TIMESTAMP WITHOUT TIME ZONE STORAGE PLAIN,
dvomschrijving VARCHAR(2000),
dnkeysoortexpl INTEGER STORAGE PLAIN,
dvmemo TEXT,
dvsoortoverig VARCHAR(50),
dnkeyomgvergunningen INTEGER STORAGE PLAIN,
CONSTRAINT cpk_tbhorexploitatie PRIMARY KEY(dnkey),
CONSTRAINT cnn_horexpl_dnkeyhorverg CHECK (dnkeyhorecavergunningen IS NOT NULL),
CONSTRAINT cnn_horexpl_dvvergnummer CHECK (dvvergnummer IS NOT NULL),
CONSTRAINT cnn_horexpl_keysoortexpl CHECK (dnkeysoortexpl IS NOT NULL),
CONSTRAINT cfk_horexpl_horecaverg FOREIGN KEY (dnkeyhorecavergunningen)
REFERENCES public.tbhorecavergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_horexploit_soortexpl FOREIGN KEY (dnkeysoortexpl)
REFERENCES public.tbhorsoortexploitatie(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbhorexploitatie_dnkeyomgverg FOREIGN KEY (dnkeyomgvergunningen)
REFERENCES public.tbomgvergunning(dnkey)
ON DELETE SET NULL
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbhorexploitatie
IS 'Tabel van exploitatievergunningen per horecavergunning';
COMMENT ON COLUMN public.tbhorexploitatie.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbhorexploitatie.dnkeyhorecavergunningen
IS 'Foreign key naar TbHorecavergunningen.dnkey.';
COMMENT ON COLUMN public.tbhorexploitatie.dvvergnummer
IS 'Exploitatie vergunning nummer.';
COMMENT ON COLUMN public.tbhorexploitatie.ddverleendvan
IS 'Vergunning geldig vanaf datum.';
COMMENT ON COLUMN public.tbhorexploitatie.ddverleendtot
IS 'Vergunning geldig t/m datum (vervaldatum).';
COMMENT ON COLUMN public.tbhorexploitatie.dvomschrijving
IS 'Omschrijving exploitatie.';
COMMENT ON COLUMN public.tbhorexploitatie.dnkeysoortexpl
IS 'Foreign key naar TbHorSoortExploitatie.dnkey.';
COMMENT ON COLUMN public.tbhorexploitatie.dvmemo
IS 'Memo. LET OP Deze memo wordt sedert databaseversie 3.1.28 NIET meer gezipt/gecrypt opgeslagen.';
COMMENT ON COLUMN public.tbhorexploitatie.dvsoortoverig
IS 'Vrije omschrijving.';
COMMENT ON COLUMN public.tbhorexploitatie.dnkeyomgvergunningen
IS 'Foreign key naar omgevingszaak waarin de bovenliggende zaak is opgegaan (tbomgvergunning.dnkey).';
CREATE INDEX idx_horexpl_horecaverg ON public.tbhorexploitatie
USING btree (dnkeyhorecavergunningen);
CREATE INDEX idx_horexploitatie_soortexpl ON public.tbhorexploitatie
USING btree (dnkeysoortexpl);
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 21-10-2025 10:22 |
|