Datadictionary OpenWave 3.1.25 |
|
Table: tbmilcontactennn
Datadictionary OpenWave 3.1.25 |
|
Table: tbmilcontactennn
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tussen tbadressoorten en tbcontactadressen en tbmilinrichtingen: welke contactadressen zijn onder welke rol verbonden aan een inrichting
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar TbMilInrichtingen.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_milcontactennn_adrescode |
dvcodeadressoort |
dvcode |
No Action |
No Action |
|
Immediate |
|
|
cfk_milcontactennn_contactadr |
dnkeycontactadressen |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_milcontactennn_milinricht |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table tbmilcontactennn
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilcontactennn |
btree |
|
dnkeycontactadressen, dnkeymilinrichtingen, dvcodeadressoort |
|
|
|
idx_milcontacten_adressoort |
btree |
|
dvcodeadressoort |
|
|
|
idx_milcontacten_contactadres |
btree |
|
dnkeycontactadressen |
|
|
|
idx_milcontacten_milinricht |
btree |
|
dnkeymilinrichtingen |
|
|
|
Triggers
There are no triggers for table tbmilcontactennn
Rules
There are no rules for table tbmilcontactennn
Policies
There are no policies for table tbmilcontactennn
Referenced
There are no tables referenced by table tbmilcontactennn
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkeymilinrichtingen INTEGER NOT NULL,
dvcodeadressoort CHAR(3) NOT NULL,
dnkeycontactadressen INTEGER NOT NULL,
CONSTRAINT cpk_tbmilcontactennn PRIMARY KEY(dnkeycontactadressen, dnkeymilinrichtingen, dvcodeadressoort),
CONSTRAINT cfk_milcontactennn_adrescode FOREIGN KEY (dvcodeadressoort)
REFERENCES public.tbadressoort(dvcode)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_milcontactennn_contactadr FOREIGN KEY (dnkeycontactadressen)
REFERENCES public.tbcontactadressen(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_milcontactennn_milinricht FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilcontactennn
IS 'Koppeltabel tussen tbadressoorten en tbcontactadressen en tbmilinrichtingen: welke contactadressen zijn onder welke rol verbonden aan een inrichting';
COMMENT ON COLUMN public.tbmilcontactennn.dnkeymilinrichtingen
IS 'Foreign key naar TbMilInrichtingen.dnkey. Tezamen met DvCodeAdresSoort en DnKeyContactadressen uniek en ook tezamen de primary key.';
COMMENT ON COLUMN public.tbmilcontactennn.dvcodeadressoort
IS 'Foreign key naar TbAdressoort.dvcode.';
COMMENT ON COLUMN public.tbmilcontactennn.dnkeycontactadressen
IS 'Foreign key naar TbContactAdressen.dnkey.';
CREATE INDEX idx_milcontacten_adressoort ON public.tbmilcontactennn
USING btree (dvcodeadressoort COLLATE pg_catalog."default");
CREATE INDEX idx_milcontacten_contactadres ON public.tbmilcontactennn
USING btree (dnkeycontactadressen);
CREATE INDEX idx_milcontacten_milinricht ON public.tbmilcontactennn
USING btree (dnkeymilinrichtingen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|