代码拉取完成，页面将自动刷新
Fork 仓库
加载中
确定同步？
同步操作将从 日照岳琛网络科技有限公司/辅学院开源培训系统 强制同步，此操作会覆盖自 Fork 仓库以来所做的任何修改，且无法恢复！！！
确定后同步将在后台操作，完成时将刷新页面，请耐心等待。
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259
/*
Navicat MySQL Data Transfer
Source Server : 101.43.135.126_3306
Source Server Version : 80024
Source Host : 101.43.135.126:3306
Source Database : yc_edu
Target Server Type : MYSQL
Target Server Version : 80024
File Encoding : 65001
Date: 2024-06-05 19:39:19
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for banner
-- ----------------------------
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '递增主键ID',
`object` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '源文件',
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0待上传1已上传',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
`create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '更新时间',
`create_user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者用户ID',
`create_user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者姓名',
`update_user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '更新者用户Id',
`update_user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '更新者用户姓名',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司ID',
`company_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records of banner
-- ----------------------------
-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '递增ID',
`uuid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一ID',
`title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类标题',
`parent_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '父ID',
`category_path` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类路径',
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
`weight` int unsigned NOT NULL DEFAULT '50' COMMENT '权重',
`create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '更新时间',
`create_user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者用户ID',
`update_user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '更新者用户ID',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司ID',
`company_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_uuid_comany_id` (`company_id`,`uuid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10477 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES ('7056', '830b1c71-31bf-4bbe-8c05-05a4a31291e6', '企业经营', '1', '1,830b1c71-31bf-4bbe-8c05-05a4a31291e6', '0', '0', '1', '2024-05-14 16:57:05', '2024-05-14 16:57:05', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('7057', '0985c1a0-4e30-4c6e-9faf-3d021b3ad3ca', '运营模块', '830b1c71-31bf-4bbe-8c05-05a4a31291e6', '1,830b1c71-31bf-4bbe-8c05-05a4a31291e6,0985c1a0-4e30-4c6e-9faf-3d021b3ad3ca', '0', '0', '2', '2024-05-14 16:57:13', '2024-05-14 16:57:13', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('7058', '21d428c8-c7ff-4699-92f7-1535a1d3694f', '领导模块', '0985c1a0-4e30-4c6e-9faf-3d021b3ad3ca', '1,830b1c71-31bf-4bbe-8c05-05a4a31291e6,0985c1a0-4e30-4c6e-9faf-3d021b3ad3ca,21d428c8-c7ff-4699-92f7-1535a1d3694f', '0', '0', '3', '2024-05-14 16:57:20', '2024-05-14 16:57:20', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8281', '3466194f-0e21-43fb-a1b1-b975d6c9acb1', '经验分享', '1', '1,3466194f-0e21-43fb-a1b1-b975d6c9acb1', '0', '0', '4', '2024-05-22 08:42:37', '2024-05-22 08:42:37', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8282', '37f075ce-6056-4122-8c97-e37682fb1203', '技术文档', '3466194f-0e21-43fb-a1b1-b975d6c9acb1', '1,3466194f-0e21-43fb-a1b1-b975d6c9acb1,37f075ce-6056-4122-8c97-e37682fb1203', '0', '0', '5', '2024-05-22 08:42:47', '2024-05-22 08:42:47', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8283', 'e757555a-03ac-4670-bf8b-d1239e51cdff', '行业方案', '3466194f-0e21-43fb-a1b1-b975d6c9acb1', '1,3466194f-0e21-43fb-a1b1-b975d6c9acb1,e757555a-03ac-4670-bf8b-d1239e51cdff', '0', '0', '6', '2024-05-22 08:43:01', '2024-05-22 08:43:01', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8284', 'c7e87ec1-0cbc-4f8c-b315-c5ebb4346c4c', '商务合作', '3466194f-0e21-43fb-a1b1-b975d6c9acb1', '1,3466194f-0e21-43fb-a1b1-b975d6c9acb1,c7e87ec1-0cbc-4f8c-b315-c5ebb4346c4c', '0', '0', '7', '2024-05-22 08:43:09', '2024-05-22 08:43:09', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8285', '7b520996-fffa-4587-a260-07e585f56379', '宣传文案', '3466194f-0e21-43fb-a1b1-b975d6c9acb1', '1,3466194f-0e21-43fb-a1b1-b975d6c9acb1,7b520996-fffa-4587-a260-07e585f56379', '0', '0', '8', '2024-05-22 08:43:20', '2024-05-22 08:43:20', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8286', '4ff47244-be24-4425-86db-bb44d86efd79', '售后服务', '3466194f-0e21-43fb-a1b1-b975d6c9acb1', '1,3466194f-0e21-43fb-a1b1-b975d6c9acb1,4ff47244-be24-4425-86db-bb44d86efd79', '0', '0', '9', '2024-05-22 08:43:34', '2024-05-22 08:43:34', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8287', 'a6313b94-7354-4abf-8b59-925f9958d757', '客户方案', '3466194f-0e21-43fb-a1b1-b975d6c9acb1', '1,3466194f-0e21-43fb-a1b1-b975d6c9acb1,a6313b94-7354-4abf-8b59-925f9958d757', '0', '0', '10', '2024-05-22 08:43:43', '2024-05-22 08:43:43', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8288', '45d28a46-50b7-4580-9523-81747eaea16e', '职业素养', '1', '1,45d28a46-50b7-4580-9523-81747eaea16e', '0', '0', '11', '2024-05-22 08:43:59', '2024-05-22 08:43:59', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8289', 'e8209fc7-c254-45a8-8d7b-f7bd10e08c4b', '语言学习', '45d28a46-50b7-4580-9523-81747eaea16e', '1,45d28a46-50b7-4580-9523-81747eaea16e,e8209fc7-c254-45a8-8d7b-f7bd10e08c4b', '0', '0', '12', '2024-05-22 08:44:13', '2024-05-22 08:44:13', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8290', 'cb00b41f-b902-4231-be57-88538132109d', '人际沟通', '45d28a46-50b7-4580-9523-81747eaea16e', '1,45d28a46-50b7-4580-9523-81747eaea16e,cb00b41f-b902-4231-be57-88538132109d', '0', '0', '13', '2024-05-22 08:44:26', '2024-05-22 08:44:26', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8291', '7b54f43d-93b6-497c-b708-3c35e977224f', '职场心态', '45d28a46-50b7-4580-9523-81747eaea16e', '1,45d28a46-50b7-4580-9523-81747eaea16e,7b54f43d-93b6-497c-b708-3c35e977224f', '0', '0', '14', '2024-05-22 08:44:38', '2024-05-22 08:44:38', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8292', 'bf831000-e4a7-4b99-840e-74cc7db9006e', '思维训练', '45d28a46-50b7-4580-9523-81747eaea16e', '1,45d28a46-50b7-4580-9523-81747eaea16e,bf831000-e4a7-4b99-840e-74cc7db9006e', '0', '0', '15', '2024-05-22 08:44:53', '2024-05-22 08:44:53', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8293', 'ccb1f245-9104-4ae2-8c22-87fb3b318212', '专业技能', '1', '1,ccb1f245-9104-4ae2-8c22-87fb3b318212', '0', '0', '16', '2024-05-22 08:45:07', '2024-05-22 08:45:07', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8294', '4f41a2b0-79b2-4366-b8a5-58fc0d3002f0', '生产研发', 'ccb1f245-9104-4ae2-8c22-87fb3b318212', '1,ccb1f245-9104-4ae2-8c22-87fb3b318212,4f41a2b0-79b2-4366-b8a5-58fc0d3002f0', '0', '0', '17', '2024-05-22 08:45:16', '2024-05-22 08:45:16', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8295', '78d69739-30ca-4175-a47a-bb8c5883ffd7', '市场营销', 'ccb1f245-9104-4ae2-8c22-87fb3b318212', '1,ccb1f245-9104-4ae2-8c22-87fb3b318212,78d69739-30ca-4175-a47a-bb8c5883ffd7', '0', '0', '18', '2024-05-22 08:45:27', '2024-05-22 08:45:27', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8296', '9f5e5378-5af9-4b4d-8d51-ce2c562cbfae', '人力资源', 'ccb1f245-9104-4ae2-8c22-87fb3b318212', '1,ccb1f245-9104-4ae2-8c22-87fb3b318212,9f5e5378-5af9-4b4d-8d51-ce2c562cbfae', '0', '0', '19', '2024-05-22 08:45:35', '2024-05-22 08:45:35', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('8297', '2a4b6b63-645f-4ebf-8cd8-286e6d088b64', '财务管理', 'ccb1f245-9104-4ae2-8c22-87fb3b318212', '1,ccb1f245-9104-4ae2-8c22-87fb3b318212,2a4b6b63-645f-4ebf-8cd8-286e6d088b64', '0', '0', '20', '2024-05-22 08:45:44', '2024-05-22 08:45:44', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `category` VALUES ('9849', '4932d915-fde8-4caf-b590-b6d8fb5cec5a', '阿迪达斯', '4f41a2b0-79b2-4366-b8a5-58fc0d3002f0', '1,ccb1f245-9104-4ae2-8c22-87fb3b318212,4f41a2b0-79b2-4366-b8a5-58fc0d3002f0,4932d915-fde8-4caf-b590-b6d8fb5cec5a', '0', '0', '21', '2024-05-31 14:12:08', '2024-05-31 14:12:08', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269', '');
-- ----------------------------
-- Table structure for courseware
-- ----------------------------
DROP TABLE IF EXISTS `courseware`;
CREATE TABLE `courseware` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '递增id',
`uuid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '课件uuid',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '课件标题',
`type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '课件类型',
`file_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件格式',
`course_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '课程ID',
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '0未删除1已删除',
`length` int unsigned NOT NULL DEFAULT '0' COMMENT '课件时长',
`weight` int unsigned NOT NULL DEFAULT '0' COMMENT '权重',
`create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '更新时间',
`create_user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者用户ID',
`update_user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '更新者用户ID',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司ID',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_uuid_company_id` (`company_id`,`course_id`,`uuid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=692 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records of courseware
-- ----------------------------
INSERT INTO `courseware` VALUES ('683', 'd911cf58-fa43-4b4e-8740-6b6ece29d991', '辅学院开源版', 'video', '', '82b4c1ff-369d-4449-a69d-a8f4fa129a09', '0', '71', '1', '2024-06-04 14:14:28', '2024-06-04 14:14:28', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `courseware` VALUES ('684', 'dbd03bb4-ee5f-4f76-9d21-5257afe3f722', '薪酬管理目标原则', 'video', '', '83069043-118a-4c30-a376-0f60a47d2ca5', '0', '476', '1', '2024-06-04 14:15:12', '2024-06-04 14:15:12', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `courseware` VALUES ('685', 'c7867fe8-9f6e-4672-abb5-1d02efba7c5c', '薪酬的定义和功能', 'video', '', '83069043-118a-4c30-a376-0f60a47d2ca5', '0', '456', '2', '2024-06-04 14:15:12', '2024-06-04 14:15:12', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `courseware` VALUES ('686', '08ba4c67-eed5-4635-b074-5232653b9fcd', '辅学院数字化学习解决方案(3)', 'document', '', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', '0', '300', '1', '2024-06-04 14:16:43', '2024-06-04 14:16:43', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `courseware` VALUES ('687', '5cc69ff9-07a3-41b1-946a-eb81f782e78c', '云上CT数字化学习方案', 'document', '', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', '0', '300', '2', '2024-06-04 14:16:43', '2024-06-04 14:16:43', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `courseware` VALUES ('688', 'c7867fe8-9f6e-4672-abb5-1d02efba7c5c', '薪酬的定义和功能', 'video', '', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', '0', '456', '3', '2024-06-04 14:16:43', '2024-06-04 14:16:43', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `courseware` VALUES ('689', 'dbd03bb4-ee5f-4f76-9d21-5257afe3f722', '薪酬管理目标原则', 'video', '', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', '0', '476', '4', '2024-06-04 14:16:43', '2024-06-04 14:16:43', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `courseware` VALUES ('690', 'eab5ff63-2d18-4865-9e4e-bdddc680e6d5', '企业培训人才发展', 'video', '', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', '0', '158', '5', '2024-06-04 14:16:43', '2024-06-04 14:16:43', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `courseware` VALUES ('691', 'd911cf58-fa43-4b4e-8740-6b6ece29d991', '辅学院开源版', 'video', '', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', '0', '71', '6', '2024-06-04 14:16:43', '2024-06-04 14:16:43', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269');
-- ----------------------------
-- Table structure for courseware_user
-- ----------------------------
DROP TABLE IF EXISTS `courseware_user`;
CREATE TABLE `courseware_user` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '递增主键',
`event_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '本表的唯一id',
`course_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '课程和关联课程id关联课件为阶段id',
`courseware_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '课件ID',
`courseware_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '课件标题',
`stage_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '阶段id',
`user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户ID',
`user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户姓名',
`learn_status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'learning' COMMENT '学习状态''learning''学习中''finished''已完成',
`start_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '开始学习时间',
`finish_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '完成时间',
`learn_time` float(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '学习时长',
`progress_bar` float(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '上次观看时间',
`length` int unsigned NOT NULL DEFAULT '0' COMMENT '课件总时长',
`progress` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '单个课件进度',
`source` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'course' COMMENT '课程培训来源区分',
`source_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '来源id',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
`update_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '更新时间',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司ID',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_lesson_id_dept_user_id_company_id` (`company_id`,`course_id`,`user_id`,`source_id`,`courseware_id`,`stage_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=487 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records of courseware_user
-- ----------------------------
INSERT INTO `courseware_user` VALUES ('484', '17297343-497a-4dd1-a3be-88c5781a1f65', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', '08ba4c67-eed5-4635-b074-5232653b9fcd', '辅学院数字化学习解决方案(3)', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', 'learning', '2024-06-04 14:19:47', '1970-01-01 00:00:00', '5.00', '5.00', '300', '1', 'course', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', '0', '2024-06-04 14:19:57', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `courseware_user` VALUES ('485', '189d3f86-7c2b-43ce-8c00-b7f7687afdf6', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', 'c7867fe8-9f6e-4672-abb5-1d02efba7c5c', '薪酬的定义和功能', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', 'learning', '2024-06-04 14:19:58', '1970-01-01 00:00:00', '77.52', '77.52', '456', '16', 'course', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', '0', '2024-06-04 14:21:21', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `courseware_user` VALUES ('486', 'a9c95efa-5c33-4700-ba0d-61fa2cf42a36', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', 'dbd03bb4-ee5f-4f76-9d21-5257afe3f722', '薪酬管理目标原则', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', 'learning', '2024-06-04 14:21:23', '1970-01-01 00:00:00', '5.00', '5.00', '476', '1', 'course', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', '0', '2024-06-04 14:21:30', '5d70aa10-b5af-4092-b968-d374dd133269');
-- ----------------------------
-- Table structure for credit_log
-- ----------------------------
DROP TABLE IF EXISTS `credit_log`;
CREATE TABLE `credit_log` (
`id` bigint NOT NULL AUTO_INCREMENT,
`uuid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一id',
`target_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '对象id',
`target_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '对象名称',
`module` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'user' COMMENT '所属模块',
`credit` int NOT NULL DEFAULT '0' COMMENT '获得学分数',
`user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '获得积分的用户id',
`user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '获得积分的用户名',
`create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '更新时间',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '备注',
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '企业id',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_company_user_target` (`company_id`,`user_id`,`target_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户学分记录表';
-- ----------------------------
-- Records of credit_log
-- ----------------------------
-- ----------------------------
-- Table structure for gen_table
-- ----------------------------
DROP TABLE IF EXISTS `gen_table`;
CREATE TABLE `gen_table` (
`table_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
`table_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '表名称',
`table_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '表描述',
`sub_table_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '关联子表的表名',
`sub_table_fk_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '子表关联的外键名',
`class_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '实体类名称',
`tpl_category` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作）',
`package_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '生成包路径',
`module_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '生成模块名',
`business_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '生成业务名',
`function_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '生成功能名',
`function_author` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '生成功能作者',
`gen_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）',
`gen_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '/' COMMENT '生成路径（不填默认项目路径）',
`options` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '其它生成选项',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`table_id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='代码生成业务表';
-- ----------------------------
-- Records of gen_table
-- ----------------------------
INSERT INTO `gen_table` VALUES ('90', 'category', '', null, null, 'Category', 'crud', 'com.ruoyi.system', 'system', 'category', null, 'ruoyi', '0', '/', null, '', '2023-10-14 10:23:11', '', null, null);
-- ----------------------------
-- Table structure for gen_table_column
-- ----------------------------
DROP TABLE IF EXISTS `gen_table_column`;
CREATE TABLE `gen_table_column` (
`column_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
`table_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '归属表编号',
`column_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '列名称',
`column_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '列描述',
`column_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '列类型',
`java_type` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'JAVA类型',
`java_field` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'JAVA字段名',
`is_pk` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否主键（1是）',
`is_increment` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否自增（1是）',
`is_required` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否必填（1是）',
`is_insert` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否为插入字段（1是）',
`is_edit` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否编辑字段（1是）',
`is_list` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否列表字段（1是）',
`is_query` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否查询字段（1是）',
`query_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）',
`html_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
`dict_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '字典类型',
`sort` int DEFAULT NULL COMMENT '排序',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`column_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2448 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='代码生成业务表字段';
-- ----------------------------
-- Records of gen_table_column
-- ----------------------------
INSERT INTO `gen_table_column` VALUES ('2435', '90', 'id', '递增ID', 'bigint(20) unsigned', 'Long', 'id', '1', '1', null, '1', null, null, null, 'EQ', 'input', '', '1', '', '2023-10-14 10:23:11', '', null);
INSERT INTO `gen_table_column` VALUES ('2436', '90', 'uuid', '唯一ID', 'varchar(36)', 'String', 'uuid', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', '2', '', '2023-10-14 10:23:11', '', null);
INSERT INTO `gen_table_column` VALUES ('2437', '90', 'title', '分类标题', 'varchar(64)', 'String', 'title', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', '3', '', '2023-10-14 10:23:11', '', null);
INSERT INTO `gen_table_column` VALUES ('2438', '90', 'parent_id', '父ID', 'varchar(36)', 'String', 'parentId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', '4', '', '2023-10-14 10:23:11', '', null);
INSERT INTO `gen_table_column` VALUES ('2439', '90', 'status', '状态', 'tinyint(1)', 'Integer', 'status', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'radio', '', '5', '', '2023-10-14 10:23:11', '', null);
INSERT INTO `gen_table_column` VALUES ('2440', '90', 'is_delete', '是否删除', 'tinyint(1) unsigned', 'Integer', 'isDelete', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', '6', '', '2023-10-14 10:23:12', '', null);
INSERT INTO `gen_table_column` VALUES ('2441', '90', 'weight', '权重', 'int(11) unsigned', 'Long', 'weight', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', '7', '', '2023-10-14 10:23:12', '', null);
INSERT INTO `gen_table_column` VALUES ('2442', '90', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', '1', '1', null, null, null, 'EQ', 'datetime', '', '8', '', '2023-10-14 10:23:12', '', null);
INSERT INTO `gen_table_column` VALUES ('2443', '90', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', '1', '1', '1', null, null, 'EQ', 'datetime', '', '9', '', '2023-10-14 10:23:12', '', null);
INSERT INTO `gen_table_column` VALUES ('2444', '90', 'create_user_id', '创建者用户ID', 'varchar(36)', 'String', 'createUserId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', '10', '', '2023-10-14 10:23:12', '', null);
INSERT INTO `gen_table_column` VALUES ('2445', '90', 'update_user_id', '更新者用户ID', 'varchar(36)', 'String', 'updateUserId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', '11', '', '2023-10-14 10:23:12', '', null);
INSERT INTO `gen_table_column` VALUES ('2446', '90', 'company_id', '公司ID', 'varchar(64)', 'String', 'companyId', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', '12', '', '2023-10-14 10:23:12', '', null);
INSERT INTO `gen_table_column` VALUES ('2447', '90', 'company_name', '公司名称', 'varchar(50)', 'String', 'companyName', '0', '0', '1', '1', '1', '1', '1', 'LIKE', 'input', '', '13', '', '2023-10-14 10:23:12', '', null);
-- ----------------------------
-- Table structure for knowledge
-- ----------------------------
DROP TABLE IF EXISTS `knowledge`;
CREATE TABLE `knowledge` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '递增主键',
`uuid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一uuid',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '课程标题',
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '课程状态-1已删除0未发布1已发布2已关闭3已删除',
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '1删除0未删除',
`category_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类ID',
`category_title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类名称',
`credit` int NOT NULL DEFAULT '0' COMMENT '学分',
`certificate` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '证书id',
`learn_mode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'liberty' COMMENT '学习模式 liberty为自由式,unlock为解锁式',
`lector_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '讲师id',
`sync_learn` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'close' COMMENT '同步已学习进度',
`picture` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '课程封面',
`speed` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'close' COMMENT 'close倍速关闭 open开启',
`drag` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'close' COMMENT 'close关闭拖动open开启',
`model` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1' COMMENT '1是默认管理范围2是指定管理范围',
`courseware_num` int NOT NULL DEFAULT '0' COMMENT '课件数量',
`duration` int NOT NULL DEFAULT '0' COMMENT '课程时长',
`eligible` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'all' COMMENT '奖励标准',
`learn_progress` int NOT NULL DEFAULT '0' COMMENT '奖励学习进度',
`publish_time` datetime DEFAULT '1970-01-01 00:00:00' COMMENT '发布时间',
`create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '更新时间',
`create_user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者用户ID',
`update_user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '更新者用户ID',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司ID',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_uuid_company_id` (`company_id`,`uuid`) USING BTREE,
KEY `idx_compamy_id_lector_id` (`company_id`) USING BTREE,
KEY `idx_create_time` (`company_id`,`create_time`) USING BTREE,
KEY `idx_source` (`company_id`) USING BTREE,
KEY `idx_company_source` (`company_id`) USING BTREE,
KEY `idx_company_title` (`company_id`,`title`(191)) USING BTREE,
KEY `idx_public` (`company_id`) USING BTREE,
KEY `idx_companyId_createUser_type` (`company_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records of knowledge
-- ----------------------------
INSERT INTO `knowledge` VALUES ('176', '82b4c1ff-369d-4449-a69d-a8f4fa129a09', '开源培训系统介绍', '1', '0', 'ccb1f245-9104-4ae2-8c22-87fb3b318212', '专业技能', '0', '', '1', '', 'close', '5d70aa10-b5af-4092-b968-d374dd133269/course/image/cMEjDePdPK1715765841124.png', 'close', 'close', '2', '1', '71', 'all', '0', '2024-06-04 14:14:44', '2024-06-04 14:14:18', '2024-06-04 14:14:44', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `knowledge` VALUES ('177', '83069043-118a-4c30-a376-0f60a47d2ca5', '薪酬管理制度', '1', '0', 'ccb1f245-9104-4ae2-8c22-87fb3b318212', '专业技能', '0', '', '1', '', 'close', '5d70aa10-b5af-4092-b968-d374dd133269/course/image/H6G2256CXh1715763131325.png', 'close', 'close', '1', '2', '932', 'all', '0', '2024-06-04 14:15:18', '2024-06-04 14:15:07', '2024-06-04 14:15:18', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `knowledge` VALUES ('178', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', '多种课件学习', '1', '0', 'ccb1f245-9104-4ae2-8c22-87fb3b318212', '专业技能', '0', '', '1', '', 'close', '5d70aa10-b5af-4092-b968-d374dd133269/course/image/wAEepSJaB51715765849083.png', 'close', 'close', '2', '6', '1761', 'all', '0', '2024-06-04 14:16:54', '2024-06-04 14:16:37', '2024-06-04 14:16:54', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269');
-- ----------------------------
-- Table structure for knowledge_user
-- ----------------------------
DROP TABLE IF EXISTS `knowledge_user`;
CREATE TABLE `knowledge_user` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '递增ID',
`target_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '目标id',
`target_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '目标标题',
`user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户ID',
`user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者用户姓名',
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
`credit` int DEFAULT '0' COMMENT '学分',
`courseware_num` int unsigned DEFAULT '0' COMMENT '课件总数',
`courseware_finish_num` int unsigned DEFAULT '0' COMMENT '课件完成数量',
`progress` tinyint unsigned DEFAULT '0' COMMENT '学习总进度',
`learn_status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'learning' COMMENT '学习状态',
`learn_time` int NOT NULL DEFAULT '0' COMMENT '学习时长',
`finish_time` datetime DEFAULT '1970-01-01 00:00:00' COMMENT '完成时间',
`publish_time` datetime DEFAULT '1970-01-01 00:00:00' COMMENT '课程发布时间',
`source` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'course' COMMENT '来源',
`source_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '来源id',
`create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '更新时间',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司ID',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_target_dept_user_comany_id` (`company_id`,`target_id`,`source_id`,`user_id`) USING BTREE,
KEY `idx_company_target_learn_type` (`company_id`,`target_id`) USING BTREE,
KEY `idx_user_is_delete_status_learn_status` (`company_id`,`user_id`,`is_delete`,`learn_status`) USING BTREE,
KEY `idx_user_update_time` (`company_id`,`user_id`,`update_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=758 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records of knowledge_user
-- ----------------------------
INSERT INTO `knowledge_user` VALUES ('757', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', '多种课件学习', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '0', '0', '6', '0', '4', 'learning', '87', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'course', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', '2024-06-04 14:19:57', '2024-06-04 14:21:30', '5d70aa10-b5af-4092-b968-d374dd133269');
-- ----------------------------
-- Table structure for knowledge_visible
-- ----------------------------
DROP TABLE IF EXISTS `knowledge_visible`;
CREATE TABLE `knowledge_visible` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '递增ID',
`home_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一ID',
`name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '可见范围名称',
`scope_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '范围类型dept部门user人员',
`target_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '目标Id',
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
`create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '更新时间',
`create_user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者用户ID',
`update_user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '更新者用户ID',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司ID',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_visible_id_target_id_company_id` (`company_id`,`home_id`,`target_id`) USING BTREE,
KEY `uk_companyLector` (`company_id`) USING BTREE,
KEY `idx_company_target_learnType` (`company_id`,`target_id`) USING BTREE,
KEY `idx_visibleid_companyid_status_isdelete_targetid` (`company_id`,`home_id`,`is_delete`,`target_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=502 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records of knowledge_visible
-- ----------------------------
INSERT INTO `knowledge_visible` VALUES ('499', '1', '自建企业web版', 'dept', '82b4c1ff-369d-4449-a69d-a8f4fa129a09', '0', '2024-06-04 14:14:43', '2024-06-04 14:14:43', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `knowledge_visible` VALUES ('500', '1', '自建企业web版', 'dept', '83069043-118a-4c30-a376-0f60a47d2ca5', '0', '2024-06-04 14:15:18', '2024-06-04 14:15:18', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `knowledge_visible` VALUES ('501', '1', '自建企业web版', 'dept', '2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', '0', '2024-06-04 14:16:52', '2024-06-04 14:16:52', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '5d70aa10-b5af-4092-b968-d374dd133269');
-- ----------------------------
-- Table structure for lector
-- ----------------------------
DROP TABLE IF EXISTS `lector`;
CREATE TABLE `lector` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`lector_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '讲师id',
`lector_name` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '讲师名称',
`lector_avatar` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '头像',
`lector_grade` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '讲师等级id',
`lector_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'interior' COMMENT 'interior内部external外部',
`contact_way` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '联系方式',
`synopsis` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '讲师简介',
`sex` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'man' COMMENT 'man男woman女',
`status` tinyint(1) DEFAULT '0' COMMENT '状态',
`is_delete` tinyint(1) DEFAULT '0' COMMENT '1是删除',
`create_time` datetime DEFAULT '1970-01-01 00:00:00' COMMENT '创建时间',
`update_time` datetime DEFAULT '1970-01-01 00:00:00' COMMENT '修改时间',
`create_user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建人',
`update_user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '修改人',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '公司id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records of lector
-- ----------------------------
-- ----------------------------
-- Table structure for lector_grade
-- ----------------------------
DROP TABLE IF EXISTS `lector_grade`;
CREATE TABLE `lector_grade` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`uuid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一id',
`title` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '等级名称',
`type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'interior' COMMENT 'interior内部external外部',
`synopsis` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '等级说明',
`create_time` datetime DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
`create_user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建人',
`update_user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '修改人id',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records of lector_grade
-- ----------------------------
-- ----------------------------
-- Table structure for log
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '递增ID',
`module` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '模块名称',
`controller` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '控制器名称',
`action` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '操作项',
`request_url` varchar(2550) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '请求路由',
`source` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'dingDingIsv' COMMENT '来源：dingDingIsv,dingDingSelf,weiXin,platform',
`type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'admin' COMMENT '操作类型：admin后台操作home前台操作other其他',
`target_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '操作对象ID',
`code` mediumint unsigned NOT NULL DEFAULT '0' COMMENT '错误码0代表没有错误大于0代表有错误',
`message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日志内容',
`conditions` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '查询条件',
`data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '操作数据内容',
`ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'ip地址',
`level` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '日志级别1.error 2.warning 3.info',
`create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '创建时间',
`create_user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者用户ID',
`create_user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者用户姓名',
`create_dept_user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者公司内ID',
`create_dept_user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者用户名称',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司ID',
`company_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
PRIMARY KEY (`id`),
KEY `idx_target_id_company_id` (`company_id`,`target_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records of log
-- ----------------------------
-- ----------------------------
-- Table structure for material_library
-- ----------------------------
DROP TABLE IF EXISTS `material_library`;
CREATE TABLE `material_library` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '递增主键ID',
`uuid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一ID',
`title` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '课件标题',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件名',
`category_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'empty' COMMENT '分类ID',
`category_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类名称',
`lector_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '讲师id',
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0待上传1已上传',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
`use_range` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'default' COMMENT 'all全部管理员default系统管理范围',
`size` bigint unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
`length` int unsigned NOT NULL DEFAULT '0' COMMENT '时长',
`object` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '源文件',
`trans_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '转完后的路径',
`trans_code_status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '0转码中1转码成功2转码失败',
`file_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件格式',
`type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '媒体类型video视频audio音频document文档',
`job_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '转码任务ID百度和阿里云的都放在这里面',
`create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '更新时间',
`create_user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者用户ID',
`create_user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者姓名',
`update_user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '更新者用户Id',
`update_user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '更新者用户姓名',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司ID',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_uuid_company_id` (`company_id`,`uuid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=665 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records of material_library
-- ----------------------------
INSERT INTO `material_library` VALUES ('659', 'd911cf58-fa43-4b4e-8740-6b6ece29d991', '辅学院开源版', '辅学院开源版.mp4', 'ccb1f245-9104-4ae2-8c22-87fb3b318212', '专业技能', '', '0', '0', 'default', '12341315', '71', '5d70aa10-b5af-4092-b968-d374dd133269/lesson/video/b7PkCnJKnM1717479632551.mp4', '5d70aa10-b5af-4092-b968-d374dd133269/lesson/video/b7PkCnJKnM1717479632551.m3u8', '1', '', 'video', '1032c56d81b447aba8b62c45a243c4fe', '2024-06-04 13:40:37', '2024-06-04 13:40:37', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `material_library` VALUES ('660', 'eab5ff63-2d18-4865-9e4e-bdddc680e6d5', '企业培训人才发展', '企业培训人才发展.mp4', 'ccb1f245-9104-4ae2-8c22-87fb3b318212', '专业技能', '', '0', '0', 'default', '239998369', '158', '5d70aa10-b5af-4092-b968-d374dd133269/lesson/video/AEsTZXXfDZ1717479651912.mp4', '5d70aa10-b5af-4092-b968-d374dd133269/lesson/video/AEsTZXXfDZ1717479651912.m3u8', '1', '', 'video', '91ff40aa647d4b9884ad37a9ea5b35ac', '2024-06-04 13:43:37', '2024-06-04 13:43:37', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `material_library` VALUES ('661', 'dbd03bb4-ee5f-4f76-9d21-5257afe3f722', '薪酬管理目标原则', '薪酬管理目标原则.mp4', 'ccb1f245-9104-4ae2-8c22-87fb3b318212', '专业技能', '', '0', '0', 'default', '40923176', '476', '5d70aa10-b5af-4092-b968-d374dd133269/lesson/video/FFQwDT62kK1717481430743.mp4', '5d70aa10-b5af-4092-b968-d374dd133269/lesson/video/FFQwDT62kK1717481430743.m3u8', '1', '', 'video', '38707b9994bd41f3a02f238674b9b65e', '2024-06-04 14:10:44', '2024-06-04 14:10:44', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `material_library` VALUES ('662', 'c7867fe8-9f6e-4672-abb5-1d02efba7c5c', '薪酬的定义和功能', '薪酬的定义和功能.mp4', 'ccb1f245-9104-4ae2-8c22-87fb3b318212', '专业技能', '', '0', '0', 'default', '57686213', '456', '5d70aa10-b5af-4092-b968-d374dd133269/lesson/video/QfKCPynHEX1717481517320.mp4', '5d70aa10-b5af-4092-b968-d374dd133269/lesson/video/QfKCPynHEX1717481517320.m3u8', '1', '', 'video', 'b079a3b9d88a461eabb00be224a67a70', '2024-06-04 14:12:22', '2024-06-04 14:12:22', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `material_library` VALUES ('663', '5cc69ff9-07a3-41b1-946a-eb81f782e78c', '云上CT数字化学习方案', '云上CT数字化学习方案.pptx', 'ccb1f245-9104-4ae2-8c22-87fb3b318212', '专业技能', '', '0', '0', 'default', '29639864', '300', '5d70aa10-b5af-4092-b968-d374dd133269/lesson/document/JKYX3jxRnM1717481566823.pptx', '', '1', '', 'document', '', '2024-06-04 14:12:59', '2024-06-04 14:12:59', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '5d70aa10-b5af-4092-b968-d374dd133269');
INSERT INTO `material_library` VALUES ('664', '08ba4c67-eed5-4635-b074-5232653b9fcd', '辅学院数字化学习解决方案(3)', '辅学院数字化学习解决方案(3).pptx', 'ccb1f245-9104-4ae2-8c22-87fb3b318212', '专业技能', '', '0', '0', 'default', '2883732', '300', '5d70aa10-b5af-4092-b968-d374dd133269/lesson/document/k7mH54Ztew1717481627650.pptx', '', '1', '', 'document', '', '2024-06-04 14:13:50', '2024-06-04 14:13:50', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '5d70aa10-b5af-4092-b968-d374dd133269');
-- ----------------------------
-- Table structure for mentor
-- ----------------------------
DROP TABLE IF EXISTS `mentor`;
CREATE TABLE `mentor` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`mentor_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '导师id',
`mentor_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '导师名称',
`mentor_avatar` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`mentor_grade` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '讲师等级id',
`synopsis` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '简介',
`sex` tinyint(1) DEFAULT '0' COMMENT '0男1女',
`status` tinyint(1) DEFAULT '0' COMMENT '状态',
`is_delete` tinyint(1) DEFAULT '0' COMMENT '1是删除',
`create_time` datetime DEFAULT '1970-01-01 00:00:00' COMMENT '创建时间',
`update_time` datetime DEFAULT '1970-01-01 00:00:00' COMMENT '修改时间',
`create_user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建人',
`update_user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '修改人',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '公司id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records of mentor
-- ----------------------------
-- ----------------------------
-- Table structure for mentor_grade
-- ----------------------------
DROP TABLE IF EXISTS `mentor_grade`;
CREATE TABLE `mentor_grade` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`uuid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一id',
`title` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '等级名称',
`type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'interior' COMMENT 'interior内部external外部',
`synopsis` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '等级说明',
`create_time` datetime DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
`create_user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建人',
`update_user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '修改人id',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records of mentor_grade
-- ----------------------------
-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '递增主键',
`sync_action` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '事件英文名',
`suite_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '用户购买第三方企业应用的suiteId',
`suite_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户购买第三方企业应用的suiteKey',
`corp_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '购买企业的corpId',
`goods_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品码',
`item_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '规格码',
`max_of_people` int unsigned NOT NULL DEFAULT '0' COMMENT '规格支持最大使用人数',
`min_of_people` int unsigned NOT NULL DEFAULT '0' COMMENT '规格支持最小使用人数',
`order_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '订单id',
`paid_time` int unsigned NOT NULL DEFAULT '0' COMMENT '支付时间',
`service_stop_time` int unsigned NOT NULL DEFAULT '0' COMMENT '服务结束时间',
`pay_fee` int unsigned NOT NULL DEFAULT '0' COMMENT '实际支付价格（单位：分）',
`order_create_source` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '订单创建来源，若值为TIANYUAN，表示来自天元系统平台',
`nominal_pay_fee` int unsigned NOT NULL DEFAULT '0' COMMENT '名义票面费用（单位：分），现与payFee值相等',
`discount_fee` int unsigned NOT NULL DEFAULT '0' COMMENT '折扣减免费用（单位：分），现值为0',
`discount` double(11,2) unsigned NOT NULL DEFAULT '1.00' COMMENT '折扣，现值为1.00',
`distributor_corp_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分销商企业corpId',
`distributor_corp_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分销商企业名称',
`solution_package_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '解决方案名称',
`article_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'normal' COMMENT '商品类型：normal普通商品，image:OXM镜像商品',
`sub_quantity` int unsigned NOT NULL DEFAULT '0' COMMENT '购买数量',
`service_start_time` int unsigned NOT NULL DEFAULT '0' COMMENT '服务开始时间（单位：毫秒）',
`order_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '订单类型，BUY新购，RENEW续费，UPGRADE升级，RENEW_UPGRADE续费升配，RENEW_DEGRADE续费降配',
`status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '订单状态，0未生效1已生效',
`order_time` int unsigned NOT NULL DEFAULT '0' COMMENT '订单创建时间',
`leads_from` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'dingDingIsv' COMMENT '订单平台来源',
`purchase_type` tinyint(1) DEFAULT '1' COMMENT '购买类型。',
`event_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '事件原内容',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_buy_corp_order_id` (`corp_id`,`order_id`) USING BTREE,
KEY `idx_distributor_corp_id` (`distributor_corp_id`) USING BTREE,
KEY `idx_paid_time` (`paid_time`) USING BTREE,
KEY `idx_create_source` (`order_create_source`) USING BTREE,
KEY `idx_article_type` (`article_type`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='订单表';
-- ----------------------------
-- Records of order
-- ----------------------------
-- ----------------------------
-- Table structure for picture
-- ----------------------------
DROP TABLE IF EXISTS `picture`;
CREATE TABLE `picture` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '递增主键ID',
`uuid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一ID',
`type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'course' COMMENT '图片类型',
`object` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '源文件',
`style_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'colum' COMMENT '横板竖版',
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0待上传1已上传',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
`create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '更新时间',
`create_user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者用户ID',
`create_user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者姓名',
`update_user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '更新者用户Id',
`update_user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '更新者用户姓名',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司ID',
`company_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_uuid_company_id` (`company_id`,`uuid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records of picture
-- ----------------------------
INSERT INTO `picture` VALUES ('163', '02a91ae3-01b2-4be6-a585-2476c6c29318', 'course', '5d70aa10-b5af-4092-b968-d374dd133269/course/image/H6G2256CXh1715763131325.png', 'colum', '1', '0', '2024-05-15 16:52:12', '1970-01-01 00:00:00', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `picture` VALUES ('164', '8b6724a7-8c11-450f-9ba0-d9f4048ea7d3', 'course', '5d70aa10-b5af-4092-b968-d374dd133269/course/image/cMEjDePdPK1715765841124.png', 'colum', '1', '0', '2024-05-15 17:37:22', '1970-01-01 00:00:00', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `picture` VALUES ('165', '8697aa14-de39-497f-812c-05c99f4583ef', 'course', '5d70aa10-b5af-4092-b968-d374dd133269/course/image/wAEepSJaB51715765849083.png', 'colum', '1', '0', '2024-05-15 17:37:29', '1970-01-01 00:00:00', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `picture` VALUES ('166', 'c6f6cd65-47b2-4245-9d95-3113f990a674', 'course', '5d70aa10-b5af-4092-b968-d374dd133269/course/image/6nNN7f6f521715765853141.png', 'colum', '1', '0', '2024-05-15 17:37:33', '1970-01-01 00:00:00', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '', '5d70aa10-b5af-4092-b968-d374dd133269', '');
-- ----------------------------
-- Table structure for setting
-- ----------------------------
DROP TABLE IF EXISTS `setting`;
CREATE TABLE `setting` (
`id` bigint NOT NULL AUTO_INCREMENT,
`sync` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'proceed' COMMENT '同步状态',
`company_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records of setting
-- ----------------------------
-- ----------------------------
-- Table structure for sys_company
-- ----------------------------
DROP TABLE IF EXISTS `sys_company`;
CREATE TABLE `sys_company` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`company_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司id',
`company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '公司名称',
`corp_logo` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '企业logo',
`order_num` int DEFAULT '0' COMMENT '显示顺序',
`type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '企业类型',
`permanent_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'qv永久授权码',
`is_lock` tinyint(1) DEFAULT '0' COMMENT '是否到期',
`auth_user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '授权人员',
`auth_mode` tinyint(1) DEFAULT '0' COMMENT '0为管理员授权1为成员授权',
`is_system_auth_open` tinyint(1) DEFAULT '0' COMMENT '是否开启系统内权限',
`leader` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '负责人',
`agent_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '授权应用id',
`phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '联系电话',
`email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邮箱',
`auth_account` int DEFAULT '0' COMMENT '授权数量',
`buy_account` int DEFAULT '0' COMMENT '购买账号数',
`auth_time` datetime DEFAULT '1970-01-01 00:00:00' COMMENT '授权时间',
`trans_code_length` bigint DEFAULT '0' COMMENT '转码时长',
`used_space` bigint DEFAULT '0' COMMENT '使用oss存储',
`extra_space` bigint DEFAULT '0' COMMENT '购买存储',
`total_space` bigint DEFAULT '20480' COMMENT '总存储空间',
`status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
`is_delete` tinyint(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
`is_pay` tinyint(1) DEFAULT '0' COMMENT '1已购买',
`is_init` tinyint(1) DEFAULT '0' COMMENT '是否初始化企业数据',
`period_validity` datetime DEFAULT '1970-01-01 00:00:00' COMMENT '有效期',
`edition` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'free' COMMENT 'free免费norm标准版',
`buy_num` int DEFAULT '0' COMMENT '购买账号数量',
`accredit_num` int DEFAULT '0' COMMENT '授权数量',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=183 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='公司表';
-- ----------------------------
-- Records of sys_company
-- ----------------------------
INSERT INTO `sys_company` VALUES ('181', '5d70aa10-b5af-4092-b968-d374dd133269', '自建企业web版', '', '0', 'web', '', '0', '', '0', '0', null, '', null, null, '0', '0', '1970-01-01 00:00:00', '0', '2101', '0', '20480', '0', '0', '0', '0', '1970-01-01 00:00:00', 'free', '0', '0', '', null, '', '2024-06-04 00:00:00');
-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
`config_id` int NOT NULL AUTO_INCREMENT COMMENT '参数主键',
`config_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '参数名称',
`config_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '参数键名',
`config_value` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '参数键值',
`config_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`config_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='参数配置表';
-- ----------------------------
-- Records of sys_config
-- ----------------------------
INSERT INTO `sys_config` VALUES ('1', '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2021-11-14 14:56:31', '', null, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
INSERT INTO `sys_config` VALUES ('2', '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2021-11-14 14:56:31', '', null, '初始化密码 123456');
INSERT INTO `sys_config` VALUES ('3', '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2021-11-14 14:56:31', '', null, '深色主题theme-dark，浅色主题theme-light');
INSERT INTO `sys_config` VALUES ('4', '账号自助-验证码开关', 'sys.account.captchaOnOff', 'true', 'Y', 'admin', '2021-11-14 14:56:32', '', null, '是否开启验证码功能（true开启，false关闭）');
INSERT INTO `sys_config` VALUES ('5', '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2021-11-14 14:56:32', '', null, '是否开启注册用户功能（true开启，false关闭）');
-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`dept_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门id',
`dept_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '部门名称',
`parent_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '父部门id',
`dept_id_path` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '部门ID父路径',
`dept_name_path` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '部门姓名父路径',
`ancestors` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '祖级列表',
`order_num` int DEFAULT '0' COMMENT '显示顺序',
`member_count` int DEFAULT '0' COMMENT '人员数量',
`leader` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '负责人',
`phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '联系电话',
`email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邮箱',
`status` tinyint(1) DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
`is_delete` tinyint(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
`create_time` datetime DEFAULT '1970-01-01 00:00:00' COMMENT '创建时间',
`update_time` datetime DEFAULT '1970-01-01 00:00:00' COMMENT '更新时间',
`company_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司id',
`company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '公司名称',
PRIMARY KEY (`id`),
UNIQUE KEY `companydept` (`company_id`,`dept_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1150 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='部门表';
-- ----------------------------
-- Records of sys_dept
-- ----------------------------
INSERT INTO `sys_dept` VALUES ('1134', '1', '自建企业web版', '0', '1', '自建企业web版', '1', '1', '0', null, null, null, '1', '0', '', '', '2024-04-12 14:44:36', '2024-04-12 14:44:36', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_dept` VALUES ('1144', 'd9e2575c-fe06-4539-831e-3c3b7e1b1fc8', '技术部', '180b70fc-8def-4771-8ce5-420c93b30029', '1,63a7c0e0-9238-454c-85d2-17c5b91b2f09,2e3bd226-ed99-4e67-8022-87228b9619a6,180b70fc-8def-4771-8ce5-420c93b30029,d9e2575c-fe06-4539-831e-3c3b7e1b1fc8', '自建企业web版,产品部,运营部,销售部1122,技术部', ',1', '1', '0', null, null, null, '1', '2', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-05-15 00:46:55', '2024-05-26 09:17:03', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_dept` VALUES ('1145', '63a7c0e0-9238-454c-85d2-17c5b91b2f09', '产品部', '1', '1,63a7c0e0-9238-454c-85d2-17c5b91b2f09', '自建企业web版,产品部', ',1', '2', '0', null, null, null, '1', '0', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '', '2024-05-15 00:47:04', '1970-01-01 00:00:00', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_dept` VALUES ('1146', '07d6164d-0d7f-46e7-b4db-673c4d038b14', '市场部', '1', '1,07d6164d-0d7f-46e7-b4db-673c4d038b14', '自建企业web版,市场部', ',1', '3', '0', null, null, null, '1', '0', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '', '2024-05-15 00:47:15', '1970-01-01 00:00:00', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_dept` VALUES ('1148', '2e3bd226-ed99-4e67-8022-87228b9619a6', '运营部', '63a7c0e0-9238-454c-85d2-17c5b91b2f09', '1,63a7c0e0-9238-454c-85d2-17c5b91b2f09,2e3bd226-ed99-4e67-8022-87228b9619a6', '自建企业web版,产品部,运营部', ',1', '5', '0', null, null, null, '1', '0', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-05-25 23:27:47', '2024-05-26 16:41:19', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_dept` VALUES ('1149', '180b70fc-8def-4771-8ce5-420c93b30029', '销售部1122', '2e3bd226-ed99-4e67-8022-87228b9619a6', '1,63a7c0e0-9238-454c-85d2-17c5b91b2f09,2e3bd226-ed99-4e67-8022-87228b9619a6,180b70fc-8def-4771-8ce5-420c93b30029', '自建企业web版,产品部,运营部,销售部1122', '1,1', '6', '0', null, null, null, '1', '0', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-05-25 23:31:02', '2024-05-26 09:13:11', '5d70aa10-b5af-4092-b968-d374dd133269', '');
-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data` (
`dict_code` bigint NOT NULL AUTO_INCREMENT COMMENT '字典编码',
`dict_sort` int DEFAULT '0' COMMENT '字典排序',
`dict_label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '字典标签',
`dict_value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '字典键值',
`dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '字典类型',
`css_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
`list_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '表格回显样式',
`is_default` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
`status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '状态（0正常 1停用）',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`dict_code`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='字典数据表';
-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
INSERT INTO `sys_dict_data` VALUES ('1', '1', '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2024-05-25 22:42:56', '', null, '性别男');
INSERT INTO `sys_dict_data` VALUES ('2', '2', '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '性别女');
INSERT INTO `sys_dict_data` VALUES ('3', '3', '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '性别未知');
INSERT INTO `sys_dict_data` VALUES ('4', '1', '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2024-05-25 22:42:56', '', null, '显示菜单');
INSERT INTO `sys_dict_data` VALUES ('5', '2', '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '隐藏菜单');
INSERT INTO `sys_dict_data` VALUES ('6', '1', '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2024-05-25 22:42:56', '', null, '正常状态');
INSERT INTO `sys_dict_data` VALUES ('7', '2', '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '停用状态');
INSERT INTO `sys_dict_data` VALUES ('8', '1', '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2024-05-25 22:42:56', '', null, '正常状态');
INSERT INTO `sys_dict_data` VALUES ('9', '2', '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '停用状态');
INSERT INTO `sys_dict_data` VALUES ('10', '1', '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2024-05-25 22:42:56', '', null, '默认分组');
INSERT INTO `sys_dict_data` VALUES ('11', '2', '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '系统分组');
INSERT INTO `sys_dict_data` VALUES ('12', '1', '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2024-05-25 22:42:56', '', null, '系统默认是');
INSERT INTO `sys_dict_data` VALUES ('13', '2', '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '系统默认否');
INSERT INTO `sys_dict_data` VALUES ('14', '1', '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2024-05-25 22:42:56', '', null, '通知');
INSERT INTO `sys_dict_data` VALUES ('15', '2', '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '公告');
INSERT INTO `sys_dict_data` VALUES ('16', '1', '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2024-05-25 22:42:56', '', null, '正常状态');
INSERT INTO `sys_dict_data` VALUES ('17', '2', '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '关闭状态');
INSERT INTO `sys_dict_data` VALUES ('18', '99', '其他', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '其他操作');
INSERT INTO `sys_dict_data` VALUES ('19', '1', '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '新增操作');
INSERT INTO `sys_dict_data` VALUES ('20', '2', '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '修改操作');
INSERT INTO `sys_dict_data` VALUES ('21', '3', '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '删除操作');
INSERT INTO `sys_dict_data` VALUES ('22', '4', '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '授权操作');
INSERT INTO `sys_dict_data` VALUES ('23', '5', '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '导出操作');
INSERT INTO `sys_dict_data` VALUES ('24', '6', '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '导入操作');
INSERT INTO `sys_dict_data` VALUES ('25', '7', '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '强退操作');
INSERT INTO `sys_dict_data` VALUES ('26', '8', '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '生成操作');
INSERT INTO `sys_dict_data` VALUES ('27', '9', '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '清空操作');
INSERT INTO `sys_dict_data` VALUES ('28', '1', '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '正常状态');
INSERT INTO `sys_dict_data` VALUES ('29', '2', '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2024-05-25 22:42:56', '', null, '停用状态');
-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type` (
`dict_id` bigint NOT NULL AUTO_INCREMENT COMMENT '字典主键',
`dict_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '字典名称',
`dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '字典类型',
`status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '状态（0正常 1停用）',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`dict_id`),
UNIQUE KEY `dict_type` (`dict_type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='字典类型表';
-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
INSERT INTO `sys_dict_type` VALUES ('1', '用户性别', 'sys_user_sex', '0', 'admin', '2024-05-25 22:42:55', '', null, '用户性别列表');
INSERT INTO `sys_dict_type` VALUES ('2', '菜单状态', 'sys_show_hide', '0', 'admin', '2024-05-25 22:42:55', '', null, '菜单状态列表');
INSERT INTO `sys_dict_type` VALUES ('3', '系统开关', 'sys_normal_disable', '0', 'admin', '2024-05-25 22:42:55', '', null, '系统开关列表');
INSERT INTO `sys_dict_type` VALUES ('4', '任务状态', 'sys_job_status', '0', 'admin', '2024-05-25 22:42:55', '', null, '任务状态列表');
INSERT INTO `sys_dict_type` VALUES ('5', '任务分组', 'sys_job_group', '0', 'admin', '2024-05-25 22:42:55', '', null, '任务分组列表');
INSERT INTO `sys_dict_type` VALUES ('6', '系统是否', 'sys_yes_no', '0', 'admin', '2024-05-25 22:42:55', '', null, '系统是否列表');
INSERT INTO `sys_dict_type` VALUES ('7', '通知类型', 'sys_notice_type', '0', 'admin', '2024-05-25 22:42:56', '', null, '通知类型列表');
INSERT INTO `sys_dict_type` VALUES ('8', '通知状态', 'sys_notice_status', '0', 'admin', '2024-05-25 22:42:56', '', null, '通知状态列表');
INSERT INTO `sys_dict_type` VALUES ('9', '操作类型', 'sys_oper_type', '0', 'admin', '2024-05-25 22:42:56', '', null, '操作类型列表');
INSERT INTO `sys_dict_type` VALUES ('10', '系统状态', 'sys_common_status', '0', 'admin', '2024-05-25 22:42:56', '', null, '登录状态列表');
-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job` (
`job_id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务ID',
`job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务名称',
`job_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名',
`invoke_target` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调用目标字符串',
`cron_expression` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'cron执行表达式',
`misfire_policy` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）',
`concurrent` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）',
`status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '状态（0正常 1暂停）',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '备注信息',
PRIMARY KEY (`job_id`,`job_name`,`job_group`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='定时任务调度表';
-- ----------------------------
-- Records of sys_job
-- ----------------------------
-- ----------------------------
-- Table structure for sys_job_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_job_log`;
CREATE TABLE `sys_job_log` (
`job_log_id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务日志ID',
`job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务名称',
`job_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务组名',
`invoke_target` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调用目标字符串',
`job_message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '日志信息',
`status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '执行状态（0正常 1失败）',
`exception_info` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '异常信息',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`job_log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=204781 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='定时任务调度日志表';
-- ----------------------------
-- Records of sys_job_log
-- ----------------------------
-- ----------------------------
-- Table structure for sys_logininfor
-- ----------------------------
DROP TABLE IF EXISTS `sys_logininfor`;
CREATE TABLE `sys_logininfor` (
`info_id` bigint NOT NULL AUTO_INCREMENT COMMENT '访问ID',
`user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '人员id',
`user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '用户账号',
`ipaddr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '登录IP地址',
`login_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '登录地点',
`browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '浏览器类型',
`os` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '操作系统',
`status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
`msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '提示消息',
`login_time` date DEFAULT '1970-01-01' COMMENT '访问时间',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '公司id',
PRIMARY KEY (`info_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统访问记录';
-- ----------------------------
-- Records of sys_logininfor
-- ----------------------------
INSERT INTO `sys_logininfor` VALUES ('1', 'admin', 'web', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2024-06-04', 'corpId');
INSERT INTO `sys_logininfor` VALUES ('2', 'admin', 'web', '144.52.176.61', 'XX XX', 'Chrome 11', 'Windows 10', '0', '登录成功', '2024-06-04', 'corpId');
INSERT INTO `sys_logininfor` VALUES ('3', 'admin', 'web', '144.52.176.61', 'XX XX', 'Chrome 11', 'Windows 10', '0', '登录成功', '2024-06-04', 'corpId');
INSERT INTO `sys_logininfor` VALUES ('4', 'admin', 'web', '144.52.176.61', 'XX XX', 'Chrome 11', 'Windows 10', '0', '登录成功', '2024-06-04', 'corpId');
INSERT INTO `sys_logininfor` VALUES ('5', 'admin', 'web', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2024-06-05', 'corpId');
-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
`id` bigint NOT NULL AUTO_INCREMENT,
`menu_id` varchar(36) NOT NULL DEFAULT '' COMMENT '菜单ID',
`menu_name` varchar(50) NOT NULL DEFAULT '' COMMENT '菜单名称',
`parent_id` varchar(36) DEFAULT '0' COMMENT '父菜单ID',
`order_num` int DEFAULT '0' COMMENT '显示顺序',
`path` varchar(200) DEFAULT '' COMMENT '路由地址',
`component` varchar(255) DEFAULT '' COMMENT '组件路径',
`query` varchar(255) DEFAULT '' COMMENT '路由参数',
`is_frame` int DEFAULT '1' COMMENT '是否为外链（0是 1否）',
`is_cache` int DEFAULT '0' COMMENT '是否缓存（0缓存 1不缓存）',
`is_super` tinyint(1) DEFAULT '0' COMMENT '1超级管理菜单',
`menu_type` char(1) DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
`visible` char(1) DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
`status` tinyint(1) DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
`perms` varchar(100) DEFAULT NULL COMMENT '权限标识',
`icon` varchar(100) DEFAULT '#' COMMENT '菜单图标',
`create_by` varchar(64) DEFAULT '' COMMENT '创建者',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) DEFAULT '' COMMENT '更新者',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`remark` varchar(500) DEFAULT '' COMMENT '备注',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=230 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='菜单权限表';
-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES ('2', '1', '企业设置', '0', '7', 'system', null, '', '1', '0', '0', 'M', '0', '0', '', 'system', 'admin', '2021-11-14 14:56:14', '$userName=032459622024032452$', '2024-03-09 00:57:13', '系统管理目录');
INSERT INTO `sys_menu` VALUES ('13', '101', '角色管理', '7e6eee32-e800-4c1a-86aa-b135266cc4df', '4', 'role', 'system/role/index', '', '1', '0', '0', 'C', '0', '0', 'system:role:list', '', 'admin', '2021-11-14 14:56:14', '$userName=03245962201172172$', '2024-05-09 15:23:25', '角色管理菜单');
INSERT INTO `sys_menu` VALUES ('24', '102', '菜单管理', '1', '3', 'menu', 'system/menu/index', '', '1', '0', '1', 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', '2021-11-14 14:56:14', '', null, '菜单管理菜单');
INSERT INTO `sys_menu` VALUES ('175', 'b947272f-ae4a-47d6-bbbd-d0eea5924275', '知识中心', '0', '1', 'course', '', '', '1', '0', '0', 'M', '0', '0', '', 'excel', '$userName=wo9rEvEAAA08S-QDZI5fyL60LBbf8JuQ$', '2023-12-20 08:30:40', '$userName=0224293720401213546$', '2024-03-26 09:11:36', '');
INSERT INTO `sys_menu` VALUES ('176', 'e25477ed-fc39-47dd-a79f-70f7c5f3d756', '资源分类', 'b947272f-ae4a-47d6-bbbd-d0eea5924275', '1', 'category', 'course/category/index', '', '1', '0', '0', 'C', '0', '0', '', 'category', '$userName=wo9rEvEAAA08S-QDZI5fyL60LBbf8JuQ$', '2023-12-20 08:33:06', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-05-15 13:19:41', '');
INSERT INTO `sys_menu` VALUES ('177', 'c2bfafd5-a60c-4843-86d9-134da5e4d15e', '课程管理', 'b947272f-ae4a-47d6-bbbd-d0eea5924275', '3', 'courseList', 'course/course/index', '', '1', '0', '0', 'C', '0', '0', '', 'course', '$userName=wo9rEvEAAA08S-QDZI5fyL60LBbf8JuQ$', '2023-12-20 08:38:00', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-05-15 13:20:16', '');
INSERT INTO `sys_menu` VALUES ('178', '9b98a323-a855-46e3-94de-0c9dfbce46d2', '课件管理', 'b947272f-ae4a-47d6-bbbd-d0eea5924275', '2', 'lessonList', 'course/lesson/index', '', '1', '0', '0', 'C', '0', '0', '', 'lesson', '$userName=wo9rEvEAAA08S-QDZI5fyL60LBbf8JuQ$', '2023-12-20 08:39:47', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-05-15 13:20:01', '');
INSERT INTO `sys_menu` VALUES ('194', '7e6eee32-e800-4c1a-86aa-b135266cc4df', '组织架构', '1', '1', 'orgSetting', '', '', '1', '0', '0', 'M', '0', '0', null, 'tree', '$userName=032459622024032452$', '2024-03-09 00:52:12', '', null, '');
INSERT INTO `sys_menu` VALUES ('212', '753219a0-30a6-4059-b28d-88bfabe2cbfc', '用户管理', '7e6eee32-e800-4c1a-86aa-b135266cc4df', '2', 'user', 'system/user/index', '', '1', '0', '0', 'C', '0', '0', '', '', '$userName=03245962201172172$', '2024-05-09 15:21:46', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-05-14 23:11:12', '');
INSERT INTO `sys_menu` VALUES ('213', '0d3593f0-a691-4e13-875d-cf58098a9bf0', '部门管理', '7e6eee32-e800-4c1a-86aa-b135266cc4df', '1', 'dept', 'system/dept/index', '', '1', '0', '0', 'C', '0', '0', '', '', '$userName=03245962201172172$', '2024-05-09 15:22:19', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-05-14 23:11:08', '');
INSERT INTO `sys_menu` VALUES ('223', '51ddf0ff-fe9b-40da-9a53-29d5e86c7057', '文章管理', '1', '3', 'article', '', '', '1', '0', '0', 'M', '1', '1', '', 'archives', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-06-05 13:29:00', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-06-05 18:11:56', '');
INSERT INTO `sys_menu` VALUES ('224', '669244fa-8718-4e8f-846e-489dfcec0d60', '分类管理', '51ddf0ff-fe9b-40da-9a53-29d5e86c7057', '1', 'category', 'system/article/category/index', '', '1', '0', '0', 'C', '0', '0', '', '#', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-06-05 13:29:31', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-06-05 13:33:14', '');
INSERT INTO `sys_menu` VALUES ('225', '09c6fe98-ab91-4ea3-96c7-d51249a90b42', '文章管理', '51ddf0ff-fe9b-40da-9a53-29d5e86c7057', '2', 'article', 'system/article/article/index', '', '1', '0', '0', 'C', '0', '0', '', '#', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-06-05 13:30:02', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-06-05 13:33:21', '');
INSERT INTO `sys_menu` VALUES ('226', '17f99d7e-a07f-4355-8119-68e4125416ef', '师资管理', '0', '2', 'teachers', '', '', '1', '0', '0', 'M', '0', '0', null, '#', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-06-05 18:18:11', '', null, '');
INSERT INTO `sys_menu` VALUES ('227', 'b2578d94-d832-4779-8f8a-5a7641a72d16', '讲师管理', '17f99d7e-a07f-4355-8119-68e4125416ef', '1', 'lector', '', '', '1', '0', '0', 'M', '0', '0', null, 'lector', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-06-05 18:19:11', '', null, '');
INSERT INTO `sys_menu` VALUES ('228', 'c2c8ed51-a086-4a35-bf3f-41e598954552', '讲师列表', 'b2578d94-d832-4779-8f8a-5a7641a72d16', '1', 'lectorList', 'teachers/lector/lectorList', '', '1', '0', '0', 'C', '0', '0', null, '#', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-06-05 18:20:08', '', null, '');
INSERT INTO `sys_menu` VALUES ('229', 'b6003232-0ecf-48c0-962a-7313b372c199', '讲师等级', 'b2578d94-d832-4779-8f8a-5a7641a72d16', '2', 'lectorGrade', 'teachers/lector/gradeList', '', '1', '0', '0', 'C', '0', '0', null, '#', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-06-05 18:20:39', '', null, '');
-- ----------------------------
-- Table structure for sys_notice
-- ----------------------------
DROP TABLE IF EXISTS `sys_notice`;
CREATE TABLE `sys_notice` (
`notice_id` int NOT NULL AUTO_INCREMENT COMMENT '公告ID',
`notice_title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告标题',
`notice_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告类型（1通知 2公告）',
`notice_content` longblob COMMENT '公告内容',
`status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`notice_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='通知公告表';
-- ----------------------------
-- Records of sys_notice
-- ----------------------------
INSERT INTO `sys_notice` VALUES ('1', '温馨提醒：2018-07-01 若依新版本发布啦', '2', 0xE696B0E78988E69CACE58685E5AEB9, '0', 'admin', '2021-11-14 14:56:33', '', null, '管理员');
INSERT INTO `sys_notice` VALUES ('2', '维护通知：2018-07-01 若依系统凌晨维护', '1', 0xE7BBB4E68AA4E58685E5AEB9, '0', 'admin', '2021-11-14 14:56:33', '', null, '管理员');
-- ----------------------------
-- Table structure for sys_oper_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_oper_log`;
CREATE TABLE `sys_oper_log` (
`oper_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日志主键',
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '模块标题',
`business_type` int DEFAULT '0' COMMENT '业务类型（0其它 1新增 2修改 3删除）',
`method` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '方法名称',
`request_method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '请求方式',
`operator_type` int DEFAULT '0' COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
`oper_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '操作人员',
`dept_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '部门名称',
`oper_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '请求URL',
`oper_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '主机地址',
`oper_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '操作地点',
`oper_param` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '请求参数',
`json_result` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '返回参数',
`status` int DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
`error_msg` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '错误消息',
`oper_time` datetime DEFAULT NULL COMMENT '操作时间',
PRIMARY KEY (`oper_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='操作日志记录';
-- ----------------------------
-- Records of sys_oper_log
-- ----------------------------
INSERT INTO `sys_oper_log` VALUES ('17459d3b-2a9e-4a30-97b7-34a4afe108c7', '课程发布', '2', 'com.edu.web.controller.knowledge.KnowledgeController.publish()', 'GET', '1', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', null, '/knowledge/knowledge/publish/82b4c1ff-369d-4449-a69d-a8f4fa129a09', '144.52.176.61', 'XX XX', '{uuid=82b4c1ff-369d-4449-a69d-a8f4fa129a09}', '{\"msg\":\"操作成功\",\"temp\":\"j\",\"code\":200}', '0', null, '2024-06-04 14:14:44');
INSERT INTO `sys_oper_log` VALUES ('21d344e8-956a-4549-a9cf-2baf97f1dea4', '素材库', '1', 'com.edu.web.controller.knowledge.MaterialLibraryController.add()', 'POST', '1', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', null, '/learn/lesson', '144.52.176.61', 'XX XX', '{\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"createTime\":\"2024-06-04 14:10:44\",\"fileType\":\"mp4\",\"jobId\":\"38707b9994bd41f3a02f238674b9b65e\",\"length\":476,\"name\":\"薪酬管理目标原则.mp4\",\"object\":\"5d70aa10-b5af-4092-b968-d374dd133269/lesson/video/FFQwDT62kK1717481430743.mp4\",\"relevancy\":\"yes\",\"size\":40923176,\"title\":\"薪酬管理目标原则\",\"transCodeStatus\":1,\"type\":\"video\",\"updateTime\":\"2024-06-04 14:10:44\",\"useRange\":\"default\",\"uuid\":\"dbd03bb4-ee5f-4f76-9d21-5257afe3f722\"}', '{\"msg\":\"操作成功\",\"temp\":\"j\",\"code\":200,\"data\":{\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"createTime\":\"2024-06-04 14:10:44\",\"isDelete\":0,\"jobId\":\"38707b9994bd41f3a02f238674b9b65e\",\"lectorId\":\"\",\"length\":476,\"name\":\"薪酬管理目标原则.mp4\",\"object\":\"5d70aa10-b5af-4092-b968-d374dd133269/lesson/video/FFQwDT62kK1717481430743.mp4\",\"relevancy\":\"yes\",\"size\":40923176,\"status\":0,\"title\":\"薪酬管理目标原则\",\"transCodeStatus\":1,\"type\":\"video\",\"updateTime\":\"2024-06-04 14:10:44\",\"useRange\":\"default\",\"uuid\":\"dbd03bb4-ee5f-4f76-9d21-5257afe3f722\"}}', '0', null, '2024-06-04 14:10:45');
INSERT INTO `sys_oper_log` VALUES ('22e0e1a4-ae6b-4ca1-87ab-17b3cfbae4b3', '课程发布', '2', 'com.edu.web.controller.knowledge.KnowledgeController.publish()', 'GET', '1', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', null, '/knowledge/knowledge/publish/83069043-118a-4c30-a376-0f60a47d2ca5', '144.52.176.61', 'XX XX', '{uuid=83069043-118a-4c30-a376-0f60a47d2ca5}', '{\"msg\":\"操作成功\",\"temp\":\"j\",\"code\":200}', '0', null, '2024-06-04 14:15:18');
INSERT INTO `sys_oper_log` VALUES ('29dd3a40-4cff-4c51-b5f7-51f12b0a2a32', '课程主表', '1', 'com.edu.web.controller.knowledge.KnowledgeController.add()', 'POST', '1', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', null, '/knowledge/knowledge', '144.52.176.61', 'XX XX', '{\"action\":\"update\",\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"createTime\":\"2024-06-04 14:15:07\",\"credit\":0,\"drag\":\"close\",\"eligible\":\"all\",\"learnMode\":\"1\",\"learnProgress\":0,\"picture\":\"5d70aa10-b5af-4092-b968-d374dd133269/course/image/H6G2256CXh1715763131325.png\",\"relevancy\":\"yes\",\"speed\":\"close\",\"syncLearn\":\"close\",\"title\":\"薪酬管理制度\",\"uuid\":\"83069043-118a-4c30-a376-0f60a47d2ca5\"}', '{\"msg\":\"操作成功\",\"temp\":\"j\",\"code\":200,\"data\":{\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"cdnPicture\":\"https://yuechenlearntrain.oss-cn-hangzhou.aliyuncs.com/5d70aa10-b5af-4092-b968-d374dd133269/course/image/H6G2256CXh1715763131325.png\",\"certificate\":\"\",\"coursewareNum\":0,\"createTime\":\"2024-06-04 14:15:07\",\"credit\":0,\"drag\":\"close\",\"duration\":0,\"eligible\":\"all\",\"learnMode\":\"1\",\"learnProgress\":0,\"lectorId\":\"\",\"model\":\"1\",\"picture\":\"5d70aa10-b5af-4092-b968-d374dd133269/course/image/H6G2256CXh1715763131325.png\",\"relevancy\":\"yes\",\"speed\":\"close\",\"status\":0,\"syncLearn\":\"close\",\"title\":\"薪酬管理制度\",\"updateTime\":\"1970-01-01 00:00:00\",\"uuid\":\"83069043-118a-4c30-a376-0f60a47d2ca5\"}}', '0', null, '2024-06-04 14:15:07');
INSERT INTO `sys_oper_log` VALUES ('2c4a1825-634e-4990-a5da-c11d03a86234', '素材库', '1', 'com.edu.web.controller.knowledge.MaterialLibraryController.add()', 'POST', '1', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', null, '/learn/lesson', '144.52.176.61', 'XX XX', '{\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"createTime\":\"2024-06-04 13:43:37\",\"fileType\":\"mp4\",\"jobId\":\"91ff40aa647d4b9884ad37a9ea5b35ac\",\"length\":158,\"name\":\"企业培训人才发展.mp4\",\"object\":\"5d70aa10-b5af-4092-b968-d374dd133269/lesson/video/AEsTZXXfDZ1717479651912.mp4\",\"relevancy\":\"yes\",\"size\":239998369,\"title\":\"企业培训人才发展\",\"transCodeStatus\":1,\"type\":\"video\",\"updateTime\":\"2024-06-04 13:43:37\",\"useRange\":\"default\",\"uuid\":\"eab5ff63-2d18-4865-9e4e-bdddc680e6d5\"}', '{\"msg\":\"操作成功\",\"temp\":\"j\",\"code\":200,\"data\":{\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"createTime\":\"2024-06-04 13:43:37\",\"isDelete\":0,\"jobId\":\"91ff40aa647d4b9884ad37a9ea5b35ac\",\"lectorId\":\"\",\"length\":158,\"name\":\"企业培训人才发展.mp4\",\"object\":\"5d70aa10-b5af-4092-b968-d374dd133269/lesson/video/AEsTZXXfDZ1717479651912.mp4\",\"relevancy\":\"yes\",\"size\":239998369,\"status\":0,\"title\":\"企业培训人才发展\",\"transCodeStatus\":1,\"type\":\"video\",\"updateTime\":\"2024-06-04 13:43:37\",\"useRange\":\"default\",\"uuid\":\"eab5ff63-2d18-4865-9e4e-bdddc680e6d5\"}}', '0', null, '2024-06-04 13:43:38');
INSERT INTO `sys_oper_log` VALUES ('4c879218-3be3-40d2-8112-ce95bc1292cb', '素材库', '1', 'com.edu.web.controller.knowledge.MaterialLibraryController.add()', 'POST', '1', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', null, '/learn/lesson', '144.52.176.61', 'XX XX', '{\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"createTime\":\"2024-06-04 14:13:50\",\"fileType\":\"pptx\",\"length\":300,\"name\":\"辅学院数字化学习解决方案(3).pptx\",\"object\":\"5d70aa10-b5af-4092-b968-d374dd133269/lesson/document/k7mH54Ztew1717481627650.pptx\",\"relevancy\":\"yes\",\"size\":2883732,\"title\":\"辅学院数字化学习解决方案(3)\",\"transCodeStatus\":1,\"type\":\"document\",\"updateTime\":\"2024-06-04 14:13:50\",\"useRange\":\"default\",\"uuid\":\"08ba4c67-eed5-4635-b074-5232653b9fcd\"}', '{\"msg\":\"操作成功\",\"temp\":\"j\",\"code\":200,\"data\":{\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"createTime\":\"2024-06-04 14:13:50\",\"isDelete\":0,\"jobId\":\"\",\"lectorId\":\"\",\"length\":300,\"name\":\"辅学院数字化学习解决方案(3).pptx\",\"object\":\"5d70aa10-b5af-4092-b968-d374dd133269/lesson/document/k7mH54Ztew1717481627650.pptx\",\"relevancy\":\"yes\",\"size\":2883732,\"status\":0,\"title\":\"辅学院数字化学习解决方案(3)\",\"transCodeStatus\":1,\"type\":\"document\",\"updateTime\":\"2024-06-04 14:13:50\",\"useRange\":\"default\",\"uuid\":\"08ba4c67-eed5-4635-b074-5232653b9fcd\"}}', '0', null, '2024-06-04 14:13:50');
INSERT INTO `sys_oper_log` VALUES ('58096349-e8d0-4d2a-8a38-3cde48d5210a', '课程主表', '1', 'com.edu.web.controller.knowledge.KnowledgeController.add()', 'POST', '1', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', null, '/knowledge/knowledge', '144.52.176.61', 'XX XX', '{\"action\":\"update\",\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"createTime\":\"2024-06-04 14:14:18\",\"credit\":0,\"drag\":\"close\",\"eligible\":\"all\",\"learnMode\":\"1\",\"learnProgress\":0,\"picture\":\"5d70aa10-b5af-4092-b968-d374dd133269/course/image/cMEjDePdPK1715765841124.png\",\"relevancy\":\"yes\",\"speed\":\"close\",\"syncLearn\":\"close\",\"title\":\"开源培训系统介绍\",\"uuid\":\"82b4c1ff-369d-4449-a69d-a8f4fa129a09\"}', '{\"msg\":\"操作成功\",\"temp\":\"j\",\"code\":200,\"data\":{\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"cdnPicture\":\"https://yuechenlearntrain.oss-cn-hangzhou.aliyuncs.com/5d70aa10-b5af-4092-b968-d374dd133269/course/image/cMEjDePdPK1715765841124.png\",\"certificate\":\"\",\"coursewareNum\":0,\"createTime\":\"2024-06-04 14:14:18\",\"credit\":0,\"drag\":\"close\",\"duration\":0,\"eligible\":\"all\",\"learnMode\":\"1\",\"learnProgress\":0,\"lectorId\":\"\",\"model\":\"1\",\"picture\":\"5d70aa10-b5af-4092-b968-d374dd133269/course/image/cMEjDePdPK1715765841124.png\",\"relevancy\":\"yes\",\"speed\":\"close\",\"status\":0,\"syncLearn\":\"close\",\"title\":\"开源培训系统介绍\",\"updateTime\":\"1970-01-01 00:00:00\",\"uuid\":\"82b4c1ff-369d-4449-a69d-a8f4fa129a09\"}}', '0', null, '2024-06-04 14:14:18');
INSERT INTO `sys_oper_log` VALUES ('9455a216-21d9-48f0-b0e3-eaa1ab6f55ee', '素材库', '1', 'com.edu.web.controller.knowledge.MaterialLibraryController.add()', 'POST', '1', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', null, '/learn/lesson', '144.52.176.61', 'XX XX', '{\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"createTime\":\"2024-06-04 14:12:59\",\"fileType\":\"pptx\",\"length\":300,\"name\":\"云上CT数字化学习方案.pptx\",\"object\":\"5d70aa10-b5af-4092-b968-d374dd133269/lesson/document/JKYX3jxRnM1717481566823.pptx\",\"relevancy\":\"yes\",\"size\":29639864,\"title\":\"云上CT数字化学习方案\",\"transCodeStatus\":1,\"type\":\"document\",\"updateTime\":\"2024-06-04 14:12:59\",\"useRange\":\"default\",\"uuid\":\"5cc69ff9-07a3-41b1-946a-eb81f782e78c\"}', '{\"msg\":\"操作成功\",\"temp\":\"j\",\"code\":200,\"data\":{\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"createTime\":\"2024-06-04 14:12:59\",\"isDelete\":0,\"jobId\":\"\",\"lectorId\":\"\",\"length\":300,\"name\":\"云上CT数字化学习方案.pptx\",\"object\":\"5d70aa10-b5af-4092-b968-d374dd133269/lesson/document/JKYX3jxRnM1717481566823.pptx\",\"relevancy\":\"yes\",\"size\":29639864,\"status\":0,\"title\":\"云上CT数字化学习方案\",\"transCodeStatus\":1,\"type\":\"document\",\"updateTime\":\"2024-06-04 14:12:59\",\"useRange\":\"default\",\"uuid\":\"5cc69ff9-07a3-41b1-946a-eb81f782e78c\"}}', '0', null, '2024-06-04 14:12:59');
INSERT INTO `sys_oper_log` VALUES ('d448f71b-dabe-47e8-82ae-65103ddbc3bc', '素材库', '1', 'com.edu.web.controller.knowledge.MaterialLibraryController.add()', 'POST', '1', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', null, '/learn/lesson', '144.52.176.61', 'XX XX', '{\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"createTime\":\"2024-06-04 13:40:37\",\"fileType\":\"mp4\",\"jobId\":\"1032c56d81b447aba8b62c45a243c4fe\",\"length\":71,\"name\":\"辅学院开源版.mp4\",\"object\":\"5d70aa10-b5af-4092-b968-d374dd133269/lesson/video/b7PkCnJKnM1717479632551.mp4\",\"relevancy\":\"yes\",\"size\":12341315,\"title\":\"辅学院开源版\",\"transCodeStatus\":1,\"type\":\"video\",\"updateTime\":\"2024-06-04 13:40:37\",\"useRange\":\"default\",\"uuid\":\"d911cf58-fa43-4b4e-8740-6b6ece29d991\"}', '{\"msg\":\"操作成功\",\"temp\":\"j\",\"code\":200,\"data\":{\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"createTime\":\"2024-06-04 13:40:37\",\"isDelete\":0,\"jobId\":\"1032c56d81b447aba8b62c45a243c4fe\",\"lectorId\":\"\",\"length\":71,\"name\":\"辅学院开源版.mp4\",\"object\":\"5d70aa10-b5af-4092-b968-d374dd133269/lesson/video/b7PkCnJKnM1717479632551.mp4\",\"relevancy\":\"yes\",\"size\":12341315,\"status\":0,\"title\":\"辅学院开源版\",\"transCodeStatus\":1,\"type\":\"video\",\"updateTime\":\"2024-06-04 13:40:37\",\"useRange\":\"default\",\"uuid\":\"d911cf58-fa43-4b4e-8740-6b6ece29d991\"}}', '0', null, '2024-06-04 13:40:39');
INSERT INTO `sys_oper_log` VALUES ('d5eeb4df-1a66-4903-91a8-c1dc60cd1c11', '素材库', '1', 'com.edu.web.controller.knowledge.MaterialLibraryController.add()', 'POST', '1', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', null, '/learn/lesson', '144.52.176.61', 'XX XX', '{\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"createTime\":\"2024-06-04 14:12:22\",\"fileType\":\"mp4\",\"jobId\":\"b079a3b9d88a461eabb00be224a67a70\",\"length\":456,\"name\":\"薪酬的定义和功能.mp4\",\"object\":\"5d70aa10-b5af-4092-b968-d374dd133269/lesson/video/QfKCPynHEX1717481517320.mp4\",\"relevancy\":\"yes\",\"size\":57686213,\"title\":\"薪酬的定义和功能\",\"transCodeStatus\":1,\"type\":\"video\",\"updateTime\":\"2024-06-04 14:12:22\",\"useRange\":\"default\",\"uuid\":\"c7867fe8-9f6e-4672-abb5-1d02efba7c5c\"}', '{\"msg\":\"操作成功\",\"temp\":\"j\",\"code\":200,\"data\":{\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"createTime\":\"2024-06-04 14:12:22\",\"isDelete\":0,\"jobId\":\"b079a3b9d88a461eabb00be224a67a70\",\"lectorId\":\"\",\"length\":456,\"name\":\"薪酬的定义和功能.mp4\",\"object\":\"5d70aa10-b5af-4092-b968-d374dd133269/lesson/video/QfKCPynHEX1717481517320.mp4\",\"relevancy\":\"yes\",\"size\":57686213,\"status\":0,\"title\":\"薪酬的定义和功能\",\"transCodeStatus\":1,\"type\":\"video\",\"updateTime\":\"2024-06-04 14:12:22\",\"useRange\":\"default\",\"uuid\":\"c7867fe8-9f6e-4672-abb5-1d02efba7c5c\"}}', '0', null, '2024-06-04 14:12:23');
INSERT INTO `sys_oper_log` VALUES ('e89e40c0-969f-49f4-b793-17187ce7c69f', '课程主表', '1', 'com.edu.web.controller.knowledge.KnowledgeController.add()', 'POST', '1', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', null, '/knowledge/knowledge', '144.52.176.61', 'XX XX', '{\"action\":\"update\",\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"createTime\":\"2024-06-04 14:16:37\",\"credit\":0,\"drag\":\"close\",\"eligible\":\"all\",\"learnMode\":\"1\",\"learnProgress\":0,\"picture\":\"5d70aa10-b5af-4092-b968-d374dd133269/course/image/wAEepSJaB51715765849083.png\",\"relevancy\":\"yes\",\"speed\":\"close\",\"syncLearn\":\"close\",\"title\":\"多种课件学习\",\"uuid\":\"2f8be339-c8ec-48bd-8a16-3f89efe4cd2c\"}', '{\"msg\":\"操作成功\",\"temp\":\"j\",\"code\":200,\"data\":{\"categoryId\":\"ccb1f245-9104-4ae2-8c22-87fb3b318212\",\"categoryTitle\":\"专业技能\",\"cdnPicture\":\"https://yuechenlearntrain.oss-cn-hangzhou.aliyuncs.com/5d70aa10-b5af-4092-b968-d374dd133269/course/image/wAEepSJaB51715765849083.png\",\"certificate\":\"\",\"coursewareNum\":0,\"createTime\":\"2024-06-04 14:16:37\",\"credit\":0,\"drag\":\"close\",\"duration\":0,\"eligible\":\"all\",\"learnMode\":\"1\",\"learnProgress\":0,\"lectorId\":\"\",\"model\":\"1\",\"picture\":\"5d70aa10-b5af-4092-b968-d374dd133269/course/image/wAEepSJaB51715765849083.png\",\"relevancy\":\"yes\",\"speed\":\"close\",\"status\":0,\"syncLearn\":\"close\",\"title\":\"多种课件学习\",\"updateTime\":\"1970-01-01 00:00:00\",\"uuid\":\"2f8be339-c8ec-48bd-8a16-3f89efe4cd2c\"}}', '0', null, '2024-06-04 14:16:37');
INSERT INTO `sys_oper_log` VALUES ('f8928adc-b9da-4dde-9bfe-84c67738ef20', '课程发布', '2', 'com.edu.web.controller.knowledge.KnowledgeController.publish()', 'GET', '1', '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', null, '/knowledge/knowledge/publish/2f8be339-c8ec-48bd-8a16-3f89efe4cd2c', '144.52.176.61', 'XX XX', '{uuid=2f8be339-c8ec-48bd-8a16-3f89efe4cd2c}', '{\"msg\":\"操作成功\",\"temp\":\"j\",\"code\":200}', '0', null, '2024-06-04 14:16:54');
-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_post`;
CREATE TABLE `sys_post` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
`post_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '岗位编码',
`post_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '岗位名称',
`group_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '岗位组',
`post_sort` int NOT NULL DEFAULT '50' COMMENT '显示顺序',
`duty` varchar(1500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '岗位职责',
`demand` varchar(1500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '岗位要求',
`amount` int DEFAULT '0' COMMENT '人数',
`is_delete` tinyint(1) DEFAULT '0' COMMENT '状态（0正常 1删除）',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`create_user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
`update_user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='岗位信息表';
-- ----------------------------
-- Records of sys_post
-- ----------------------------
-- ----------------------------
-- Table structure for sys_post_group
-- ----------------------------
DROP TABLE IF EXISTS `sys_post_group`;
CREATE TABLE `sys_post_group` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '递增ID',
`uuid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一ID',
`title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类标题',
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
`create_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '更新时间',
`create_user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者用户ID',
`update_user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '更新者用户ID',
`company_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司ID',
`company_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_uuid_comany_id` (`company_id`,`uuid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- ----------------------------
-- Records of sys_post_group
-- ----------------------------
-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`role_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色ID',
`role_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色名称',
`role_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色权限字符串',
`role_sort` int DEFAULT '0' COMMENT '显示顺序',
`data_scope` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
`menu_check_strictly` tinyint(1) DEFAULT '1' COMMENT '菜单树选择项是否关联显示',
`dept_check_strictly` tinyint(1) DEFAULT '1' COMMENT '部门树选择项是否关联显示',
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '角色状态（0正常 1停用）',
`is_delete` tinyint(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
`company_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司id',
`company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=171 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色信息表';
-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES ('168', '0cd789a0-1187-4c62-901d-a2801794e27a', '主管理员', 'admin', '1', '1', '1', '1', '0', '0', '', '2024-05-10 09:26:09', '', '2024-05-10 09:26:09', null, '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_role` VALUES ('169', '19656797-182a-40dd-a22f-df2e8cad2e72', '部门负责人', 'dept', '1', '1', '1', '1', '0', '0', '', '2024-05-10 09:26:09', '', '2024-05-27 08:37:10', null, '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_role` VALUES ('170', 'fd62f233-f7c2-4d76-bb20-0866b3f0eeb3', '部门组长', 'group', '1', '1', '1', '1', '0', '0', '', '2024-05-10 09:26:09', '', '2024-05-27 08:37:15', null, '5d70aa10-b5af-4092-b968-d374dd133269', '');
-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`role_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色ID',
`dept_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门ID',
`company_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司id',
`company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色和部门关联表';
-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`role_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色ID',
`menu_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单ID',
`company_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司id',
`company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=324 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色和菜单关联表';
-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES ('314', '19656797-182a-40dd-a22f-df2e8cad2e72', 'b947272f-ae4a-47d6-bbbd-d0eea5924275', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_role_menu` VALUES ('315', '19656797-182a-40dd-a22f-df2e8cad2e72', 'e25477ed-fc39-47dd-a79f-70f7c5f3d756', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_role_menu` VALUES ('316', '19656797-182a-40dd-a22f-df2e8cad2e72', '9b98a323-a855-46e3-94de-0c9dfbce46d2', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_role_menu` VALUES ('317', '19656797-182a-40dd-a22f-df2e8cad2e72', 'c2bfafd5-a60c-4843-86d9-134da5e4d15e', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_role_menu` VALUES ('318', 'fd62f233-f7c2-4d76-bb20-0866b3f0eeb3', '1', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_role_menu` VALUES ('319', 'fd62f233-f7c2-4d76-bb20-0866b3f0eeb3', '7e6eee32-e800-4c1a-86aa-b135266cc4df', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_role_menu` VALUES ('320', 'fd62f233-f7c2-4d76-bb20-0866b3f0eeb3', '0d3593f0-a691-4e13-875d-cf58098a9bf0', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_role_menu` VALUES ('321', 'fd62f233-f7c2-4d76-bb20-0866b3f0eeb3', '753219a0-30a6-4059-b28d-88bfabe2cbfc', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_role_menu` VALUES ('322', 'fd62f233-f7c2-4d76-bb20-0866b3f0eeb3', '101', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_role_menu` VALUES ('323', 'fd62f233-f7c2-4d76-bb20-0866b3f0eeb3', '102', '5d70aa10-b5af-4092-b968-d374dd133269', '');
-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
`union_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '企业账号范围内的唯一标识',
`dept_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门ID',
`user_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户账号',
`nick_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户昵称',
`dept_ids` varchar(2500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '所属部门id',
`dept_names` varchar(2500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '所属部门名称',
`user_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '00' COMMENT '用户类型（00系统用户）',
`email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '用户邮箱',
`phonenumber` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '手机号码',
`position` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '职位',
`job_number` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '工号',
`sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
`is_master` tinyint(1) DEFAULT '0' COMMENT '是否是主管理员0不是1是',
`is_leave` tinyint(1) DEFAULT '0' COMMENT '1离职',
`is_new` tinyint(1) DEFAULT '0' COMMENT '1是新员工',
`new_time` datetime DEFAULT '1970-01-01 00:00:00' COMMENT '新员工有效期',
`avatar` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '头像地址',
`password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '密码',
`status` tinyint(1) DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
`is_delete` tinyint(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
`login_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '最后登录IP',
`login_date` datetime DEFAULT NULL COMMENT '最后登录时间',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
`create_time` datetime DEFAULT '1970-01-01 00:00:00' COMMENT '创建时间',
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
`update_time` datetime DEFAULT '1970-01-01 00:00:00' COMMENT '更新时间',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
`company_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司id',
`company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '公司名称',
PRIMARY KEY (`id`),
UNIQUE KEY `companyuser` (`company_id`,`user_id`,`dept_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=703 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户信息表';
-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('694', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '', '63a7c0e0-9238-454c-85d2-17c5b91b2f09', 'admin', '张三', '1,07d6164d-0d7f-46e7-b4db-673c4d038b14', '自建企业web版,市场部', '00', '', '', null, null, '0', '0', '0', '0', '1970-01-01 00:00:00', 'https://static-legacy.dingtalk.com/media/lQDPD4AHiuoBNVHNAbDNAbCwL1Jv_5sJwkIF3dZl41ZcAA_432_432.jpg', '$2a$10$hpuc8X1MAiCFVKyxnFZHr..lFbGF2q4alghPtTtGEoBMyy0cavK.C', '1', '0', '', null, '', '2024-05-11 16:01:02', '', '2024-05-26 17:01:59', null, '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_user` VALUES ('699', 'e5c35111-4adf-4c7c-8338-748c52312779', '', '180b70fc-8def-4771-8ce5-420c93b30029', 'hahah', '测试新部门', '', '', '00', '', '', '', '', '0', '0', '0', '0', '1970-01-01 00:00:00', '', '$2a$10$CHCWqqFCfkOzzasW3xzCGu5xvvfOj5GXmcjTxJt9zlgWtxhU6i3tW', '0', '0', '', null, '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-05-27 08:36:24', '', '1970-01-01 00:00:00', null, '', '');
INSERT INTO `sys_user` VALUES ('700', 'c83c5796-2cab-44e1-8822-d0a15cc74e3a', '', '180b70fc-8def-4771-8ce5-420c93b30029', 'adminbacd', '张三', '', '', '00', '', '', '', '', '0', '0', '0', '0', '1970-01-01 00:00:00', '', '$2a$10$yk./h7TH0qb1p3JKb3W2UeRNeAU7RNniueKBOEgkRN.EsWuvRftoq', '0', '0', '', null, '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-05-27 09:55:21', '', '1970-01-01 00:00:00', null, '', '');
INSERT INTO `sys_user` VALUES ('701', '66bc6e89-2de6-404e-8bc0-11cb3f4bffcd', '', '180b70fc-8def-4771-8ce5-420c93b30029', 'bacnms', 'uuu', '1,63a7c0e0-9238-454c-85d2-17c5b91b2f09,2e3bd226-ed99-4e67-8022-87228b9619a6,180b70fc-8def-4771-8ce5-420c93b30029', '自建企业web版,产品部,运营部,销售部1122', '00', '', '', '', '', '0', '0', '0', '0', '1970-01-01 00:00:00', '', '$2a$10$9Io8.27ZVwcggQYsiLvy8usoif70heMjihfzoFGGld7L4O0wDzFyC', '1', '0', '', null, '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-05-27 10:08:42', '', '1970-01-01 00:00:00', null, '', '');
INSERT INTO `sys_user` VALUES ('702', '7c9c5779-af94-4c4e-be2f-39bf9afe0a45', '', '180b70fc-8def-4771-8ce5-420c93b30029', 'wukong', '寻悟空', '1,63a7c0e0-9238-454c-85d2-17c5b91b2f09,2e3bd226-ed99-4e67-8022-87228b9619a6,180b70fc-8def-4771-8ce5-420c93b30029', '自建企业web版,产品部,运营部,销售部1122', '00', '', '', '', '', '0', '0', '0', '0', '1970-01-01 00:00:00', '', '$2a$10$GClaVFqbrF0xaI3Sx9rcU.bEwZLRu21QVm44D4kh4oZrI1yVNx2.e', '1', '0', '', null, '$userName=fa36ec75-160a-47e4-8140-ef1e94c5d329$', '2024-05-27 10:11:25', '', '1970-01-01 00:00:00', null, '5d70aa10-b5af-4092-b968-d374dd133269', '');
-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_post`;
CREATE TABLE `sys_user_post` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户ID',
`user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '人员名称',
`post_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '岗位ID',
`type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'all' COMMENT 'part兼职',
`is_delete` tinyint(1) DEFAULT '0' COMMENT '1删除',
`company_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司id',
`company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '公司名称',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_user_post_company` (`company_id`,`post_id`,`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户与岗位关联表';
-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户ID',
`role_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色ID',
`role_type` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '角色类型',
`scope_type` tinyint(1) DEFAULT '1' COMMENT '管理范围类型：1全公司，2本部门及下级部门，3指定部门，4继承角色管理范围',
`scope_ids` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '权限范围',
`scope_names` varchar(3000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '权限范围',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1解授权',
`update_time` datetime DEFAULT '1970-01-01 00:00:00' COMMENT '修改时间',
`company_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '公司id',
`company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '公司名称',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_company_role_user` (`company_id`,`user_id`,`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户和角色关联表';
-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES ('130', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '0cd789a0-1187-4c62-901d-a2801794e27a', 'admin', '1', '', '', '0', '1970-01-01 00:00:00', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_user_role` VALUES ('131', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', '19656797-182a-40dd-a22f-df2e8cad2e72', 'dept', '2', '1,63a7c0e0-9238-454c-85d2-17c5b91b2f09,2e3bd226-ed99-4e67-8022-87228b9619a6,180b70fc-8def-4771-8ce5-420c93b30029,07d6164d-0d7f-46e7-b4db-673c4d038b14', '', '0', '2024-05-27 08:38:08', '5d70aa10-b5af-4092-b968-d374dd133269', '');
INSERT INTO `sys_user_role` VALUES ('138', 'fa36ec75-160a-47e4-8140-ef1e94c5d329', 'fd62f233-f7c2-4d76-bb20-0866b3f0eeb3', 'group', '1', '', '', '0', '1970-01-01 00:00:00', '5d70aa10-b5af-4092-b968-d374dd133269', '');
Loading...
举报
请认真填写举报原因，尽可能描述详细。
请选择举报类型
误判申诉
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化