Datadictionary OpenWave 3.1.25 |
|
Table: tbmilstal
Datadictionary OpenWave 3.1.25 |
|
Table: tbmilstal
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met stallen per inrichting met uittrede en orientatie (tussentabel tussen tbmilemstal en tbmilinrichtingen)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilstal_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar tbmilinrichtingen.dnkey . |
|
|
dvstalnaam |
varchar(100) |
|
|
|
|
Naam van de stal |
|
|
dforientatie |
double precision |
|
|
|
|
Positieve hoek in graden tov noord/zuid |
|
|
dflengtegebouw |
double precision |
|
|
|
|
Lengte van gebouw in meters |
|
|
dfbreedtegebouw |
double precision |
|
|
|
|
Breedte van gebouw in meters |
|
|
dfhoogtegebouw |
double precision |
|
|
|
|
gemiddelde hoogte van gebouw in meters |
|
|
dvxcrd |
varchar(20) |
|
|
|
|
x-coordinaat geometrisch middelpunt stal |
|
|
dvycrd |
varchar(20) |
|
|
|
|
y-coordinaat geometrisch middelpunt stal |
|
|
dvgmlpolygoon |
varchar(4000) |
|
|
|
|
Countour van de stal als gml polygoon |
|
|
dfemissiehoogte |
double precision |
|
|
|
|
Hoogte van het emissieount in meters |
|
|
dvemissiexcrd |
varchar(20) |
|
|
|
|
x-ccordinaat emissiepunt |
|
|
dvemissieycrd |
varchar(20) |
|
|
|
|
y-ccordinaat emissiepunt |
|
|
dfemissiediameter |
double precision |
|
|
|
|
Inwendige diameter van het emissieount in meters |
|
|
dfuittredesneldheid |
double precision |
|
|
|
|
Vertikale uittredesneheid in m/s |
|
|
dvpandidentificatie |
varchar(16) |
|
|
|
|
Pand identificatiecode BAG |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Datum dat stal niet meer bestaat |
|
|
dfgmlradius |
double precision |
|
|
|
|
Radius in meters rondom het punt dvxcrd, dvycrd |
|
|
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 |
|
|
dvomsemissie |
varchar(200) |
|
|
|
|
Omschrijving emissiepunt |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilstal_keymilinr |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbmilstal_keymilomsradius |
dnkeyomsradius |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbmilstal_keymilinr |
dnkeymilinrichtingen IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilstal |
btree |
|
dnkey |
|
|
|
idx_tbmilstal_keymilinr |
btree |
|
dnkeymilinrichtingen |
|
|
|
Triggers
There are no triggers for table tbmilstal
Rules
There are no rules for table tbmilstal
Policies
There are no policies for table tbmilstal
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_tbmilemstal_keymilstal |
dnkeymilstal |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilinrichtingen INTEGER,
dvstalnaam VARCHAR(100),
dforientatie DOUBLE PRECISION,
dflengtegebouw DOUBLE PRECISION,
dfbreedtegebouw DOUBLE PRECISION,
dfhoogtegebouw DOUBLE PRECISION,
dvxcrd VARCHAR(20),
dvycrd VARCHAR(20),
dvgmlpolygoon VARCHAR(4000),
dfemissiehoogte DOUBLE PRECISION,
dvemissiexcrd VARCHAR(20),
dvemissieycrd VARCHAR(20),
dfemissiediameter DOUBLE PRECISION,
dfuittredesneldheid DOUBLE PRECISION,
dvpandidentificatie VARCHAR(16),
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
dfgmlradius DOUBLE PRECISION,
dnkeyomsradius INTEGER,
dvomsemissie VARCHAR(200),
CONSTRAINT cpk_tbmilstal PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbmilstal_keymilinr CHECK (dnkeymilinrichtingen IS NOT NULL),
CONSTRAINT cfk_tbmilstal_keymilinr FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilstal_keymilomsradius FOREIGN KEY (dnkeyomsradius)
REFERENCES public.tbmilomsradius(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilstal
IS 'Tabel met stallen per inrichting met uittrede en orientatie (tussentabel tussen tbmilemstal en tbmilinrichtingen)';
COMMENT ON COLUMN public.tbmilstal.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilstal.dnkeymilinrichtingen
IS 'Foreign key naar tbmilinrichtingen.dnkey .';
COMMENT ON COLUMN public.tbmilstal.dvstalnaam
IS 'Naam van de stal';
COMMENT ON COLUMN public.tbmilstal.dforientatie
IS 'Positieve hoek in graden tov noord/zuid';
COMMENT ON COLUMN public.tbmilstal.dflengtegebouw
IS 'Lengte van gebouw in meters';
COMMENT ON COLUMN public.tbmilstal.dfbreedtegebouw
IS 'Breedte van gebouw in meters';
COMMENT ON COLUMN public.tbmilstal.dfhoogtegebouw
IS 'gemiddelde hoogte van gebouw in meters';
COMMENT ON COLUMN public.tbmilstal.dvxcrd
IS 'x-coordinaat geometrisch middelpunt stal';
COMMENT ON COLUMN public.tbmilstal.dvycrd
IS 'y-coordinaat geometrisch middelpunt stal';
COMMENT ON COLUMN public.tbmilstal.dvgmlpolygoon
IS 'Countour van de stal als gml polygoon';
COMMENT ON COLUMN public.tbmilstal.dfemissiehoogte
IS 'Hoogte van het emissieount in meters';
COMMENT ON COLUMN public.tbmilstal.dvemissiexcrd
IS 'x-ccordinaat emissiepunt';
COMMENT ON COLUMN public.tbmilstal.dvemissieycrd
IS 'y-ccordinaat emissiepunt';
COMMENT ON COLUMN public.tbmilstal.dfemissiediameter
IS 'Inwendige diameter van het emissieount in meters';
COMMENT ON COLUMN public.tbmilstal.dfuittredesneldheid
IS 'Vertikale uittredesneheid in m/s';
COMMENT ON COLUMN public.tbmilstal.dvpandidentificatie
IS 'Pand identificatiecode BAG';
COMMENT ON COLUMN public.tbmilstal.ddvervaldatum
IS 'Datum dat stal niet meer bestaat';
COMMENT ON COLUMN public.tbmilstal.dfgmlradius
IS 'Radius in meters rondom het punt dvxcrd, dvycrd';
COMMENT ON COLUMN public.tbmilstal.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';
COMMENT ON COLUMN public.tbmilstal.dvomsemissie
IS 'Omschrijving emissiepunt';
CREATE INDEX idx_tbmilstal_keymilinr ON public.tbmilstal
USING btree (dnkeymilinrichtingen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|