Datadictionary OpenWave 3.1.25 |
|
Table: tbprodwkpklant
Datadictionary OpenWave 3.1.25 |
|
Table: tbprodwkpklant
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met de samenhang tussen tbproducten, tbsubproducten en tbproducwerkpakketten en tbproducklanten
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbprodwkpklant_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyproductwerkpakketten |
integer |
|
|
|
|
Foreign key naar tbproductwerkpakketten.dnkey |
|
|
dnkeyproductklanten |
integer |
|
|
|
|
Foreign key naar tbproductklanten.dnkey |
|
|
dnkeyproducten |
integer |
|
|
|
|
Foreign key naar tbproducten.dnkey: dus de dnkey van de koppeling tussen zaaktype en een producddefinitie (tbrpridctdef) |
|
|
ddvervallen |
timestamp |
|
|
|
|
Datum dat combinatie product, werkpakket en klant is vervallen. |
|
|
dvactiviteitcode |
varchar(40) |
|
|
|
|
Code waaronder combinatie product, subproduct klant, werkpakket bekend is. |
|
|
dnkeysubproducten |
integer |
|
|
|
|
Foreign key naar tbsubproducten.dnkey |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_prodwkpklant_keyprodklant |
dnkeyproductklanten |
dnkey |
Set Null |
No Action |
|
Immediate |
|
|
cfk_prodwkpklant_keyproducten |
dnkeyproducten |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_prodwkpklant_keyprodwerkp |
dnkeyproductwerkpakketten |
dnkey |
Set Null |
No Action |
|
Immediate |
|
|
cfk_tbprodwkpklant_keysubpr |
dnkeysubproducten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_prodwkpklant_keyproducten |
dnkeyproducten IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbprodwkpklant |
btree |
|
dnkey |
|
|
|
idu_prodwkpklant_keyprwkpkl |
btree |
|
dnkeyproducten, (COALESCE(dnkeysubproducten, 0)), (COALESCE(dnkeyproductklanten, 0)), (COALESCE(dnkeyproductwerkpakketten, 0)) |
|
|
|
Triggers
There are no triggers for table tbprodwkpklant
Rules
There are no rules for table tbprodwkpklant
Policies
There are no policies for table tbprodwkpklant
Referenced
There are no tables referenced by table tbprodwkpklant
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyproductwerkpakketten INTEGER,
dnkeyproductklanten INTEGER,
dnkeyproducten INTEGER,
ddvervallen TIMESTAMP WITHOUT TIME ZONE,
dvactiviteitcode VARCHAR(40),
dnkeysubproducten INTEGER,
CONSTRAINT cpk_tbprodwkpklant PRIMARY KEY(dnkey),
CONSTRAINT cnn_prodwkpklant_keyproducten CHECK (dnkeyproducten IS NOT NULL),
CONSTRAINT cfk_prodwkpklant_keyprodklant FOREIGN KEY (dnkeyproductklanten)
REFERENCES public.tbproductklanten(dnkey)
ON DELETE SET NULL
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_prodwkpklant_keyproducten FOREIGN KEY (dnkeyproducten)
REFERENCES public.tbproducten(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_prodwkpklant_keyprodwerkp FOREIGN KEY (dnkeyproductwerkpakketten)
REFERENCES public.tbproductwerkpakketten(dnkey)
ON DELETE SET NULL
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbprodwkpklant_keysubpr FOREIGN KEY (dnkeysubproducten)
REFERENCES public.tbsubproducten(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbprodwkpklant
IS 'Tabel met de samenhang tussen tbproducten, tbsubproducten en tbproducwerkpakketten en tbproducklanten';
COMMENT ON COLUMN public.tbprodwkpklant.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbprodwkpklant.dnkeyproductwerkpakketten
IS 'Foreign key naar tbproductwerkpakketten.dnkey ';
COMMENT ON COLUMN public.tbprodwkpklant.dnkeyproductklanten
IS 'Foreign key naar tbproductklanten.dnkey ';
COMMENT ON COLUMN public.tbprodwkpklant.dnkeyproducten
IS 'Foreign key naar tbproducten.dnkey: dus de dnkey van de koppeling tussen zaaktype en een producddefinitie (tbrpridctdef) ';
COMMENT ON COLUMN public.tbprodwkpklant.ddvervallen
IS 'Datum dat combinatie product, werkpakket en klant is vervallen.';
COMMENT ON COLUMN public.tbprodwkpklant.dvactiviteitcode
IS 'Code waaronder combinatie product, subproduct klant, werkpakket bekend is.';
COMMENT ON COLUMN public.tbprodwkpklant.dnkeysubproducten
IS 'Foreign key naar tbsubproducten.dnkey';
CREATE UNIQUE INDEX idu_prodwkpklant_keyprwkpkl ON public.tbprodwkpklant
USING btree (dnkeyproducten, (COALESCE(dnkeysubproducten, 0)), (COALESCE(dnkeyproductklanten, 0)), (COALESCE(dnkeyproductwerkpakketten, 0)));
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|