Datadictionary OpenWave 3.1.11 |
|
Table: tbmilemwatvoorz
Datadictionary OpenWave 3.1.11 |
|
Table: tbmilemwatvoorz
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel van emissiebeperkende voorzieningen (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
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
)
WITH (oids = false);
COMMENT ON TABLE public.tbmilemwatvoorz
IS 'Koppeltabel van emissiebeperkende voorzieningen (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 22-2-2017 10:50 |
|