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