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