Datadictionary OpenWave 3.1.11 |
|
Table: tbhorontheffingen
Datadictionary OpenWave 3.1.11 |
|
Table: tbhorontheffingen
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met ontheffingen per horeca-vergunning zoals ontheffingen van de sluitingstijden
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbhorontheffingen_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyhorvergunning |
integer |
|
|
|
|
Foreign key naar TbHorecavergunningen.dnkey. Deze is null indien dnkeymilinrichtingen is gevuld. |
|
|
dddatum |
timestamp |
|
|
|
|
Datum van ontheffing. |
|
|
dvtijd1van |
char(5) |
|
|
|
|
Tijdstip 1 vanaf. |
|
|
dvtijd1tot |
char(5) |
|
|
|
|
Tijdstip 1 tot. |
|
|
dvtijd2van |
char(5) |
|
|
|
|
Tijdstip 2 vanaf. |
|
|
dvtijd2tot |
char(5) |
|
|
|
|
Tijdstip 2 tot. |
|
|
dvnotitie |
varchar(60) |
|
|
|
|
Memoveldje. |
|
|
dnkeycontactadressen |
integer |
|
|
|
|
Foreign key naar TbContactadressen.dnkey Leidinggevende die op dag en tijd aanwezig is. |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar TbMilinrichtingen.dnkey. Deze is null indien dnkeyhorvergunning is gevuld. |
|
|
dnrubriek |
integer |
|
|
|
0 |
0 = onbekend, 4 = geluid, 11 = overig. |
|
|
dvgmlpolygoon |
varchar(4000) |
|
|
|
|
Contour van ontheffingspunt conform een gml polygoon |
|
|
dfgmlradius |
double precision |
|
|
|
|
Radius in meters rondom het punt dvxcrd, dvycrd |
|
|
dvbetekenisradius |
char(1) |
|
|
|
|
Heeft geen betekenis meer. Overgenomen door dnkeyomsradius |
|
|
dvxcrd |
varchar(20) |
|
|
|
|
X-coordinaat ontheffingspunt. |
|
|
dvycrd |
varchar(20) |
|
|
|
|
Y-coordinaat ontheffingspunt. |
|
|
dvzcrd |
varchar(20) |
|
|
|
|
Z-coordinaat ontheffingspunt. |
|
|
dnkeyomsradius |
integer |
|
|
|
|
Foreign key naar tbmilomsradius.dnkey (tabel met betekenis van de cirkel die getrokken kan worden met dfgmlradius: 1 = stank, 2 = gevaar, 3 = stof, 4 = geluid, 5 = explosie, 6 = overig, 7 = tril, 8 = onbekend |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbhoronth_keymilinr |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbhoronthef_dnkeyomsradius |
dnkeyomsradius |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbhoronthef_keycont |
dnkeycontactadressen |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbhoronthef_tbhorverg |
dnkeyhorvergunning |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbhoronth_keyverg |
((dnkeymilinrichtingen IS NOT NULL) AND (dnkeyhorvergunning IS NULL)) OR ((dnkeyhorvergunning IS NOT NULL) AND (dnkeymilinrichtingen IS NULL)) |
|
cnn_tbhoronthef_dnrubriek |
dnrubriek IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbhorontheffingen |
btree |
|
dnkey |
|
|
|
idx_horonthef_dddatum |
btree |
|
dddatum |
|
|
|
idx_horonthef_keycont |
btree |
|
dnkeycontactadressen |
|
|
|
idx_horonthef_keyhorverg |
btree |
|
dnkeyhorvergunning |
|
|
|
idx_tbhoronth_keymilinr |
btree |
|
dnkeymilinrichtingen |
|
|
|
Triggers
There are no triggers for table tbhorontheffingen
Rules
There are no rules for table tbhorontheffingen
Referenced
There are no tables referenced by table tbhorontheffingen
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyhorvergunning INTEGER,
dddatum TIMESTAMP WITHOUT TIME ZONE,
dvtijd1van CHAR(5),
dvtijd1tot CHAR(5),
dvtijd2van CHAR(5),
dvtijd2tot CHAR(5),
dvnotitie VARCHAR(60),
dnkeycontactadressen INTEGER,
dnkeymilinrichtingen INTEGER,
dnrubriek INTEGER DEFAULT 0,
dvgmlpolygoon VARCHAR(4000),
dfgmlradius DOUBLE PRECISION,
dvbetekenisradius CHAR(1),
dvxcrd VARCHAR(20),
dvycrd VARCHAR(20),
dvzcrd VARCHAR(20),
dnkeyomsradius INTEGER,
CONSTRAINT cpk_tbhorontheffingen PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbhoronth_keyverg CHECK (((dnkeymilinrichtingen IS NOT NULL) AND (dnkeyhorvergunning IS NULL)) OR ((dnkeyhorvergunning IS NOT NULL) AND (dnkeymilinrichtingen IS NULL))),
CONSTRAINT cnn_tbhoronthef_dnrubriek CHECK (dnrubriek IS NOT NULL),
CONSTRAINT cfk_tbhoronth_keymilinr FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbhoronthef_dnkeyomsradius FOREIGN KEY (dnkeyomsradius)
REFERENCES public.tbmilomsradius(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbhoronthef_keycont FOREIGN KEY (dnkeycontactadressen)
REFERENCES public.tbcontactadressen(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbhoronthef_tbhorverg FOREIGN KEY (dnkeyhorvergunning)
REFERENCES public.tbhorecavergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tbhorontheffingen
IS 'Tabel met ontheffingen per horeca-vergunning zoals ontheffingen van de sluitingstijden';
COMMENT ON COLUMN public.tbhorontheffingen.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbhorontheffingen.dnkeyhorvergunning
IS 'Foreign key naar TbHorecavergunningen.dnkey. Deze is null indien dnkeymilinrichtingen is gevuld.';
COMMENT ON COLUMN public.tbhorontheffingen.dddatum
IS 'Datum van ontheffing.';
COMMENT ON COLUMN public.tbhorontheffingen.dvtijd1van
IS 'Tijdstip 1 vanaf.';
COMMENT ON COLUMN public.tbhorontheffingen.dvtijd1tot
IS 'Tijdstip 1 tot.';
COMMENT ON COLUMN public.tbhorontheffingen.dvtijd2van
IS 'Tijdstip 2 vanaf.';
COMMENT ON COLUMN public.tbhorontheffingen.dvtijd2tot
IS 'Tijdstip 2 tot.';
COMMENT ON COLUMN public.tbhorontheffingen.dvnotitie
IS 'Memoveldje.';
COMMENT ON COLUMN public.tbhorontheffingen.dnkeycontactadressen
IS 'Foreign key naar TbContactadressen.dnkey Leidinggevende die op dag en tijd aanwezig is.';
COMMENT ON COLUMN public.tbhorontheffingen.dnkeymilinrichtingen
IS 'Foreign key naar TbMilinrichtingen.dnkey. Deze is null indien dnkeyhorvergunning is gevuld.';
COMMENT ON COLUMN public.tbhorontheffingen.dnrubriek
IS '0 = onbekend, 4 = geluid, 11 = overig.';
COMMENT ON COLUMN public.tbhorontheffingen.dvgmlpolygoon
IS 'Contour van ontheffingspunt conform een gml polygoon';
COMMENT ON COLUMN public.tbhorontheffingen.dfgmlradius
IS 'Radius in meters rondom het punt dvxcrd, dvycrd';
COMMENT ON COLUMN public.tbhorontheffingen.dvbetekenisradius
IS 'Heeft geen betekenis meer. Overgenomen door dnkeyomsradius';
COMMENT ON COLUMN public.tbhorontheffingen.dvxcrd
IS 'X-coordinaat ontheffingspunt.';
COMMENT ON COLUMN public.tbhorontheffingen.dvycrd
IS 'Y-coordinaat ontheffingspunt.';
COMMENT ON COLUMN public.tbhorontheffingen.dvzcrd
IS 'Z-coordinaat ontheffingspunt.';
COMMENT ON COLUMN public.tbhorontheffingen.dnkeyomsradius
IS 'Foreign key naar tbmilomsradius.dnkey (tabel met betekenis van de cirkel die getrokken kan worden met dfgmlradius: 1 = stank, 2 = gevaar, 3 = stof, 4 = geluid, 5 = explosie, 6 = overig, 7 = tril, 8 = onbekend';
CREATE INDEX idx_horonthef_dddatum ON public.tbhorontheffingen
USING btree (dddatum);
CREATE INDEX idx_horonthef_keycont ON public.tbhorontheffingen
USING btree (dnkeycontactadressen);
CREATE INDEX idx_horonthef_keyhorverg ON public.tbhorontheffingen
USING btree (dnkeyhorvergunning);
CREATE INDEX idx_tbhoronth_keymilinr ON public.tbhorontheffingen
USING btree (dnkeymilinrichtingen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|