day_off_inf

create table day_off_inf (

email varchar(100) not null,

day_off_date varchar(8) not null,

comment varchar(255) default null,

created_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

updated_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

primary key (email, day_off_date),

key idx_overtime_inf_email(email),

key idx_overtime_inf_overtime_date(day_off_date)

) comment = '해피휴무 날짜 등록 테이블' ENGINE=innoDB DEFAULT CHARSET=utf8mb4 collate=utf8mb4_unicode_ci;