配送訂單模型 · 優行到家后端程序

~~~[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='配送訂單消息'; ~~~