~~~[sql] CREATE TABLE `xi_shipping_order` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `order_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '订单ID', `stores_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '门店ID', `distributor_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '配送员ID', `sn` varchar(32) NOT NULL COMMENT '订单唯一编码', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_pickup` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否取货，0=>未取货，1=>已取货', `is_complete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否完成，0=>未完成，1=>已完成', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态，0=>禁用，1=>启用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '创建时间', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新时间', `pickup_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '取货时间', `complete_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '完成时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='配送订单'; ~~~ ~~~[sql] CREATE TABLE `xi_shipping_order_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `order_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '配送订单ID', `distributor_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '配送员ID', `operate` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '操作，1=>配送员接单，2=>配送员取货，3=>配送员完成', `remark` varchar(128) NOT NULL DEFAULT '' COMMENT '备注', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态，0=>禁用，1=>启用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '创建时间', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='配送订单日志'; ~~~ ~~~[sql] CREATE TABLE `xi_shipping_order_message` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) unsigned NOT NULL COMMENT '用户ID', `identity` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '身份，1=>配送员，2=>会员', `content` varchar(255) NOT NULL DEFAULT '' COMMENT '内容', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_read` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '已读，0=>否，1=>是', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态，0=>禁用，1=>启用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '创建时间', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='配送订单消息'; ~~~