Reference > Database > WebSphere Commerce database tables > P
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 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 SQL100520030416060 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
_vcc_freeselect_bottom_