/* Navicat MySQL Data Transfer Source Server : always Source Server Version : 80012 Source Host : 120.78.182.218:3306 Source Database : xfw Target Server Type : MYSQL Target Server Version : 80012 File Encoding : 65001 Date: 2020-02-13 17:37:52 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for xfw_admin_menus -- ---------------------------- DROP TABLE IF EXISTS `xfw_admin_menus`; CREATE TABLE `xfw_admin_menus` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL COMMENT '菜单名称', `value` varchar(255) DEFAULT NULL COMMENT '链接地址', `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '模版地址', `icon` varchar(255) DEFAULT NULL COMMENT 'icon', `is_hidden` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否隐藏1是0否', `parent_id` int(11) NOT NULL, `order` int(11) DEFAULT '1' COMMENT '排序', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单'; -- ---------------------------- -- Records of xfw_admin_menus -- ---------------------------- INSERT INTO `xfw_admin_menus` VALUES ('1', '顶级菜单', null, null, null, '0', '0', '1', '2020-02-05 17:02:57', '2020-02-05 17:02:59', null); INSERT INTO `xfw_admin_menus` VALUES ('2', '系统设置', null, null, null, '0', '1', '1', '2020-02-05 17:58:44', '2020-02-05 17:58:44', null); INSERT INTO `xfw_admin_menus` VALUES ('3', '菜单管理', 'system/menu', 'system/menu', null, '0', '2', '2', '2020-02-05 18:01:38', '2020-02-05 18:01:38', null); INSERT INTO `xfw_admin_menus` VALUES ('4', '权限管理', 'system/permission', 'system/permission', null, '0', '2', '2', '2020-02-05 18:02:42', '2020-02-11 16:36:38', null); INSERT INTO `xfw_admin_menus` VALUES ('5', '角色管理', 'system/role', 'system/role', null, '1', '2', '2', '2020-02-05 18:02:52', '2020-02-11 16:36:54', null); INSERT INTO `xfw_admin_menus` VALUES ('6', '管理员管理', 'system/admin', 'system/admin', null, '0', '2', '3', '2020-02-11 16:37:12', '2020-02-11 16:37:12', null); INSERT INTO `xfw_admin_menus` VALUES ('7', '机构管理', null, null, null, '0', '1', '2', '2020-02-11 16:37:28', '2020-02-11 16:37:28', null); INSERT INTO `xfw_admin_menus` VALUES ('8', '机构列表', 'company/index', 'company/index', null, '0', '7', '1', '2020-02-11 16:37:45', '2020-02-11 16:37:45', null); INSERT INTO `xfw_admin_menus` VALUES ('9', '机构添加', 'company/add', 'company/add', null, '0', '7', '2', '2020-02-11 16:38:03', '2020-02-11 16:38:03', null); -- ---------------------------- -- Table structure for xfw_admin_permissions -- ---------------------------- DROP TABLE IF EXISTS `xfw_admin_permissions`; CREATE TABLE `xfw_admin_permissions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '权限名称', `alias` varchar(100) DEFAULT NULL COMMENT '操作权限名称', `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '权限地址', `parent_id` int(11) DEFAULT '0' COMMENT '父权限', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of xfw_admin_permissions -- ---------------------------- INSERT INTO `xfw_admin_permissions` VALUES ('1', '顶级权限', null, null, '0', '2020-02-08 14:30:35', '2020-02-08 14:30:37', null); INSERT INTO `xfw_admin_permissions` VALUES ('2', '公共权限', null, null, '1', '2020-02-13 16:18:22', '2020-02-13 16:18:22', null); INSERT INTO `xfw_admin_permissions` VALUES ('3', '账户登录', '/login', '/login', '2', '2020-02-13 16:18:52', '2020-02-13 16:18:52', null); INSERT INTO `xfw_admin_permissions` VALUES ('4', '文件上传', '/upload/{type}', '/upload/{type}', '2', '2020-02-13 16:19:37', '2020-02-13 16:19:37', null); INSERT INTO `xfw_admin_permissions` VALUES ('5', '个人信息', '/loginUser', '/loginUser', '2', '2020-02-13 16:24:47', '2020-02-13 16:24:47', null); INSERT INTO `xfw_admin_permissions` VALUES ('6', '我的权限', '/freshRole', '/freshRole', '2', '2020-02-13 16:24:59', '2020-02-13 16:24:59', null); -- ---------------------------- -- Table structure for xfw_admin_role_infos -- ---------------------------- DROP TABLE IF EXISTS `xfw_admin_role_infos`; CREATE TABLE `xfw_admin_role_infos` ( `user_id` int(11) NOT NULL, `role_id` int(11) NOT NULL, KEY `user_id` (`user_id`) USING BTREE, KEY `role_id` (`role_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of xfw_admin_role_infos -- ---------------------------- -- ---------------------------- -- Table structure for xfw_admin_role_menus -- ---------------------------- DROP TABLE IF EXISTS `xfw_admin_role_menus`; CREATE TABLE `xfw_admin_role_menus` ( `role_id` int(11) NOT NULL, `menu_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色菜单'; -- ---------------------------- -- Records of xfw_admin_role_menus -- ---------------------------- -- ---------------------------- -- Table structure for xfw_admin_role_permissions -- ---------------------------- DROP TABLE IF EXISTS `xfw_admin_role_permissions`; CREATE TABLE `xfw_admin_role_permissions` ( `permission_id` int(11) NOT NULL, `role_id` int(11) NOT NULL, KEY `role_id` (`role_id`) USING BTREE, KEY `permission_id` (`permission_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of xfw_admin_role_permissions -- ---------------------------- -- ---------------------------- -- Table structure for xfw_admin_roles -- ---------------------------- DROP TABLE IF EXISTS `xfw_admin_roles`; CREATE TABLE `xfw_admin_roles` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `state` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态0删除1正常', `description` varchar(255) DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of xfw_admin_roles -- ---------------------------- -- ---------------------------- -- Table structure for xfw_admins -- ---------------------------- DROP TABLE IF EXISTS `xfw_admins`; CREATE TABLE `xfw_admins` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `department_id` int(11) DEFAULT NULL COMMENT '部门编号', `name` varchar(80) NOT NULL COMMENT '账号', `nick_name` varchar(20) DEFAULT NULL COMMENT '昵称', `phone` char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '手机号', `password` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码', `real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '真实姓名', `id_number` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '身份证号', `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '邮箱', `open_id` varchar(60) DEFAULT NULL, `avatar` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '头像', `state` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态-1已删除0禁用1正常', `last_login_at` datetime DEFAULT NULL COMMENT '上次登录时间', `last_login_ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '上次登录IP', `now_login_at` datetime DEFAULT NULL COMMENT '本次登录时间', `now_login_ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '本次登陆ip', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='管理员'; -- ---------------------------- -- Records of xfw_admins -- ---------------------------- INSERT INTO `xfw_admins` VALUES ('1', null, 'admin', null, '18613236517', '$2y$10$Npit2TQrdZ3l3Jy4YJxOQOnMzFYs8DV6VdYr9xwfy9zw1XCb4wrYu', null, null, null, null, '', '1', '2020-02-01 19:10:43', '127.0.0.1', '2020-02-01 19:10:43', '127.0.0.1', '2020-02-01 19:10:43', '2020-02-11 16:24:16'); -- ---------------------------- -- Table structure for xfw_companies -- ---------------------------- DROP TABLE IF EXISTS `xfw_companies`; CREATE TABLE `xfw_companies` ( `id` int(11) NOT NULL AUTO_INCREMENT, `role` tinyint(2) NOT NULL DEFAULT '1' COMMENT '公司角色CompanyRole Enum', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '机构名称', `short_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '机构简称', `rate` decimal(2,1) DEFAULT '3.0' COMMENT '客户等级1-5级', `company_type` tinyint(2) DEFAULT NULL COMMENT '机构类别', `state` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态:1正常0禁用', `ticket_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开票名称', `register_no` varchar(25) DEFAULT NULL COMMENT '税号', `register_address` varchar(255) DEFAULT NULL COMMENT '注册场所地址', `register_phone` varchar(20) DEFAULT NULL COMMENT '注册电话', `bank_name` varchar(200) DEFAULT NULL COMMENT '开户行名称', `bank_no` varchar(50) DEFAULT NULL COMMENT '开户行账号', `regions` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '所在省市县', `address` varchar(500) DEFAULT NULL COMMENT '详细地址', `mobile` varchar(30) DEFAULT NULL COMMENT '固定电话', `url` varchar(200) DEFAULT NULL COMMENT '官网地址', `supplier_type` tinyint(2) DEFAULT NULL COMMENT '供应商类型', `contact_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人姓名', `contact_phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人手机号', `licence_pic` varchar(200) DEFAULT NULL COMMENT '营业执照', `desc` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '机构备注', `build_at` date DEFAULT NULL COMMENT '成立时间', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) USING BTREE, UNIQUE KEY `ticket_name` (`ticket_name`), UNIQUE KEY `register_no` (`register_no`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='机构'; -- ---------------------------- -- Records of xfw_companies -- ---------------------------- -- ---------------------------- -- Table structure for xfw_company_applies -- ---------------------------- DROP TABLE IF EXISTS `xfw_company_applies`; CREATE TABLE `xfw_company_applies` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '申请用户ID', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '机构名称', `short_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '简称', `department_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '所在部门', `company_type` int(11) DEFAULT NULL COMMENT '机构类型', `regions` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '所在地', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '详细地', `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '发票类型', `header_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '发票抬头', `register_no` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '税号', `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '开户行名称', `bank_no` varchar(30) DEFAULT NULL COMMENT '开户行账户', `licence_pic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '营业执照', `state` tinyint(4) DEFAULT '0' COMMENT '状态0待审核1审核通过2审核驳回', `desc` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'b备注', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='机构账户升级申请表'; -- ---------------------------- -- Records of xfw_company_applies -- ---------------------------- -- ---------------------------- -- Table structure for xfw_company_departments -- ---------------------------- DROP TABLE IF EXISTS `xfw_company_departments`; CREATE TABLE `xfw_company_departments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `company_id` int(11) NOT NULL COMMENT '机构ID', `name` varchar(255) DEFAULT NULL COMMENT '部门名称', `state` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态1正常0禁用', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='机构部门关联'; -- ---------------------------- -- Records of xfw_company_departments -- ---------------------------- -- ---------------------------- -- Table structure for xfw_company_invoices -- ---------------------------- DROP TABLE IF EXISTS `xfw_company_invoices`; CREATE TABLE `xfw_company_invoices` ( `id` int(11) NOT NULL AUTO_INCREMENT, `company_id` int(11) NOT NULL COMMENT '公司ID', `header_title` varchar(255) NOT NULL COMMENT '发票抬头', `type` tinyint(4) DEFAULT NULL COMMENT '发票类型0增值税普通发票1企业增值税普通发票2增值税专用发票3组织(非企业)增值税普通发票', `register_no` varchar(25) DEFAULT NULL COMMENT '税务登记证号', `bank_name` varchar(255) DEFAULT NULL COMMENT '开户行名称', `bank_no` varchar(100) DEFAULT NULL COMMENT '基本开户账号', `register_address` varchar(255) DEFAULT NULL COMMENT '注册场所地址', `register_phone` varchar(20) DEFAULT NULL COMMENT '注册固定电话', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `company_id` (`company_id`) USING BTREE, UNIQUE KEY `register_no` (`register_no`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='机构开票信息'; -- ---------------------------- -- Records of xfw_company_invoices -- ---------------------------- -- ---------------------------- -- Table structure for xfw_files -- ---------------------------- DROP TABLE IF EXISTS `xfw_files`; CREATE TABLE `xfw_files` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(50) NOT NULL COMMENT '上传位置', `originalName` varchar(230) NOT NULL COMMENT '上传的文件名', `mimeType` varchar(50) NOT NULL COMMENT '文件类型', `file_path` varchar(150) NOT NULL COMMENT '所在路径', `size` double NOT NULL COMMENT '文件大小', `width_height` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '图片尺寸', `created_at` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `file_path` (`file_path`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='图片库'; -- ---------------------------- -- Records of xfw_files -- ----------------------------