Datadictionary OpenWave 3.1.25 |
|
Table: tbmilvergcontactennn
Datadictionary OpenWave 3.1.25 |
|
Table: tbmilvergcontactennn
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tussen tbadressoorten en tbcontactadressen en tbmilvergunningen: welke contactadressen zijn onder welke rol verbonden aan een milieu-of gebruiksvergunning
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkeymilvergunningen |
integer |
|
|
|
|
Foreign key naar TbMilVergunningen.dnkey. Tezamen met DvCodeAdresSoort en DnKeyContactadressen uniek en ook tezamen de primary key. |
|
|
dvcodeadressoort |
char(3) |
|
|
|
|
Foreign key naar TbAdressoort.dvcode. |
|
|
dnkeycontactadressen |
integer |
|
|
|
|
Foreign key naar TbContactAdressen.dnkey. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_milvergcontnn_adrescode |
dvcodeadressoort |
dvcode |
No Action |
No Action |
|
Immediate |
|
|
cfk_milvergcontnn_contactadr |
dnkeycontactadressen |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_milvergcontnn_milverg |
dnkeymilvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table tbmilvergcontactennn
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilvergcontactennn |
btree |
|
dnkeycontactadressen, dnkeymilvergunningen, dvcodeadressoort |
|
|
|
idx_milvergcont_adressoort |
btree |
|
dvcodeadressoort |
|
|
|
idx_milvergcont_contactadres |
btree |
|
dnkeycontactadressen |
|
|
|
idx_milvergcont_milverg |
btree |
|
dnkeymilvergunningen |
|
|
|
Triggers
There are no triggers for table tbmilvergcontactennn
Rules
There are no rules for table tbmilvergcontactennn
Policies
There are no policies for table tbmilvergcontactennn
Referenced
There are no tables referenced by table tbmilvergcontactennn
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkeymilvergunningen INTEGER NOT NULL,
dvcodeadressoort CHAR(3) NOT NULL,
dnkeycontactadressen INTEGER NOT NULL,
CONSTRAINT cpk_tbmilvergcontactennn PRIMARY KEY(dnkeycontactadressen, dnkeymilvergunningen, dvcodeadressoort),
CONSTRAINT cfk_milvergcontnn_adrescode FOREIGN KEY (dvcodeadressoort)
REFERENCES public.tbadressoort(dvcode)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_milvergcontnn_contactadr FOREIGN KEY (dnkeycontactadressen)
REFERENCES public.tbcontactadressen(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_milvergcontnn_milverg FOREIGN KEY (dnkeymilvergunningen)
REFERENCES public.tbmilvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilvergcontactennn
IS 'Koppeltabel tussen tbadressoorten en tbcontactadressen en tbmilvergunningen: welke contactadressen zijn onder welke rol verbonden aan een milieu-of gebruiksvergunning';
COMMENT ON COLUMN public.tbmilvergcontactennn.dnkeymilvergunningen
IS 'Foreign key naar TbMilVergunningen.dnkey. Tezamen met DvCodeAdresSoort en DnKeyContactadressen uniek en ook tezamen de primary key.';
COMMENT ON COLUMN public.tbmilvergcontactennn.dvcodeadressoort
IS 'Foreign key naar TbAdressoort.dvcode.';
COMMENT ON COLUMN public.tbmilvergcontactennn.dnkeycontactadressen
IS 'Foreign key naar TbContactAdressen.dnkey.';
CREATE INDEX idx_milvergcont_adressoort ON public.tbmilvergcontactennn
USING btree (dvcodeadressoort COLLATE pg_catalog."default");
CREATE INDEX idx_milvergcont_contactadres ON public.tbmilvergcontactennn
USING btree (dnkeycontactadressen);
CREATE INDEX idx_milvergcont_milverg ON public.tbmilvergcontactennn
USING btree (dnkeymilvergunningen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|