WebSphere Commerce database table: PVCMDLSPEC

The table contains different model specification mapping for each store. PVCMDLSPEC represents relationship among records in the PVCDEVMDL and the PVCDEVSPEC database tables.

Column Descriptions
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.

Indexes
Index Name Indexed Column Names Index Type
I0000196 MODEL_ID+SPEC_ID+STOREENT_ID Unique Index
SQL060903235238090 MDLSPC_ID Primary Key
I0000707 STOREENT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names 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