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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000196 | MODEL_ID, SPEC_ID, STOREENT_ID | Unique Index |
SQL030416035043560 | MDLSPC_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|