DROP TABLE IF EXISTS `babyfeed`.`tbl_sms_log` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_sms_log` (
  `s_no` INT NOT NULL AUTO_INCREMENT,
  `sms_use_cd_no` VARCHAR(30) NULL,
  `phone_num` VARCHAR(16) NOT NULL,
  `title` VARCHAR(100) NULL,
  `msg` VARCHAR(1000) NULL,
  `check_num` INT NOT NULL,
  `sms_cd_no` VARCHAR(30) NOT NULL,
  `sms_code` VARCHAR(10) NULL,
  `sms_msg` VARCHAR(100) NULL,
  `reg_dt` DATETIME NOT NULL,
  `mod_dt` DATETIME NULL,
  PRIMARY KEY (`s_no`))
ENGINE = InnoDB;