Datadictionary OpenWave 3.1.25 |
|
Table: tbsubproductdef
Datadictionary OpenWave 3.1.25 |
|
Table: tbsubproductdef
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltablel tussen productdefinities (tbproductdef) en subsproducten (tbsubproducten)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbsubproductdef_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyproductdef |
integer |
|
|
|
|
Foreign key naar tbproductdef.dnkey |
|
|
ddvervallen |
timestamp |
|
|
|
|
Datum dat combinatie product/subproduct is komen te vervallen. |
|
|
dnkeysubproducten |
integer |
|
|
|
|
Foreign key naar tbsubproducten.dnkey |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbsubprod_keyproductdef |
dnkeyproductdef |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbsubproddef_keysubprod |
dnkeysubproducten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbsubprod_keyproductdef |
dnkeyproductdef IS NOT NULL |
|
cnn_tbsubproductdef_keysubpr |
dnkeysubproducten IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbsubproductdef |
btree |
|
dnkey |
|
|
|
idu_subproductdef_keyprodsub |
btree |
|
dnkeyproductdef, dnkeysubproducten |
|
|
|
Triggers
There are no triggers for table tbsubproductdef
Rules
There are no rules for table tbsubproductdef
Policies
There are no policies for table tbsubproductdef
Referenced
There are no tables referenced by table tbsubproductdef
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyproductdef INTEGER,
ddvervallen TIMESTAMP WITHOUT TIME ZONE,
dnkeysubproducten INTEGER,
CONSTRAINT cpk_tbsubproductdef PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbsubprod_keyproductdef CHECK (dnkeyproductdef IS NOT NULL),
CONSTRAINT cnn_tbsubproductdef_keysubpr CHECK (dnkeysubproducten IS NOT NULL),
CONSTRAINT cfk_tbsubprod_keyproductdef FOREIGN KEY (dnkeyproductdef)
REFERENCES public.tbproductdef(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbsubproddef_keysubprod FOREIGN KEY (dnkeysubproducten)
REFERENCES public.tbsubproducten(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbsubproductdef
IS 'Koppeltablel tussen productdefinities (tbproductdef) en subsproducten (tbsubproducten)';
COMMENT ON COLUMN public.tbsubproductdef.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbsubproductdef.dnkeyproductdef
IS 'Foreign key naar tbproductdef.dnkey';
COMMENT ON COLUMN public.tbsubproductdef.ddvervallen
IS 'Datum dat combinatie product/subproduct is komen te vervallen.';
COMMENT ON COLUMN public.tbsubproductdef.dnkeysubproducten
IS 'Foreign key naar tbsubproducten.dnkey';
CREATE UNIQUE INDEX idu_subproductdef_keyprodsub ON public.tbsubproductdef
USING btree (dnkeyproductdef, dnkeysubproducten);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|