Table Description
Contract Product Link: A contract for a product provided by a product provider.

Technical Notes

Optimistic locking is not required for this table as the data is never modified.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Concern::Entity Objects::ContractProductLink::ContractProductLink
Controlling File: core\model\Packages\Concern\ContractProductLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
contractProductLinkIDkeynoUnique identifier for this contractProductLink recordCONTRACT_PRODUCT_LINK_ID SVR_INT64
productIDdetailsnounique identifier for the ProductPRODUCT_ID SVR_INT64
contractIDdetailsnounique identifier for the contractCONTRACT_ID SVR_INT64
Foreign Keys (2)
ChildParent
ContractProductLink.contractIDContract.contractID
ContractProductLink.productIDProduct.productID
Indices (2)
Index NameAttributes
ProdContractIndexcontractID, productID, contractProductLinkID
ProdContractIndex2productID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
searchByProductIDnsreadmulti Retrieves a list of contracts for a specified product 
removeProductLinksnsremove Removes product links from the product links entity 
searchProductsCoverednsmulti Retrieves a list of products covered by a contractSQL
searchProductsNotCoverednsmulti Retrieves a list of products not covered by a contract but provided by a concernSQL
removeProductFromContractnsremove Entity operation to remove a product from a product providers contract. 
Related Pages (6)