기능(Feature) #480
Updated by Dan Hoang 9 months ago
Implement backend API to create coupon budget, we can use postman to manually create a budget instead of UI now. This API belong to admin site and it will be use for UI in the future.
At least one COUPON_SHARE is required
*Schema of coupon budget*
COUPON_BUDGET_SEQ bigint NOT NULL AUTO_INCREMENT,
SALES_COUNTRY_CODE varchar(9) NOT NULL,
BUDGET_NAME_EN varchar(100) NOT NULL,
BUDGET_NAME_KO varchar(100) NOT NULL,
BUDGET_DESC varchar(1000) DEFAULT NULL,
IN_CHARGE_DEPT_CODE varchar(10) NOT NULL,
SUPPORT_SALES_COMP_CODE_LIST varchar(1000) DEFAULT NULL COMMENT 'Issue for list specific Sellers',
ITEM_CATEGORY_CODE varchar(10) DEFAULT NULL COMMENT 'Reserved Item Category Code: BasicBS003',
COUPON_SHARED_TRADER_COMP_CODE1 int DEFAULT NULL,
COUPON_SHARE_RATE_OR_AMOUNT1 varchar(1) DEFAULT NULL,
COUPON_SHARE_APPLIED_VALUE2 decimal(15, 2) DEFAULT NULL,
COUPON_SHARED_TRADER_COMP_CODE2 int DEFAULT NULL,
COUPON_SHARE_RATE_OR_AMOUNT2 varchar(1) DEFAULT NULL,
COUPON_SHARE_APPLIED_VALUE1 decimal(15, 2) DEFAULT NULL,
TOTAL_BUDGET_AMOUNT decimal(15, 2) NOT NULL,
COUPON_RATE_OR_AMOUNT varchar(1) NOT NULL,
COUPON_APPLIED_VALUE decimal(15, 2) NOT NULL,
MIN_ORDER_AMOUNT decimal(15, 2) NOT NULL COMMENT 'Minimum order value to apply',
DRAFT_CODE varchar(20) DEFAULT NULL COMMENT 'Prefix of coupon code',
USE_YN varchar(1) NOT NULL DEFAULT 'N',
ISSUE_FROM_DATETIME date NOT NULL,
ISSUE_TO_DATETIME date NOT NULL,
USE_FROM_DATE date NOT NULL,
USE_TO_DATE date NOT NULL,
MAX_COUPON_COUNT smallint NOT NULL,
MAX_USAGE_PER_COUPON smallint NOT NULL DEFAULT 1,
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_BUDGET_SEQ)
