Datadictionary OpenWave 3.1.25 |
|
Table: tbhorklachten
Datadictionary OpenWave 3.1.25 |
|
Table: tbhorklachten
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Deprecated sinds open-wave cersie 3.1.13. Tabel met klachten per horeca-vergunning
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbhorklachten_dnkey_seq'::regclass) |
Deprecated sinds versie 1.13. Primary key. |
|
|
dnkeyhorecavergunningen |
integer |
|
|
|
|
Deprecated sinds versie 1.13. Foreign key naar TbHorecavergunningen.dnkey. |
|
|
dddatumklacht |
timestamp |
|
|
|
|
Deprecated sinds versie 1.13. Datum klacht. |
|
|
dvomschrijving |
varchar(200) |
|
|
|
|
Deprecated sinds versie 1.13.Omschrijving klacht. |
|
|
dnkeyhorsoortklacht |
integer |
|
|
|
|
Deprecated sinds versie 1.13. Foreign key naar 100 TbHorSoortKlacht.dnkey. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_horklacht_horecaverg |
dnkeyhorecavergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_horklacht_horsoortklacht |
dnkeyhorsoortklacht |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_horklacht_dnkeyhorverg |
dnkeyhorecavergunningen IS NOT NULL |
|
cnn_horklacht_dnkeysrtklacht |
dnkeyhorsoortklacht IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbhorklachten |
btree |
|
dnkey |
|
|
|
idx_horklachten_horecaverg |
btree |
|
dnkeyhorecavergunningen |
|
|
|
idx_horklachten_horsoortklacht |
btree |
|
dnkeyhorsoortklacht |
|
|
|
Triggers
There are no triggers for table tbhorklachten
Rules
There are no rules for table tbhorklachten
Policies
There are no policies for table tbhorklachten
Referenced
There are no tables referenced by table tbhorklachten
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyhorecavergunningen INTEGER,
dddatumklacht TIMESTAMP WITHOUT TIME ZONE,
dvomschrijving VARCHAR(200),
dnkeyhorsoortklacht INTEGER,
CONSTRAINT cpk_tbhorklachten PRIMARY KEY(dnkey),
CONSTRAINT cnn_horklacht_dnkeyhorverg CHECK (dnkeyhorecavergunningen IS NOT NULL),
CONSTRAINT cnn_horklacht_dnkeysrtklacht CHECK (dnkeyhorsoortklacht IS NOT NULL),
CONSTRAINT cfk_horklacht_horecaverg FOREIGN KEY (dnkeyhorecavergunningen)
REFERENCES public.tbhorecavergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_horklacht_horsoortklacht FOREIGN KEY (dnkeyhorsoortklacht)
REFERENCES public.tbhorsoortklacht(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbhorklachten
IS 'Deprecated sinds open-wave cersie 3.1.13. Tabel met klachten per horeca-vergunning';
COMMENT ON COLUMN public.tbhorklachten.dnkey
IS 'Deprecated sinds versie 1.13. Primary key.';
COMMENT ON COLUMN public.tbhorklachten.dnkeyhorecavergunningen
IS 'Deprecated sinds versie 1.13. Foreign key naar TbHorecavergunningen.dnkey.';
COMMENT ON COLUMN public.tbhorklachten.dddatumklacht
IS 'Deprecated sinds versie 1.13. Datum klacht.';
COMMENT ON COLUMN public.tbhorklachten.dvomschrijving
IS 'Deprecated sinds versie 1.13.Omschrijving klacht.';
COMMENT ON COLUMN public.tbhorklachten.dnkeyhorsoortklacht
IS 'Deprecated sinds versie 1.13. Foreign key naar 100 TbHorSoortKlacht.dnkey.';
CREATE INDEX idx_horklachten_horecaverg ON public.tbhorklachten
USING btree (dnkeyhorecavergunningen);
CREATE INDEX idx_horklachten_horsoortklacht ON public.tbhorklachten
USING btree (dnkeyhorsoortklacht);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|