50 lines
3.1 KiB
SQL
50 lines
3.1 KiB
SQL
-- testdb.dingdan2025 definition
|
|
|
|
CREATE TABLE `dingdan2025` (
|
|
`订单编号` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL,
|
|
`订单状态` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`下单时间` datetime DEFAULT NULL,
|
|
`充电开始时间` datetime DEFAULT NULL,
|
|
`充电结束时间` datetime DEFAULT NULL,
|
|
`订单完成时间` datetime DEFAULT NULL,
|
|
`启动充电结果` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`原客户名称` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`客户电话` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`充电站` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`充电终端` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`企业名称` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`车牌号` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`应收订单金额` double DEFAULT NULL,
|
|
`实际支付` double DEFAULT NULL,
|
|
`异常金额(应收金额-实际支付-优惠合计)` double DEFAULT NULL,
|
|
`应收订单电费` double DEFAULT NULL,
|
|
`应收订单服务费` double DEFAULT NULL,
|
|
`实际支付订单电费` double DEFAULT NULL,
|
|
`实际支付订单服务费` double DEFAULT NULL,
|
|
`等级优惠` double DEFAULT NULL,
|
|
`积分抵扣` double DEFAULT NULL,
|
|
`优惠券优惠` double DEFAULT NULL,
|
|
`优惠券名称` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`活动优惠` double DEFAULT NULL,
|
|
`充电电量` double DEFAULT NULL,
|
|
`平均单价` double DEFAULT NULL,
|
|
`异常记录金额` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`异常记录金额说明` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`支付方式` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`开票状态` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`站点运营类型` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`站点运营商` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`订单来源运营商` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`运营商订单编号` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`原站名` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`消费值` double DEFAULT NULL,
|
|
`消费均值` double DEFAULT NULL,
|
|
`客户名称` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`站名` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
|
|
`是否为vin码启动` varchar(50) DEFAULT NULL,
|
|
`vin码` varchar(50) DEFAULT NULL,
|
|
PRIMARY KEY (`订单编号`),
|
|
UNIQUE KEY `all2024_订单编号_IDX` (`订单编号`),
|
|
KEY `all2024_客户标识_IDX` (`客户名称`) USING BTREE,
|
|
KEY `all2024_客户电话_IDX` (`客户电话`) USING BTREE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; |