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 Column Description
MDLSPC_ID INTEGER
NOT NULL
Reference number (primary key is required by Enterprise JavaBeans).
MODEL_ID INTEGER
NOT NULL
Reference number to uniquely identify the model.
SPEC_ID INTEGER
NOT NULL
Reference number to uniquely identify the specification.
STOREENT_ID INTEGER
NOT NULL
Owner of the definition. A value of -1 means the site default.
Indexes:
Index Name Indexed Column Names Index Type
I0000196 MODEL_ID, SPEC_ID, STOREENT_ID Unique Index
SQL030416035043560 MDLSPC_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_636 STOREENT_ID STOREENT STOREENT_ID Cascade
F_637 MODEL_ID PVCDEVMDL MODEL_ID Cascade
F_638 SPEC_ID PVCDEVSPEC SPEC_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable