Datadictionary OpenWave 3.1.25 |
|
Table: tbmilemlctstof
Datadictionary OpenWave 3.1.25 |
|
Table: tbmilemlctstof
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Wordt niet gebruikt sinds OW versie 1.13 (database 3.1.16). Tabel waarin per luchtemissiepunt (tbmilemlucht) stoffen geregistreerd worden die in de luchtemissie voorkomen
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilemlctstof_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilemlucht |
integer |
|
|
|
|
Foreign key naar TbMilEmLucht.dnkey |
|
|
dnkeymilcodestof |
integer |
|
|
|
|
Foreign key naar TbMilCodeStof.dnkey |
|
|
dvopmerking |
varchar(100) |
|
|
|
|
|
|
|
dfhoeveelheid |
double precision |
|
|
|
|
Hoeveelheid. |
|
|
dveenheid |
varchar(25) |
|
|
|
|
Bijv gr per m3. |
|
|
ddmeetdatum |
timestamp |
|
|
|
|
Datum van meting. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilemlctst_tbmilcodest |
dnkeymilcodestof |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbmilemlctst_tbmilemlucht |
dnkeymilemlucht |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_milemlctst_keycodest |
dnkeymilcodestof IS NOT NULL |
|
cnn_milemlctst_keyemlucht |
dnkeymilemlucht IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilemlctstof |
btree |
|
dnkey |
|
|
|
idx_milemlctst_keymilcodest |
btree |
|
dnkeymilcodestof |
|
|
|
idx_milemlctst_keymilemlucht |
btree |
|
dnkeymilemlucht |
|
|
|
Triggers
There are no triggers for table tbmilemlctstof
Rules
There are no rules for table tbmilemlctstof
Policies
There are no policies for table tbmilemlctstof
Referenced
There are no tables referenced by table tbmilemlctstof
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilemlucht INTEGER,
dnkeymilcodestof INTEGER,
dvopmerking VARCHAR(100),
dfhoeveelheid DOUBLE PRECISION,
dveenheid VARCHAR(25),
ddmeetdatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbmilemlctstof PRIMARY KEY(dnkey),
CONSTRAINT cnn_milemlctst_keycodest CHECK (dnkeymilcodestof IS NOT NULL),
CONSTRAINT cnn_milemlctst_keyemlucht CHECK (dnkeymilemlucht IS NOT NULL),
CONSTRAINT cfk_tbmilemlctst_tbmilcodest FOREIGN KEY (dnkeymilcodestof)
REFERENCES public.tbmilcodestof(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilemlctst_tbmilemlucht FOREIGN KEY (dnkeymilemlucht)
REFERENCES public.tbmilemlucht(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilemlctstof
IS 'Wordt niet gebruikt sinds OW versie 1.13 (database 3.1.16). Tabel waarin per luchtemissiepunt (tbmilemlucht) stoffen geregistreerd worden die in de luchtemissie voorkomen';
COMMENT ON COLUMN public.tbmilemlctstof.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilemlctstof.dnkeymilemlucht
IS 'Foreign key naar TbMilEmLucht.dnkey';
COMMENT ON COLUMN public.tbmilemlctstof.dnkeymilcodestof
IS 'Foreign key naar TbMilCodeStof.dnkey';
COMMENT ON COLUMN public.tbmilemlctstof.dfhoeveelheid
IS 'Hoeveelheid.';
COMMENT ON COLUMN public.tbmilemlctstof.dveenheid
IS 'Bijv gr per m3.';
COMMENT ON COLUMN public.tbmilemlctstof.ddmeetdatum
IS 'Datum van meting.';
CREATE INDEX idx_milemlctst_keymilcodest ON public.tbmilemlctstof
USING btree (dnkeymilcodestof);
CREATE INDEX idx_milemlctst_keymilemlucht ON public.tbmilemlctstof
USING btree (dnkeymilemlucht);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|