20 lines
869 B
SQL
20 lines
869 B
SQL
-- testdb.yingshou2025 definition
|
||
|
||
CREATE TABLE `yingshou2025` (
|
||
`时间` varchar(50) COLLATE utf8mb4_unicode_ci NOT 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,
|
||
`充值退款` double DEFAULT NULL,
|
||
`赠送退款` double DEFAULT NULL,
|
||
`服务区名称` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
PRIMARY KEY (`时间`),
|
||
UNIQUE KEY `yingshou2025_时间_IDX` (`时间`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |