CREATE TABLE `adt_sqi_dev`.`job_master_now` 
( `job_num` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
  `order_id` INT(10) NOT NULL COMMENT 'order or queue id for the order/queue line up',
  `msg_content` TEXT NULL ,
  `cust_id` varchar(10) NOT NULL COMMENT 'should be unique',
  `cust_name` varchar(40) NOT NULL COMMENT 'ADT customer id - shop/restaurant',
  `email_name` varchar(40) COMMENT 'email name of the msg recipient if use email instead of GOText' ,
  `phone_num` varchar(12) NOT NULL COMMENT 'mobile number of the msg recipient',
  `send_method` varchar(10) NOT NULL COMMENT 'gotext, sms, whatsapp, wechat, line, email, other',
  `rec_language` varchar(5) NOT NULL comment 'eng/tc/sc language of message to be received' ,
  `service_provider` varchar(5) NOT NULL,
  `done_flag` VARCHAR(1) DEFAULT 'N' comment 'Y for sent the msg', 
  `type` VARCHAR(5) NOT NULL, 
  `fileName` VARCHAR(30) NULL, 
  `fileURL` TEXT NULL, 
  aud_create_dttm datetime DEFAULT NULL,
  aud_create_username varchar(30) CHARACTER SET utf8 DEFAULT NULL,
  aud_last_upd_dttm datetime DEFAULT NULL,
  aud_last_upd_username varchar(30) CHARACTER SET utf8 DEFAULT NULL,
  aud_last_upd_workstation varchar(30) CHARACTER SET utf8 DEFAULT NULL,
  is_archived varchar(1) CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  lk_can_read varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  lk_module_name varchar(30) CHARACTER SET utf8 DEFAULT NULL,
  lk_username varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  lk_workstation varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  lk_session_id varchar(52) CHARACTER SET utf8 DEFAULT NULL,
  lk_start_dttm datetime DEFAULT NULL,
 PRIMARY KEY (`job_num`)
) ENGINE = InnoDB;
