Ellis improvement

CREATE TABLE OMH_SUITE.VD_VENDOR_PLAN_CANCEL_POLICY_MASTER (
POLICY_MASTER_SEQ bigint NOT NULL AUTO_INCREMENT,
ROOM_PLAN_SEQ bigint NOT NULL,
DEFAULT_YN varchar(1) NOT NULL,
NON_REFUNDABLE_YN varchar(1) NOT NULL,
USE_POLICY_OPTION_YN varchar(1) NOT NULL DEFAULT 'N',
APPLIED_FROM_DATE date NOT NULL,
APPLIED_TO_DATE date NOT NULL,
DATE_OPTION_YN varchar(1) NOT NULL DEFAULT 'N',
APPLIED_SUN_YN varchar(1) NOT NULL DEFAULT 'N',
APPLIED_MON_YN varchar(1) NOT NULL DEFAULT 'N',
APPLIED_TUE_YN varchar(1) NOT NULL DEFAULT 'N',
APPLIED_WED_YN varchar(1) NOT NULL DEFAULT 'N',
APPLIED_THU_YN varchar(1) NOT NULL DEFAULT 'N',
APPLIED_FRI_YN varchar(1) NOT NULL DEFAULT 'N',
APPLIED_SAT_YN varchar(1) NOT NULL DEFAULT 'N',
DELETE_YN varchar(1) NOT NULL DEFAULT 'N',
DISPLAY_ORDER smallint DEFAULT NULL,
FIRST_INSERT_UNO bigint NOT NULL DEFAULT 10000,
FIRST_INSERT_DATETIME datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
LAST_UPDATE_UNO bigint NOT NULL DEFAULT 10000,
LAST_UPDATE_DATETIME datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (POLICY_MASTER_SEQ)
)
ENGINE = INNODB,
AVG_ROW_LENGTH = 90,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_unicode_ci,
COMMENT = 'vendor room plan cancellation policy master';

ALTER TABLE OMH_SUITE.VD_VENDOR_PLAN_CANCEL_POLICY_MASTER
ADD INDEX XIF_VD_VENDOR_PLAN_CANCEL_POLICY_MASTER_01 (ROOM_PLAN_SEQ);

ALTER TABLE OMH_SUITE.VD_VENDOR_PLAN_CANCEL_POLICY_MASTER
ADD INDEX XIN_VD_VENDOR_PLAN_CANCEL_POLICY_MASTER_01 (ROOM_PLAN_SEQ, DEFAULT_YN);

ALTER TABLE OMH_SUITE.VD_VENDOR_PLAN_CANCEL_POLICY
ADD COLUMN POLICY_MASTER_SEQ bigint NULL;

ALTER TABLE OMH_SUITE.VD_VENDOR_PLAN_CANCEL_POLICY
ADD INDEX XIN_VD_VENDOR_PLAN_CANCEL_POLICY_04 (POLICY_MASTER_SEQ);

ALTER TABLE OMH_SUITE.VD_VENDOR_PLAN_CANCEL_POLICY_MASTER
ADD INDEX XIN_VD_VENDOR_PLAN_CANCEL_POLICY_MASTER_02 (ROOM_PLAN_SEQ, DELETE_YN);