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