Datadictionary OpenWave 3.1.25 |
|
Table: tbopschorten
Datadictionary OpenWave 3.1.25 |
|
Table: tbopschorten
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met redenen en termijnen voor opschorting verlenging per omgevingzaak of handhvaingzaak of horecazaak of apv/overige zaak of mileiugberuikzaak
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbopschorten_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeycodeopschort |
integer |
|
|
|
|
Foreign key naar tbcodeopschort.dnkey |
|
|
dnkeyomgvergunningen |
integer |
|
|
|
|
Foreign key naar tbomgvergunning.dnkey |
|
|
dnkeyovvergunningen |
integer |
|
|
|
|
Foreign key naar tbovvergunningen.dnkey |
|
|
dnkeyhorecavergunningen |
integer |
|
|
|
|
Foreign key naar tbhorecavergunningen.dnkey |
|
|
dnkeymilvergunningen |
integer |
|
|
|
|
Foreign key naar tbmilvergunningen.dnkey |
|
|
dnkeyhandhavingen |
integer |
|
|
|
|
Foreign key naar tbhandhavingen.dnkey |
|
|
ddstartdatum |
timestamp |
|
|
|
|
Datum ingang opschortende werking/verlenging |
|
|
ddeinddatum |
timestamp |
|
|
|
|
Datum einde opschortende werking/verlenging |
|
|
dntermijn |
integer |
|
|
|
|
Termijn in dagen tussen ddstartdatum en ddeinddatum |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_opschorten_keycodeopschort |
dnkeycodeopschort |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_opschorten_keyhandhaving |
dnkeyhandhavingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_opschorten_keyhoreca |
dnkeyhorecavergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_opschorten_keymilverg |
dnkeymilvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_opschorten_keyomgeving |
dnkeyomgvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_opschorten_keyovverg |
dnkeyovvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_opschorten_ddstartdatum |
ddstartdatum IS NOT NULL |
|
cnn_opschorten_keycodeopschort |
dnkeycodeopschort IS NOT NULL |
|
cnn_opschorten_keyzaak |
((dnkeymilvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyhandhavingen IS NOT NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyhorecavergunningen IS NOT NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyovvergunningen IS NOT NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyomgvergunningen IS NOT NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeyovvergunningen IS NULL)) |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbopschorten |
btree |
|
dnkey |
|
|
|
idx_opschorten_keyhandh |
btree |
|
dnkeyhandhavingen |
|
|
|
idx_opschorten_keyhorverg |
btree |
|
dnkeyhorecavergunningen |
|
|
|
idx_opschorten_keymilverg |
btree |
|
dnkeymilvergunningen |
|
|
|
idx_opschorten_keyomgverg |
btree |
|
dnkeyomgvergunningen |
|
|
|
idx_opschorten_keyovverg |
btree |
|
dnkeyovvergunningen |
|
|
|
Triggers
There are no triggers for table tbopschorten
Rules
There are no rules for table tbopschorten
Policies
There are no policies for table tbopschorten
Referenced
There are no tables referenced by table tbopschorten
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeycodeopschort INTEGER,
dnkeyomgvergunningen INTEGER,
dnkeyovvergunningen INTEGER,
dnkeyhorecavergunningen INTEGER,
dnkeymilvergunningen INTEGER,
dnkeyhandhavingen INTEGER,
ddstartdatum TIMESTAMP WITHOUT TIME ZONE,
ddeinddatum TIMESTAMP WITHOUT TIME ZONE,
dntermijn INTEGER,
CONSTRAINT cpk_tbopschorten PRIMARY KEY(dnkey),
CONSTRAINT cnn_opschorten_ddstartdatum CHECK (ddstartdatum IS NOT NULL),
CONSTRAINT cnn_opschorten_keycodeopschort CHECK (dnkeycodeopschort IS NOT NULL),
CONSTRAINT cnn_opschorten_keyzaak CHECK (((dnkeymilvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyhandhavingen IS NOT NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyhorecavergunningen IS NOT NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyovvergunningen IS NOT NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyomgvergunningen IS NOT NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyhandhavingen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeyovvergunningen IS NULL))),
CONSTRAINT cfk_opschorten_keycodeopschort FOREIGN KEY (dnkeycodeopschort)
REFERENCES public.tbcodeopschort(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_opschorten_keyhandhaving FOREIGN KEY (dnkeyhandhavingen)
REFERENCES public.tbhandhavingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_opschorten_keyhoreca FOREIGN KEY (dnkeyhorecavergunningen)
REFERENCES public.tbhorecavergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_opschorten_keymilverg FOREIGN KEY (dnkeymilvergunningen)
REFERENCES public.tbmilvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_opschorten_keyomgeving FOREIGN KEY (dnkeyomgvergunningen)
REFERENCES public.tbomgvergunning(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_opschorten_keyovverg FOREIGN KEY (dnkeyovvergunningen)
REFERENCES public.tbovvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbopschorten
IS 'Tabel met redenen en termijnen voor opschorting verlenging per omgevingzaak of handhvaingzaak of horecazaak of apv/overige zaak of mileiugberuikzaak';
COMMENT ON COLUMN public.tbopschorten.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbopschorten.dnkeycodeopschort
IS 'Foreign key naar tbcodeopschort.dnkey';
COMMENT ON COLUMN public.tbopschorten.dnkeyomgvergunningen
IS 'Foreign key naar tbomgvergunning.dnkey';
COMMENT ON COLUMN public.tbopschorten.dnkeyovvergunningen
IS 'Foreign key naar tbovvergunningen.dnkey';
COMMENT ON COLUMN public.tbopschorten.dnkeyhorecavergunningen
IS 'Foreign key naar tbhorecavergunningen.dnkey';
COMMENT ON COLUMN public.tbopschorten.dnkeymilvergunningen
IS 'Foreign key naar tbmilvergunningen.dnkey';
COMMENT ON COLUMN public.tbopschorten.dnkeyhandhavingen
IS 'Foreign key naar tbhandhavingen.dnkey';
COMMENT ON COLUMN public.tbopschorten.ddstartdatum
IS 'Datum ingang opschortende werking/verlenging';
COMMENT ON COLUMN public.tbopschorten.ddeinddatum
IS 'Datum einde opschortende werking/verlenging';
COMMENT ON COLUMN public.tbopschorten.dntermijn
IS 'Termijn in dagen tussen ddstartdatum en ddeinddatum';
CREATE INDEX idx_opschorten_keyhandh ON public.tbopschorten
USING btree (dnkeyhandhavingen);
CREATE INDEX idx_opschorten_keyhorverg ON public.tbopschorten
USING btree (dnkeyhorecavergunningen);
CREATE INDEX idx_opschorten_keymilverg ON public.tbopschorten
USING btree (dnkeymilvergunningen);
CREATE INDEX idx_opschorten_keyomgverg ON public.tbopschorten
USING btree (dnkeyomgvergunningen);
CREATE INDEX idx_opschorten_keyovverg ON public.tbopschorten
USING btree (dnkeyovvergunningen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|