90 lines
5.6 KiB
SQL
90 lines
5.6 KiB
SQL
-- testdb.bike2025 definition
|
||
|
||
CREATE TABLE `bike2025` (
|
||
`订单编号` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
`所属片区` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`车辆编号` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`姓名` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`手机号` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`支付状态` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`未支付天数` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`订单费用` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`充值金额结算` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`赠送金额结算` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`折扣` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`骑行费用` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`调度费` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`罚金` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`优惠方式` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`骑行卡抵扣` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`使用骑行卡` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`计费方式` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`是否使用骑行卡` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`是否活动免单` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`骑行时长` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`是否异议工单` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`是否规范还车` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`开始时间` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`结束时间` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`骑行距离` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`骑行开始站点ID` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`骑行开始站点` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`骑行结束站点ID` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`骑行结束站点` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`是否免罚` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`免罚金额` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`站点内外` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`自动落锁` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`还车方式` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`时间` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`钱包充值` double DEFAULT NULL,
|
||
`平台充值` int DEFAULT NULL,
|
||
`充值赠送` int DEFAULT NULL,
|
||
`诚信金收入` int DEFAULT NULL,
|
||
`会员卡总收入` int DEFAULT NULL,
|
||
`骑行卡总收入` double DEFAULT NULL,
|
||
`优惠卡收入` int DEFAULT NULL,
|
||
`充值结算（实收订单）` double DEFAULT NULL,
|
||
`赠送（实收订单）` int DEFAULT NULL,
|
||
`退款（异议工单）` int DEFAULT NULL,
|
||
`充值退款` int DEFAULT NULL,
|
||
`赠送退款` int DEFAULT NULL,
|
||
`服务区名称` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`297780343036450805` int DEFAULT NULL,
|
||
`公共片区` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`100605957` int DEFAULT NULL,
|
||
`谢碧玉` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`+86-18007700898` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`已支付` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`Column7` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`0.0元` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`0.0元_1` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`0.0元_2` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`1.0` double DEFAULT NULL,
|
||
`2.0元` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`0.0元_3` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`0.0元_4` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`活动赠送` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`0.0元_5` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`Column17` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`普通计费` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`否` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`是` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`00:6:18` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`否_1` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`是_1` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`2025-05-24 21:59:38` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`2025-05-24 22:05:56` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`0.707公里` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`291249735842928512` int DEFAULT NULL,
|
||
`广西壮族自治区南宁市青秀区南湖街道金浦路广西壮族自治区高级人民法院` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`0` int DEFAULT NULL,
|
||
`Column30` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`否_2` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`0.0元_6` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`站点外` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`否_3` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`用户主动还车` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
PRIMARY KEY (`订单编号`),
|
||
UNIQUE KEY `bike2025_订单编号_IDX` (`订单编号`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |