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