Datadictionary OpenWave 3.1.25 |
|
Table: tbmilemwateig
Datadictionary OpenWave 3.1.25 |
|
Table: tbmilemwateig
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Wordt niet gebruikt sinds OW versie 1.13 (database 3.1.16). Tabel met eigenschappen van het lozingswater per waterlozingpunt (tbmilemwater)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilemwateig_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilemwater |
integer |
|
|
|
|
Foreign key naar TbMilEmwater.dnkey |
|
|
dvomschrijving |
varchar(60) |
|
|
|
|
Omschrijving van de eigenschap. |
|
|
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_tbmilemwateig_tbmilemwater |
dnkeymilemwater |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_milemwateig_keyemwater |
dnkeymilemwater IS NOT NULL |
|
cnn_milemwateig_oms |
dvomschrijving IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilemwateig |
btree |
|
dnkey |
|
|
|
idx_milemwateig_keymilemwater |
btree |
|
dnkeymilemwater |
|
|
|
Triggers
There are no triggers for table tbmilemwateig
Rules
There are no rules for table tbmilemwateig
Policies
There are no policies for table tbmilemwateig
Referenced
There are no tables referenced by table tbmilemwateig
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilemwater INTEGER,
dvomschrijving VARCHAR(60),
dvopmerking VARCHAR(100),
dfhoeveelheid DOUBLE PRECISION,
dveenheid VARCHAR(25),
ddmeetdatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbmilemwateig PRIMARY KEY(dnkey),
CONSTRAINT cnn_milemwateig_keyemwater CHECK (dnkeymilemwater IS NOT NULL),
CONSTRAINT cnn_milemwateig_oms CHECK (dvomschrijving IS NOT NULL),
CONSTRAINT cfk_tbmilemwateig_tbmilemwater FOREIGN KEY (dnkeymilemwater)
REFERENCES public.tbmilemwater(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilemwateig
IS 'Wordt niet gebruikt sinds OW versie 1.13 (database 3.1.16). Tabel met eigenschappen van het lozingswater per waterlozingpunt (tbmilemwater)';
COMMENT ON COLUMN public.tbmilemwateig.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilemwateig.dnkeymilemwater
IS 'Foreign key naar TbMilEmwater.dnkey';
COMMENT ON COLUMN public.tbmilemwateig.dvomschrijving
IS 'Omschrijving van de eigenschap.';
COMMENT ON COLUMN public.tbmilemwateig.dfhoeveelheid
IS 'Hoeveelheid.';
COMMENT ON COLUMN public.tbmilemwateig.dveenheid
IS 'Bijv gr per m3.';
COMMENT ON COLUMN public.tbmilemwateig.ddmeetdatum
IS 'Datum van meting.';
CREATE INDEX idx_milemwateig_keymilemwater ON public.tbmilemwateig
USING btree (dnkeymilemwater);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|