SUBSCRTEMPLATE
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