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:

NameTypeDescription
MDLSPC_IDINTEGER NOT NULLReference number (primary key is required by Enterprise JavaBeans).
STOREENT_IDINTEGER NOT NULLOwner of the definition. A value of -1 means the site default.
MODEL_IDINTEGER NOT NULLReference number to uniquely identify the model.
SPEC_IDINTEGER NOT NULLReference number to uniquely identify the specification.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MDLSPC_IDPrimary Key
I0000196MODEL_ID+SPEC_ID+STOREENT_IDUnique Index
I0000707STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_636STOREENT_IDSTOREENTSTOREENT_IDCascade
F_637MODEL_IDPVCDEVMDLMODEL_IDCascade
F_638SPEC_IDPVCDEVSPECSPEC_IDCascade