Datadictionary OpenWave 3.1.25 |
|
Table: tbmilemwatvoorz
Datadictionary OpenWave 3.1.25 |
|
Table: tbmilemwatvoorz
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met emissiebeperkende voorzieningen (zie tbmilsrtvoorz) per watertemissiepunt (tbmilemwater)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilemwatvoorz_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilemwater |
integer |
|
|
|
|
Foreign key naar TbMilEmwater.dnkey |
|
|
dnkeymilsrtvoorz |
integer |
|
|
|
|
Foreign key naar TbMilSrtVoorz.dnkey |
|
|
dvopmerking |
varchar(100) |
|
|
|
|
|
|
|
dlcontrvoorzaanw |
char(1) |
|
|
|
'F'::bpchar |
T of F of null. Indien T dan is een een controlevoorziening aanwezig. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilemwatvz_tbmilemwater |
dnkeymilemwater |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbmilemwatvz_tbmilsrtvz |
dnkeymilsrtvoorz |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_milemwatvz_dlcontrvza |
dlcontrvoorzaanw = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
cnn_milemwatvz_keyemwater |
dnkeymilemwater IS NOT NULL |
|
cnn_milemwatvz_keysrtvoorz |
dnkeymilsrtvoorz IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilemwatvoorz |
btree |
|
dnkey |
|
|
|
idx_milemwatvz_keymilemwater |
btree |
|
dnkeymilemwater |
|
|
|
idx_milemwatvz_keymilsrtvz |
btree |
|
dnkeymilsrtvoorz |
|
|
|
Triggers
There are no triggers for table tbmilemwatvoorz
Rules
There are no rules for table tbmilemwatvoorz
Policies
There are no policies for table tbmilemwatvoorz
Referenced
There are no tables referenced by table tbmilemwatvoorz
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilemwater INTEGER,
dnkeymilsrtvoorz INTEGER,
dvopmerking VARCHAR(100),
dlcontrvoorzaanw CHAR(1) DEFAULT 'F'::bpchar,
CONSTRAINT cpk_tbmilemwatvoorz PRIMARY KEY(dnkey),
CONSTRAINT chk_milemwatvz_dlcontrvza CHECK (dlcontrvoorzaanw = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT cnn_milemwatvz_keyemwater CHECK (dnkeymilemwater IS NOT NULL),
CONSTRAINT cnn_milemwatvz_keysrtvoorz CHECK (dnkeymilsrtvoorz IS NOT NULL),
CONSTRAINT cfk_tbmilemwatvz_tbmilemwater FOREIGN KEY (dnkeymilemwater)
REFERENCES public.tbmilemwater(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilemwatvz_tbmilsrtvz FOREIGN KEY (dnkeymilsrtvoorz)
REFERENCES public.tbmilsrtvoorz(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilemwatvoorz
IS 'Tabel met emissiebeperkende voorzieningen (zie tbmilsrtvoorz) per watertemissiepunt (tbmilemwater)';
COMMENT ON COLUMN public.tbmilemwatvoorz.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilemwatvoorz.dnkeymilemwater
IS 'Foreign key naar TbMilEmwater.dnkey';
COMMENT ON COLUMN public.tbmilemwatvoorz.dnkeymilsrtvoorz
IS 'Foreign key naar TbMilSrtVoorz.dnkey';
COMMENT ON COLUMN public.tbmilemwatvoorz.dlcontrvoorzaanw
IS 'T of F of null. Indien T dan is een een controlevoorziening aanwezig.';
CREATE INDEX idx_milemwatvz_keymilemwater ON public.tbmilemwatvoorz
USING btree (dnkeymilemwater);
CREATE INDEX idx_milemwatvz_keymilsrtvz ON public.tbmilemwatvoorz
USING btree (dnkeymilsrtvoorz);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|