The table contains different model specification mapping for each store. PVCMDLSPEC represents relationship among records in the PVCDEVMDL and the PVCDEVSPEC database tables.
Column Description(s):
Column Name | Column Type | Description |
MDLSPC_ID |
INTEGER NOT NULL |
Reference number (primary key is required by Enterprise JavaBeans). |
STOREENT_ID |
INTEGER NOT NULL |
Owner of the definition. A value of -1 means the site default. |
MODEL_ID |
INTEGER NOT NULL |
Reference number to uniquely identify the model. |
SPEC_ID |
INTEGER NOT NULL |
Reference number to uniquely identify the specification. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000196 |
MODEL_ID+SPEC_ID+STOREENT_ID |
Unique Index |
SQL050212031300440 |
MDLSPC_ID |
Primary Key |
I0000707 |
STOREENT_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_637 |
MODEL_ID |
PVCDEVMDL |
MODEL_ID |
Cascade |
F_638 |
SPEC_ID |
PVCDEVSPEC |
SPEC_ID |
Cascade |
F_636 |
STOREENT_ID |
STOREENT |
STOREENT_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.