配送員用戶模型 · 優行到家后端程序

~~~[sql] CREATE TABLE `xi_distributor` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(32) NOT NULL DEFAULT '' COMMENT '用戶名', `password` char(32) NOT NULL DEFAULT '' COMMENT '密碼', `auth_key` varchar(32) DEFAULT NULL COMMENT '認證密鑰', `mobile` varchar(16) NOT NULL COMMENT '手機號碼', `realname` varchar(16) NOT NULL COMMENT '真實姓名', `longitude` varchar(16) NOT NULL COMMENT '經度', `latitude` varchar(16) NOT NULL COMMENT '緯度', `type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '類型，1=>平臺配送員，2=>商家配送員', `work` 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`), UNIQUE KEY `username` (`username`), UNIQUE KEY `mobile` (`mobile`), UNIQUE KEY `auth_key` (`auth_key`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='配送員'; ~~~ ~~~[sql] CREATE TABLE `xi_distributor_wallet` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `distributor_id` int(11) unsigned NOT NULL COMMENT '配送員ID', `money` decimal(10,2) NOT NULL DEFAULT '0.00' 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`), UNIQUE KEY `distributor_id` (`distributor_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='配送員錢包'; ~~~ ~~~[sql] CREATE TABLE `xi_distributor_work_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `distributor_id` int(11) unsigned NOT NULL, `work` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '工作狀態，0=>休息中，1=>接單中', `longitude` varchar(16) NOT NULL COMMENT '經度', `latitude` varchar(16) NOT NULL COMMENT '緯度', `ip` varchar(16) NOT NULL DEFAULT '' COMMENT 'IP地址', `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='配送員工作日志'; ~~~ ~~~[sql] CREATE TABLE `xi_distributor_work_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `distributor_id` int(11) unsigned NOT NULL, `work` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '工作狀態，0=>休息中，1=>接單中', `longitude` varchar(16) NOT NULL COMMENT '經度', `latitude` varchar(16) NOT NULL COMMENT '緯度', `ip` varchar(16) NOT NULL DEFAULT '' COMMENT 'IP地址', `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='配送員工作日志'; ~~~