SUBSCRTEMPLATE

This table contains the properties associated with a subscription product template. For a subscription, there will be a single template for all subscribers who have purchased this subscription product. The item to fulfill as part of this subscription should be managed by the merchant. Initially this will contain the parent catalog entry ID of the subscription product and needs to be updated by the merchant if a different item needs to be shipped.

Column Descriptions:

NameTypeDescription
SUBSCRTEMPLATE_IDBIGINT NOT NULLGenerated unique key.
STOREENT_IDINTEGER NOT NULLThe store entity that the subscription product belongs to.
MEMBER_IDBIGINT NOT NULLThe owner of this template.
TEMPLATEIDENTIFIERVARCHAR (254) NOT NULLExternal identifier for the template. For subscriptions, the identifier will be needed for business users to manage template using CMC.
CATENTRY_IDBIGINTThe catalog entry ID of the subscription product for which the template is defined.
FIELD1INTEGERCustomizable
FIELD2DECIMAL (20,5)Customizable
FIELD3VARCHAR (254)Customizable
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>SUBSCRTEMPLATE_IDPrimary Key
I0001367STOREENT_IDNon-Unique Index
I0001368MEMBER_IDNon-Unique Index
I0001369CATENTRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3654STOREENT_IDSTOREENTSTOREENT_IDCascade
F_3655MEMBER_IDMEMBERMEMBER_IDCascade
F_3656CATENTRY_IDCATENTRYCATENTRY_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3652SUBSCRTEMPLATE_IDSUBSCRIPTIONSUBSCRTEMPLATE_IDCascade
F_3657SUBSCRTEMPLATE_IDSUBSCRTMPLITEMLISTSUBSCRTEMPLATE_IDCascade