기능(Feature) #483
closed기능(Feature) #287: Hana Coupon
[Coupon] Implement backend API to generate coupon items based on a specific coupon budget
100%
Description
Generate coupon item based on condition of a specific coupon 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)
Related issues
