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 Description(s):
Column NameColumn TypeDescription
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 NameIndexed Column NamesIndex Type
I0000196 MODEL_ID+SPEC_ID+STOREENT_ID Unique Index
SQL050212031300440 MDLSPC_ID Primary Key
I0000707 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign 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

Feedback