mirror of
https://codeup.aliyun.com/67c68d4e484ca2f0a13ac3c1/ydc/jsowell-charger-web.git
synced 2026-04-20 02:55:04 +08:00
22 lines
1.3 KiB
SQL
22 lines
1.3 KiB
SQL
-- JCPP 充电桩同步记录表
|
||
CREATE TABLE `jcpp_sync_record` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`sync_type` varchar(20) NOT NULL COMMENT '同步类型（FULL-全量；INCREMENTAL-增量）',
|
||
`sync_status` varchar(20) NOT NULL COMMENT '同步状态（RUNNING-进行中；SUCCESS-成功；FAILED-失败）',
|
||
`start_time` datetime NOT NULL COMMENT '开始时间',
|
||
`end_time` datetime DEFAULT NULL COMMENT '结束时间',
|
||
`total_piles` int(11) DEFAULT 0 COMMENT '总充电桩数',
|
||
`success_piles` int(11) DEFAULT 0 COMMENT '成功充电桩数',
|
||
`failed_piles` int(11) DEFAULT 0 COMMENT '失败充电桩数',
|
||
`total_guns` int(11) DEFAULT 0 COMMENT '总充电枪数',
|
||
`success_guns` int(11) DEFAULT 0 COMMENT '成功充电枪数',
|
||
`failed_guns` int(11) DEFAULT 0 COMMENT '失败充电枪数',
|
||
`error_message` text COMMENT '错误信息',
|
||
`create_by` varchar(20) DEFAULT NULL COMMENT '创建人',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `idx_sync_type` (`sync_type`) USING BTREE,
|
||
KEY `idx_start_time` (`start_time`) USING BTREE,
|
||
KEY `idx_sync_status` (`sync_status`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='JCPP 充电桩同步记录表';
|