| 12345678910111213141516 |
- CREATE TABLE weighbridge_records (
- `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
- weighbridge_name VARCHAR(50) NOT NULL DEFAULT '' COMMENT '地磅名称',
- weighbridge_code VARCHAR(20) NOT NULL DEFAULT '' COMMENT '地磅编码',
- license_plate VARCHAR(20) NOT NULL DEFAULT '' COMMENT '车牌号',
- weight DECIMAL(10,2) NOT NULL DEFAULT 0.00 COMMENT '重量（吨）',
- weigh_time DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT '过磅时间',
- photo_urls JSON DEFAULT JSON_ARRAY() COMMENT '过磅照片，存储图片 URL 数组',
- tag VARCHAR(255) NOT NULL DEFAULT '' COMMENT '处理标签，用于指定处理方向',
- created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
- updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录更新时间',
- PRIMARY KEY (`id`),
- KEY `idx_weighbridge_code` (`weighbridge_code`),
- KEY `idx_weighbridge_name` (`weighbridge_name`),
- KEY `idx_license_plate` (`license_plate`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='地磅过磅记录表';
|
