跑腿订单设计数据库

/*
Navicat MySQL Data Transfer

Source Server         : 47.94.156.208
Source Server Version : 50648
Source Host           : 47.94.156.208:3306
Source Database       : 12_31

Target Server Type    : MYSQL
Target Server Version : 50648
File Encoding         : 65001

Date: 2021-04-23 17:03:23
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for ds_o2o_errand_order
-- ----------------------------
DROP TABLE IF EXISTS `ds_o2o_errand_order`;
CREATE TABLE `ds_o2o_errand_order` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '跑腿订单ID',
  `type` tinyint(1) unsigned NOT NULL COMMENT '跑腿订单类型（0帮我买1帮我送）',
  `order_sn` varchar(60) NOT NULL COMMENT '跑腿订单号',
  `user_id` int(11) unsigned NOT NULL COMMENT '用户ID',
  `user_name` varchar(60) NOT NULL COMMENT '用户名称',
  `distributor_id` int(11) unsigned DEFAULT NULL COMMENT '配送员ID',
  `distributor_name` varchar(60) DEFAULT NULL COMMENT '配送员名称',
  `distributor_realname` varchar(60) DEFAULT NULL COMMENT '配送员姓名',
  `distributor_phone` varchar(60) DEFAULT NULL COMMENT '配送员手机号',
  `add_time` int(11) unsigned NOT NULL COMMENT '下单时间',
  `appointment_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '预约时间',
  `payment_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '支付时间',
  `pickup_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '取货时间',
  `receipt_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '接单时间',
  `finish_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '完成时间',
  `distance` float(10,1) unsigned NOT NULL COMMENT '距离',
  `pickup_name` varchar(60) NOT NULL COMMENT '取货点名称',
  `pickup_address` varchar(255) NOT NULL COMMENT '取货点地址',
  `pickup_phone` varchar(60) NOT NULL DEFAULT '' COMMENT '取货点手机',
  `pickup_lng` varchar(60) NOT NULL COMMENT '取货点经度',
  `pickup_lat` varchar(60) NOT NULL COMMENT '取货点纬度',
  `deliver_name` varchar(60) NOT NULL COMMENT '送货点名称',
  `deliver_address` varchar(255) NOT NULL COMMENT '送货点地址',
  `deliver_phone` varchar(60) NOT NULL COMMENT '送货点手机',
  `deliver_lng` varchar(60) NOT NULL COMMENT '送货点经度',
  `deliver_lat` varchar(60) NOT NULL COMMENT '送货点纬度',
  `detail` varchar(255) NOT NULL COMMENT '跑腿订单详情',
  `order_state` tinyint(1) unsigned NOT NULL COMMENT '跑腿订单状态（0已取消10待付款20待接单26待取货30派送中40已完成）',
  `receive_code` varchar(10) NOT NULL DEFAULT '' COMMENT '收货码',
  `order_amount` decimal(10,2) unsigned NOT NULL COMMENT '订单总费用',
  `distance_price` decimal(10,2) unsigned NOT NULL COMMENT '基础运费',
  `weight_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '重量附加费',
  `time_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '特殊时段费',
  `goods_price` decimal(10,2) unsigned NOT NULL COMMENT '预估商品价格',
  `gratuity` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '小费',
  `weight` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '重量',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `check_receive` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '需要当面收（0否1是）',
  `bill_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '跑腿订单结算ID',
  `deliver_region_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '送货点地区id',
  `pickup_region_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '取货点地区id',
  `if_evaluate` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否已评',
  `evaluate_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论时间',
  `evaluate_content` varchar(255) NOT NULL DEFAULT '' COMMENT '评论内容',
  `evaluate_score` decimal(2,1) unsigned NOT NULL DEFAULT '5.0' COMMENT '评分',
  `payment_code` varchar(60) NOT NULL DEFAULT '' COMMENT '支付代码',
  `payment_sn` varchar(255) NOT NULL DEFAULT '' COMMENT '第三方支付流水号',
  PRIMARY KEY (`id`)
 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='跑腿订单';

-- ----------------------------
-- Records of ds_o2o_errand_order
-- ----------------------------