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:

Name	Type	Description
SUBSCRTEMPLATE_ID	BIGINT NOT NULL	Generated unique key.
STOREENT_ID	INTEGER NOT NULL	The store entity that the subscription product belongs to.
MEMBER_ID	BIGINT NOT NULL	The owner of this template.
TEMPLATEIDENTIFIER	VARCHAR (254) NOT NULL	External identifier for the template. For subscriptions, the identifier will be needed for business users to manage template using CMC.
CATENTRY_ID	BIGINT	The catalog entry ID of the subscription product for which the template is defined.
FIELD1	INTEGER	Customizable
FIELD2	DECIMAL (20,5)	Customizable
FIELD3	VARCHAR (254)	Customizable
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	SUBSCRTEMPLATE_ID	Primary Key
I0001367	STOREENT_ID	Non-Unique Index
I0001368	MEMBER_ID	Non-Unique Index
I0001369	CATENTRY_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3654	STOREENT_ID	STOREENT	STOREENT_ID	Cascade
F_3655	MEMBER_ID	MEMBER	MEMBER_ID	Cascade
F_3656	CATENTRY_ID	CATENTRY	CATENTRY_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3652	SUBSCRTEMPLATE_ID	SUBSCRIPTION	SUBSCRTEMPLATE_ID	Cascade
F_3657	SUBSCRTEMPLATE_ID	SUBSCRTMPLITEMLIST	SUBSCRTEMPLATE_ID	Cascade