Datadictionary OpenWave 3.1.25 |
|
Table: tbmilkopvergsrt
Datadictionary OpenWave 3.1.25 |
|
Table: tbmilkopvergsrt
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel van soorten milieu- en gebruiksvergunningen (tbsoortmilverg) met amvb-typeringen (tbmilvergamvbpl). Wordt sedert openWave versie 3040 niet meer gebruikt.
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkeysoortmilverg |
integer |
|
|
|
|
Foreign key naar TbSoortMilverg.dnkey Vormt tezamen met DnKeyMilvergAmvbpl de primary key van deze tabel. |
|
|
dnkeymilvergamvbpl |
integer |
|
|
|
|
Foreign key naar TbMilvergAmvbpl.dnkey Vormt tezamen met DnKeyMilvergAmvbpl de primary key van deze tabel. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_milkopvergsrt_srtmilverg |
dnkeysoortmilverg |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_milkopvergsrt_vergamvbpl |
dnkeymilvergamvbpl |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table tbmilkopvergsrt
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilkopvergsrt |
btree |
|
dnkeysoortmilverg, dnkeymilvergamvbpl |
|
|
|
Triggers
There are no triggers for table tbmilkopvergsrt
Rules
There are no rules for table tbmilkopvergsrt
Policies
There are no policies for table tbmilkopvergsrt
Referenced
There are no tables referenced by table tbmilkopvergsrt
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkeysoortmilverg INTEGER NOT NULL,
dnkeymilvergamvbpl INTEGER NOT NULL,
CONSTRAINT cpk_tbmilkopvergsrt PRIMARY KEY(dnkeysoortmilverg, dnkeymilvergamvbpl),
CONSTRAINT cfk_milkopvergsrt_srtmilverg FOREIGN KEY (dnkeysoortmilverg)
REFERENCES public.tbsoortmilverg(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_milkopvergsrt_vergamvbpl FOREIGN KEY (dnkeymilvergamvbpl)
REFERENCES public.tbmilvergamvbpl(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilkopvergsrt
IS 'Koppeltabel van soorten milieu- en gebruiksvergunningen (tbsoortmilverg) met amvb-typeringen (tbmilvergamvbpl). Wordt sedert openWave versie 3040 niet meer gebruikt.';
COMMENT ON COLUMN public.tbmilkopvergsrt.dnkeysoortmilverg
IS 'Foreign key naar TbSoortMilverg.dnkey Vormt tezamen met DnKeyMilvergAmvbpl de primary key van deze tabel.';
COMMENT ON COLUMN public.tbmilkopvergsrt.dnkeymilvergamvbpl
IS 'Foreign key naar TbMilvergAmvbpl.dnkey Vormt tezamen met DnKeyMilvergAmvbpl de primary key van deze tabel.';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|