Datadictionary OpenWave 3.1.25 |
|
Table: tbdroppublicaties
Datadictionary OpenWave 3.1.25 |
|
Table: tbdroppublicaties
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met publicaties via DROP voor aanvragen, ontwerpbesluiten en Besluiten per Mediatype en per Zaak
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbdroppublicaties_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyomgvergunningen |
integer |
|
|
|
|
Foreign key naar tbomgvergunning.dnkey. |
|
|
dnkeyovvergunningen |
integer |
|
|
|
|
Foreign key naar tbovvergunningen.dnkey. |
|
|
dnkeyhorecavergunningen |
integer |
|
|
|
|
Foreign key naar tbohorecavergunningen.dnkey. |
|
|
dnkeymilvergunningen |
integer |
|
|
|
|
Foreign key naar tbmilvergunningen.dnkey. |
|
|
dvmediatype |
varchar(2) |
|
|
|
|
Alleen de waarden OL (OnLine) GB (gemeenteblad), GS (gemeenschapsblad), WB (waterschapsblad), PR (provincieblad) of SC (staatscourant)toegestaan. |
|
|
dvdossiernr |
varchar(40) |
|
|
|
|
Dossiernummer van DROP indien geen fout |
|
|
dvdocumentnr |
varchar(40) |
|
|
|
|
Documentnummer van DROP indien WEL fout |
|
|
dverror |
varchar(200) |
|
|
|
|
Errorboodschap van DROP bij fout |
|
|
ddexportdatum |
timestamp |
|
|
|
|
Datum dat exportgegevens naar DROP zijn gegaan |
|
|
ddpublicatiedatum |
timestamp |
|
|
|
|
Datum met gewenste publicatiedatum |
|
|
dvpublicatietype |
char(1) |
|
|
|
|
Alleen A (aanvraag), B (besluit/beschikking) of O (ontwerpbesluit) of S (opschorten 415) of V (verlenging) of I (ingetrokken tijdens behandeling) |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_droppubl_keyhorvergun |
dnkeyhorecavergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_droppubl_keymilvergun |
dnkeymilvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_droppubl_keyomgvergun |
dnkeyomgvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_droppubl_keyovvergunningen |
dnkeyovvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_droppubl_dvmediatype |
(dvmediatype)::text = ANY ((ARRAY['GB'::character varying, 'GS'::character varying, 'WS'::character varying, 'PR'::character varying, 'SC'::character varying, 'OL'::character varying])::text[]) |
|
chk_droppubl_dvpubtype |
dvpublicatietype = ANY (ARRAY['A'::bpchar, 'B'::bpchar, 'I'::bpchar, 'O'::bpchar, 'S'::bpchar, 'V'::bpchar]) |
|
cnn_droppubl_dvmediatype |
dvmediatype IS NOT NULL |
|
cnn_droppubl_dvpubtype |
dvpublicatietype IS NOT NULL |
|
cnn_droppublicaties_keyverg |
((dnkeyovvergunningen IS NOT NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyovvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NOT NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyovvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NOT NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyovvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen IS NOT NULL)) |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbdroppublicaties |
btree |
|
dnkey |
|
|
|
idx_droppubl_keyhorverg |
btree |
|
dnkeyhorecavergunningen |
|
|
|
idx_droppubl_keymilverg |
btree |
|
dnkeymilvergunningen |
|
|
|
idx_droppubl_keyomgvergun |
btree |
|
dnkeyomgvergunningen |
|
|
|
idx_droppubl_keyovverg |
btree |
|
dnkeyovvergunningen |
|
|
|
Triggers
There are no triggers for table tbdroppublicaties
Rules
There are no rules for table tbdroppublicaties
Policies
There are no policies for table tbdroppublicaties
Referenced
There are no tables referenced by table tbdroppublicaties
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyomgvergunningen INTEGER,
dnkeyovvergunningen INTEGER,
dnkeyhorecavergunningen INTEGER,
dnkeymilvergunningen INTEGER,
dvmediatype VARCHAR(2),
dvdossiernr VARCHAR(40),
dvdocumentnr VARCHAR(40),
dverror VARCHAR(200),
ddexportdatum TIMESTAMP WITHOUT TIME ZONE,
ddpublicatiedatum TIMESTAMP WITHOUT TIME ZONE,
dvpublicatietype CHAR(1),
CONSTRAINT cpk_tbdroppublicaties PRIMARY KEY(dnkey),
CONSTRAINT chk_droppubl_dvmediatype CHECK ((dvmediatype)::text = ANY ((ARRAY['GB'::character varying, 'GS'::character varying, 'WS'::character varying, 'PR'::character varying, 'SC'::character varying, 'OL'::character varying])::text[])),
CONSTRAINT chk_droppubl_dvpubtype CHECK (dvpublicatietype = ANY (ARRAY['A'::bpchar, 'B'::bpchar, 'I'::bpchar, 'O'::bpchar, 'S'::bpchar, 'V'::bpchar])),
CONSTRAINT cnn_droppubl_dvmediatype CHECK (dvmediatype IS NOT NULL),
CONSTRAINT cnn_droppubl_dvpubtype CHECK (dvpublicatietype IS NOT NULL),
CONSTRAINT cnn_droppublicaties_keyverg CHECK (((dnkeyovvergunningen IS NOT NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyovvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NOT NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyovvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NOT NULL) AND (dnkeyomgvergunningen IS NULL)) OR ((dnkeyovvergunningen IS NULL) AND (dnkeyhorecavergunningen IS NULL) AND (dnkeymilvergunningen IS NULL) AND (dnkeyomgvergunningen IS NOT NULL))),
CONSTRAINT cfk_droppubl_keyhorvergun FOREIGN KEY (dnkeyhorecavergunningen)
REFERENCES public.tbhorecavergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_droppubl_keymilvergun FOREIGN KEY (dnkeymilvergunningen)
REFERENCES public.tbmilvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_droppubl_keyomgvergun FOREIGN KEY (dnkeyomgvergunningen)
REFERENCES public.tbomgvergunning(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_droppubl_keyovvergunningen FOREIGN KEY (dnkeyovvergunningen)
REFERENCES public.tbovvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbdroppublicaties
IS 'Tabel met publicaties via DROP voor aanvragen, ontwerpbesluiten en Besluiten per Mediatype en per Zaak';
COMMENT ON COLUMN public.tbdroppublicaties.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbdroppublicaties.dnkeyomgvergunningen
IS 'Foreign key naar tbomgvergunning.dnkey.';
COMMENT ON COLUMN public.tbdroppublicaties.dnkeyovvergunningen
IS 'Foreign key naar tbovvergunningen.dnkey.';
COMMENT ON COLUMN public.tbdroppublicaties.dnkeyhorecavergunningen
IS 'Foreign key naar tbohorecavergunningen.dnkey.';
COMMENT ON COLUMN public.tbdroppublicaties.dnkeymilvergunningen
IS 'Foreign key naar tbmilvergunningen.dnkey.';
COMMENT ON COLUMN public.tbdroppublicaties.dvmediatype
IS 'Alleen de waarden OL (OnLine) GB (gemeenteblad), GS (gemeenschapsblad), WB (waterschapsblad), PR (provincieblad) of SC (staatscourant)toegestaan.';
COMMENT ON COLUMN public.tbdroppublicaties.dvdossiernr
IS 'Dossiernummer van DROP indien geen fout';
COMMENT ON COLUMN public.tbdroppublicaties.dvdocumentnr
IS 'Documentnummer van DROP indien WEL fout';
COMMENT ON COLUMN public.tbdroppublicaties.dverror
IS 'Errorboodschap van DROP bij fout';
COMMENT ON COLUMN public.tbdroppublicaties.ddexportdatum
IS 'Datum dat exportgegevens naar DROP zijn gegaan';
COMMENT ON COLUMN public.tbdroppublicaties.ddpublicatiedatum
IS 'Datum met gewenste publicatiedatum';
COMMENT ON COLUMN public.tbdroppublicaties.dvpublicatietype
IS 'Alleen A (aanvraag), B (besluit/beschikking) of O (ontwerpbesluit) of S (opschorten 415) of V (verlenging) of I (ingetrokken tijdens behandeling)';
CREATE INDEX idx_droppubl_keyhorverg ON public.tbdroppublicaties
USING btree (dnkeyhorecavergunningen);
CREATE INDEX idx_droppubl_keymilverg ON public.tbdroppublicaties
USING btree (dnkeymilvergunningen);
CREATE INDEX idx_droppubl_keyomgvergun ON public.tbdroppublicaties
USING btree (dnkeyomgvergunningen);
CREATE INDEX idx_droppubl_keyovverg ON public.tbdroppublicaties
USING btree (dnkeyovvergunningen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|