商家用戶模型 · 優行到家后端程序

~~~[sql] CREATE TABLE `xi_dealer` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父ID', `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 DEFAULT '' COMMENT '手機號碼', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' 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 `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_dealer_apply` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `stores_name` varchar(64) NOT NULL DEFAULT '' COMMENT '店鋪名稱', `stores_cate_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '店鋪分類', `province` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '省份', `city` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '城市', `district` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '地區', `twon` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '鄉鎮', `address` varchar(128) NOT NULL DEFAULT '' COMMENT '詳細地址', `mobile` varchar(16) NOT NULL COMMENT '手機號碼', `realname` varchar(16) NOT NULL DEFAULT '' COMMENT '真實姓名', `idcard_number` varchar(32) NOT NULL DEFAULT '' COMMENT '身份證號碼', `idcard_image` varchar(255) NOT NULL DEFAULT '' COMMENT '身份證圖片', `business_license_number` varchar(64) NOT NULL DEFAULT '' COMMENT '營業執照號碼', `business_license_image` varchar(255) NOT NULL DEFAULT '' COMMENT '營業執照圖片', `industry_additional_image` varchar(255) 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 COMMENT='商家申請'; ~~~ ~~~[sql] CREATE TABLE `xi_dealer_auth_assignment` ( `dealer_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商家ID', `role_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '角色ID', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', UNIQUE KEY `dealer_id` (`dealer_id`,`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商家權限分配'; ~~~ ~~~[sql] CREATE TABLE `xi_dealer_auth_permission` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `menu_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '菜單ID', `title` varchar(32) NOT NULL DEFAULT '' COMMENT '規則唯一標題', `module` varchar(64) NOT NULL DEFAULT '' COMMENT '模塊', `controller` varchar(64) NOT NULL DEFAULT '' COMMENT '控制器', `name` varchar(64) NOT NULL DEFAULT '' COMMENT '規則唯一標識', `condition` varchar(128) NOT NULL COMMENT '規則表達式', `icon` varchar(16) NOT NULL DEFAULT '' COMMENT '圖標', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_menu_show` tinyint(1) unsigned NOT NULL DEFAULT '0' 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 `name` (`name`,`is_trash`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='商家權限條目'; ~~~ ~~~[sql] CREATE TABLE `xi_dealer_auth_role` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `dealer_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商家ID', `name` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名稱', `permissions` text CHARACTER SET utf8 NOT NULL COMMENT '權限', `description` varchar(128) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '描述', `is_default` int(1) unsigned NOT NULL DEFAULT '0' 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 `name` (`name`,`dealer_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='商家權限角色'; ~~~ ~~~[sql] CREATE TABLE `xi_dealer_menu` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父ID', `name` varchar(16) NOT NULL DEFAULT '' COMMENT '標題', `module` varchar(32) NOT NULL DEFAULT '' COMMENT '模塊', `icon` varchar(32) NOT NULL DEFAULT '' COMMENT '圖標', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' 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 `name` (`name`,`parent_id`,`module`,`is_trash`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='商家菜單'; ~~~ ~~~[sql] CREATE TABLE `xi_dealer_wallet` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `dealer_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 `dealer_id` (`dealer_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商家錢包'; ~~~ ~~~[sql] CREATE TABLE `xi_dealer_wallet_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `dealer_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商家ID', `wallet_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '錢包ID', `operator_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作者ID', `recharge_sn` varchar(32) NOT NULL DEFAULT '' COMMENT '充值唯一編碼，生成規則用的是訂單sn號的規則', `operate` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '操作', `money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '金額', `before` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '變動前', `after` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '變動后', `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='商家錢包記錄'; ~~~