mescloud/db/mysql/add_mes_pda_scan_record.sql

CREATE TABLE IF NOT EXISTS `mes_pda_scan_record` (
  `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'id',
  `sn` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'sn',
  `oprno` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'oprno',
  `line_sn` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'lineSn',
  `ucode` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'ucode',
  `remarks` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'remarks',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT 'status',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'create_by',
  `create_date` datetime NOT NULL COMMENT 'create_date',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'update_by',
  `update_date` datetime NOT NULL COMMENT 'update_date',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_mes_pda_scan_record_sn` (`sn`) USING BTREE,
  KEY `idx_mes_pda_scan_record_oprno` (`oprno`) USING BTREE,
  KEY `idx_mes_pda_scan_record_line_sn` (`line_sn`) USING BTREE,
  KEY `idx_mes_pda_scan_record_create_date` (`create_date`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='PDA scan record';