Datadictionary OpenWave 3.1.25 |
|
Table: tbinfotrefwoordennn
Datadictionary OpenWave 3.1.25 |
|
Table: tbinfotrefwoordennn
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Depricated sinds versie 3.1.15. Koppeltabel tussen de trefwoorden (tbinfotrefwoord) en een een info-aanvraag
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkeyinfoaanvraag |
integer |
|
|
|
|
Foreign key naar TbInfoAanvragen.Dnkey en tezamen met DnKeyInfoTrefwoord de primary key van deze tabel. |
|
|
dnkeyinfotrefwoord |
integer |
|
|
|
|
Foreign key naar TbInfoTrefwoord.Dnkey en tezamen met DnKeyInfoAanvraag de primary key van deze tabel. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_infotrefwnn_infoaanvr |
dnkeyinfoaanvraag |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_infotrefwoordennn_trefw |
dnkeyinfotrefwoord |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table tbinfotrefwoordennn
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbinfotrefwoordennn |
btree |
|
dnkeyinfoaanvraag, dnkeyinfotrefwoord |
|
|
|
idx_infotrefwoordennn_keyinfav |
btree |
|
dnkeyinfoaanvraag |
|
|
|
idx_infotrefwoordennn_keyinftr |
btree |
|
dnkeyinfotrefwoord |
|
|
|
Triggers
There are no triggers for table tbinfotrefwoordennn
Rules
There are no rules for table tbinfotrefwoordennn
Policies
There are no policies for table tbinfotrefwoordennn
Referenced
There are no tables referenced by table tbinfotrefwoordennn
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkeyinfoaanvraag INTEGER NOT NULL,
dnkeyinfotrefwoord INTEGER NOT NULL,
CONSTRAINT cpk_tbinfotrefwoordennn PRIMARY KEY(dnkeyinfoaanvraag, dnkeyinfotrefwoord),
CONSTRAINT cfk_infotrefwnn_infoaanvr FOREIGN KEY (dnkeyinfoaanvraag)
REFERENCES public.tbinfoaanvragen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_infotrefwoordennn_trefw FOREIGN KEY (dnkeyinfotrefwoord)
REFERENCES public.tbinfotrefwoord(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbinfotrefwoordennn
IS 'Depricated sinds versie 3.1.15. Koppeltabel tussen de trefwoorden (tbinfotrefwoord) en een een info-aanvraag';
COMMENT ON COLUMN public.tbinfotrefwoordennn.dnkeyinfoaanvraag
IS 'Foreign key naar TbInfoAanvragen.Dnkey en tezamen met DnKeyInfoTrefwoord de primary key van deze tabel.';
COMMENT ON COLUMN public.tbinfotrefwoordennn.dnkeyinfotrefwoord
IS 'Foreign key naar TbInfoTrefwoord.Dnkey en tezamen met DnKeyInfoAanvraag de primary key van deze tabel.';
CREATE INDEX idx_infotrefwoordennn_keyinfav ON public.tbinfotrefwoordennn
USING btree (dnkeyinfoaanvraag);
CREATE INDEX idx_infotrefwoordennn_keyinftr ON public.tbinfotrefwoordennn
USING btree (dnkeyinfotrefwoord);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|