Datadictionary OpenWave 3.1.25 |
|
Table: tbmildiversen
Datadictionary OpenWave 3.1.25 |
|
Table: tbmildiversen
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel waarin per inrichting diverse gegevens zijn vast te leggen zoals geluid en energie
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmildiversen_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar TbMilInrichtingen.dnkey |
|
|
dnkeymilsrtdivers |
integer |
|
|
|
|
Foreign key naar TbMilSrtDivers.dnkey |
|
|
dvnaamdivers |
varchar(60) |
|
|
|
|
Naam van Aspect. |
|
|
dvnormering |
varchar(2000) |
|
|
|
|
Beschrijving van de normering. |
|
|
dvopmerking |
varchar(100) |
|
|
|
|
|
|
|
dvxcrd |
varchar(20) |
|
|
|
|
X-coordinaat punt. |
|
|
dvycrd |
varchar(20) |
|
|
|
|
Y-coordinaat punt. |
|
|
dvzcrd |
varchar(20) |
|
|
|
|
Z-coordinaat punt. |
|
|
dvgmlpolygoon |
varchar(4000) |
|
|
|
|
Contour van punt 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 |
|
|
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_tbmildivers_dnkeyomsradius |
dnkeyomsradius |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbmildiversen_tbmilinr |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbmildiversen_tbmilsrtdiv |
dnkeymilsrtdivers |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_mildiversen_keyinricht |
dnkeymilinrichtingen IS NOT NULL |
|
cnn_mildiversen_keysrtdiv |
dnkeymilsrtdivers IS NOT NULL |
|
cnn_mildiversen_naamdiv |
dvnaamdivers IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmildiversen |
btree |
|
dnkey |
|
|
|
idx_mildiversen_keymilinr |
btree |
|
dnkeymilinrichtingen |
|
|
|
idx_mildiversen_keymilsrtdiv |
btree |
|
dnkeymilsrtdivers |
|
|
|
Triggers
There are no triggers for table tbmildiversen
Rules
There are no rules for table tbmildiversen
Policies
There are no policies for table tbmildiversen
Referenced
There are no tables referenced by table tbmildiversen
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilinrichtingen INTEGER,
dnkeymilsrtdivers INTEGER,
dvnaamdivers VARCHAR(60),
dvnormering VARCHAR(2000),
dvopmerking VARCHAR(100),
dvxcrd VARCHAR(20),
dvycrd VARCHAR(20),
dvzcrd VARCHAR(20),
dvgmlpolygoon VARCHAR(4000),
dfgmlradius DOUBLE PRECISION,
dvbetekenisradius CHAR(1),
dnkeyomsradius INTEGER,
CONSTRAINT cpk_tbmildiversen PRIMARY KEY(dnkey),
CONSTRAINT cnn_mildiversen_keyinricht CHECK (dnkeymilinrichtingen IS NOT NULL),
CONSTRAINT cnn_mildiversen_keysrtdiv CHECK (dnkeymilsrtdivers IS NOT NULL),
CONSTRAINT cnn_mildiversen_naamdiv CHECK (dvnaamdivers IS NOT NULL),
CONSTRAINT cfk_tbmildivers_dnkeyomsradius FOREIGN KEY (dnkeyomsradius)
REFERENCES public.tbmilomsradius(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmildiversen_tbmilinr FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmildiversen_tbmilsrtdiv FOREIGN KEY (dnkeymilsrtdivers)
REFERENCES public.tbmilsrtdivers(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmildiversen
IS 'Tabel waarin per inrichting diverse gegevens zijn vast te leggen zoals geluid en energie';
COMMENT ON COLUMN public.tbmildiversen.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmildiversen.dnkeymilinrichtingen
IS 'Foreign key naar TbMilInrichtingen.dnkey';
COMMENT ON COLUMN public.tbmildiversen.dnkeymilsrtdivers
IS 'Foreign key naar TbMilSrtDivers.dnkey';
COMMENT ON COLUMN public.tbmildiversen.dvnaamdivers
IS 'Naam van Aspect.';
COMMENT ON COLUMN public.tbmildiversen.dvnormering
IS 'Beschrijving van de normering.';
COMMENT ON COLUMN public.tbmildiversen.dvxcrd
IS 'X-coordinaat punt.';
COMMENT ON COLUMN public.tbmildiversen.dvycrd
IS 'Y-coordinaat punt.';
COMMENT ON COLUMN public.tbmildiversen.dvzcrd
IS 'Z-coordinaat punt.';
COMMENT ON COLUMN public.tbmildiversen.dvgmlpolygoon
IS 'Contour van punt conform een gml polygoon';
COMMENT ON COLUMN public.tbmildiversen.dfgmlradius
IS 'Radius in meters rondom het punt dvxcrd, dvycrd';
COMMENT ON COLUMN public.tbmildiversen.dvbetekenisradius
IS 'Heeft geen betekenis meer. Overgenomen door dnkeyomsradius';
COMMENT ON COLUMN public.tbmildiversen.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_mildiversen_keymilinr ON public.tbmildiversen
USING btree (dnkeymilinrichtingen);
CREATE INDEX idx_mildiversen_keymilsrtdiv ON public.tbmildiversen
USING btree (dnkeymilsrtdivers);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|