Datadictionary OpenWave 3.1.25 |
|
Table: tbmilemlctvoorz
Datadictionary OpenWave 3.1.25 |
|
Table: tbmilemlctvoorz
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel van emissiebeperkende voorzieningen (tbmilsrtvoorz) per luchtemissiepunt (tbmilemlucht)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilemlctvoorz_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilemlucht |
integer |
|
|
|
|
Foreign key naar TbMilEmLucht.dnkey |
|
|
dnkeymilsrtvoorz |
integer |
|
|
|
|
Foreign key naar TbMilSrtVoorz.dnkey |
|
|
dvopmerking |
varchar(100) |
|
|
|
|
|
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilemlctvz_tbmilemlucht |
dnkeymilemlucht |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbmilemlctvz_tbmilsrtvz |
dnkeymilsrtvoorz |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_milemlctvz_keyemlucht |
dnkeymilemlucht IS NOT NULL |
|
cnn_milemlctvz_keysrtvoorz |
dnkeymilsrtvoorz IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilemlctvoorz |
btree |
|
dnkey |
|
|
|
idx_milemlctvz_keymilemlucht |
btree |
|
dnkeymilemlucht |
|
|
|
idx_milemlctvz_keymilsrtvz |
btree |
|
dnkeymilsrtvoorz |
|
|
|
Triggers
There are no triggers for table tbmilemlctvoorz
Rules
There are no rules for table tbmilemlctvoorz
Policies
There are no policies for table tbmilemlctvoorz
Referenced
There are no tables referenced by table tbmilemlctvoorz
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilemlucht INTEGER,
dnkeymilsrtvoorz INTEGER,
dvopmerking VARCHAR(100),
CONSTRAINT cpk_tbmilemlctvoorz PRIMARY KEY(dnkey),
CONSTRAINT cnn_milemlctvz_keyemlucht CHECK (dnkeymilemlucht IS NOT NULL),
CONSTRAINT cnn_milemlctvz_keysrtvoorz CHECK (dnkeymilsrtvoorz IS NOT NULL),
CONSTRAINT cfk_tbmilemlctvz_tbmilemlucht FOREIGN KEY (dnkeymilemlucht)
REFERENCES public.tbmilemlucht(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilemlctvz_tbmilsrtvz FOREIGN KEY (dnkeymilsrtvoorz)
REFERENCES public.tbmilsrtvoorz(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilemlctvoorz
IS 'Koppeltabel van emissiebeperkende voorzieningen (tbmilsrtvoorz) per luchtemissiepunt (tbmilemlucht)';
COMMENT ON COLUMN public.tbmilemlctvoorz.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilemlctvoorz.dnkeymilemlucht
IS 'Foreign key naar TbMilEmLucht.dnkey';
COMMENT ON COLUMN public.tbmilemlctvoorz.dnkeymilsrtvoorz
IS 'Foreign key naar TbMilSrtVoorz.dnkey';
CREATE INDEX idx_milemlctvz_keymilemlucht ON public.tbmilemlctvoorz
USING btree (dnkeymilemlucht);
CREATE INDEX idx_milemlctvz_keymilsrtvz ON public.tbmilemlctvoorz
USING btree (dnkeymilsrtvoorz);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|