기능(Feature) #483
Updated by Dan Hoang 9 months ago
*Generate Generate coupon item based on condition of a specific coupon budget* budget - Each coupon budget can only be used once based on the USE_YN column - COUPON_ITEM_CODE is unique and combine with value of DRAFT_CODE in BS_COUPON_BUDGET - COUPON_ITEM_CODE is a string that is not easily guessed *Schema of BS_COUPON_ITEM* COUPON_ITEM_SEQ bigint NOT NULL AUTO_INCREMENT, COUPON_BUDGET_SEQ bigint NOT NULL, COUPON_ITEM_CODE varchar(20) NOT NULL COMMENT 'Combine Value of DRAFT_CODE and random characters', COUPON_NAME_EN varchar(100) NOT NULL, COUPON_NAME_KO varchar(100) NOT NULL, COUPON_NAME_JA varchar(100) DEFAULT NULL, COUPON_NAME_VI varchar(100) DEFAULT NULL, COUPON_NAME_ZH varchar(100) DEFAULT NULL, COUPON_DESC varchar(1000) DEFAULT NULL, ITEM_DETAIL_CATEGORY_CODE_LIST varchar(100) DEFAULT NULL COMMENT 'Reserved Item Detail of Category Code()', MAX_ISSUE_ABLE_COUNT smallint NOT NULL DEFAULT 1 COMMENT 'Value is the same with value of MAX_USAGE_PER_COUPON in BS_COUPON_BUDGET table', LEFT_COUPON_COUNT smallint NOT NULL DEFAULT 1 COMMENT 'Initial Value is the same with value of MAX_ISSUE_ABLE_COUNT', FIRST_INSERT_UNO bigint NOT NULL, FIRST_INSERT_DATETIME datetime NOT NULL, LAST_UPDATE_UNO bigint NOT NULL, LAST_UPDATE_DATETIME datetime NOT NULL, PRIMARY KEY (COUPON_ITEM_SEQ)
