Data structure

12123

Table Overview

General Tables

• _user
• _user_session
• _role
• _page
• _resource
• _group
• _user_group_role
• _user_group_role_page
• _user_group_role_resource
• _constant
• _constant_ui
• _record
• _record_history
• _cache
• _file
• _view01_user

Business Tables

_ui

• UI Construction Plan

CREATE TABLE `_ui` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'page id; E.g: index',
  `uiActionType` varchar(255)  DEFAULT NULL COMMENT 'UI action type, e.g.: fetchData, postData, changeUi',
  `uiActionId` varchar(255)  DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  `desc` varchar(255)  DEFAULT NULL COMMENT 'Description',
  `uiActionConfig` text  COMMENT 'UI action data',
  `appDataSchema` text  COMMENT 'UI validation data',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'UI Construction Plan'

access_control_album_or_article

• Access Control Table for Student Table

CREATE TABLE `access_control_album_or_article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` varchar(255)  DEFAULT NULL COMMENT 'Primary key id',
  `username` varchar(255)  DEFAULT NULL COMMENT 'Username (login)',
  `resourceData` text  COMMENT 'Plain text password',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `username_index` (`username`) USING BTREE,
  UNIQUE KEY `userId_index` (`userId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Access Control Table for Student Table'

access_control_course

• Access Control Table for Student Table

CREATE TABLE `access_control_course` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` varchar(255)  DEFAULT NULL COMMENT 'Primary key id',
  `username` varchar(255)  DEFAULT NULL COMMENT 'Username (login)',
  `resourceData` text  COMMENT 'Plain text password',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `username_index` (`username`) USING BTREE,
  UNIQUE KEY `userId_index` (`userId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Access Control Table for Student Table'

article

CREATE TABLE `article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `articleId` bigint(20) DEFAULT NULL COMMENT 'Article id, 10000 ++',
  `categoryId` varchar(255) DEFAULT NULL,
  `categoryName` varchar(255) DEFAULT NULL,
  `articleCategoryId` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Category id',
  `courseId` varchar(255) DEFAULT NULL COMMENT 'Course id',
  `courseBatchId` varchar(255) DEFAULT NULL,
  `articleGroupName` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Article belonging group name',
  `articleTagList` text CHARACTER SET utf8mb4  COMMENT 'Tags; concatenated with ,',
  `articlePublishStatus` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Article type (status): public, login, draft, deleted',
  `articlePublishTime` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT 'Article publish time',
  `articleTitle` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT 'Title',
  `articleShortName` varchar(255) DEFAULT NULL COMMENT 'Short title',
  `articleConfig` text COMMENT 'Courseware configuration: whether to have exams, duration, etc.',
  `articleCoverImage` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT 'Cover image',
  `articleContent` longtext CHARACTER SET utf8mb4  COMMENT 'Edited content',
  `articleContentForSeo` longtext CHARACTER SET utf8mb4  COMMENT 'HTML for rendering',
  `articleAssignmentPublishStatus` varchar(255) DEFAULT NULL COMMENT 'Assignment publish status',
  `articleAssignment` text COMMENT 'Article assignment [{ }]',
  `articleAssignmentWithAnswer` text COMMENT 'Article assignment answers [{ }]',
  `articleAudioUrl` varchar(1023) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT 'Default audio URL unique',
  `articleVideoUrl` varchar(1023) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Default video URL',
  `articleCreateTime` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT 'Creation time',
  `articleCreateUserId` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Creator user ID',
  `articleCreateUsername` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Creator username',
  `articleUpdateTime` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Update time',
  `articleUpdateUserId` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Updater user ID',
  `articleUpdateUsername` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Updater username',
  `operation` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Operation: insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Operator userId',
  `operationByUser` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Operator username',
  `operationAt` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `article_unique` (`articleId`) USING BTREE,
  KEY `categoryId_index` (`articleCategoryId`) USING BTREE,
  KEY `articlePublishTime` (`articlePublishTime`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4760 DEFAULT CHARSET = utf8

article_history

CREATE TABLE `article_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `articleId` bigint(20) DEFAULT NULL COMMENT 'Article id, 10000 ++',
  `categoryId` varchar(255) DEFAULT NULL COMMENT 'Category ID',
  `categoryName` varchar(255) DEFAULT NULL COMMENT 'Category name',
  `articleCategoryId` varchar(255) DEFAULT NULL,
  `courseId` varchar(255) DEFAULT NULL COMMENT 'Course id',
  `courseBatchId` varchar(255) DEFAULT NULL COMMENT 'Course id',
  `articleGroupName` varchar(255) DEFAULT NULL COMMENT 'Article belonging group name',
  `articleTagList` varchar(255) DEFAULT NULL COMMENT 'Tags; concatenated with ,',
  `articlePublishStatus` varchar(255) DEFAULT 'login' COMMENT 'Article type (status): public, login, draft, deleted',
  `articlePublishTime` varchar(255) DEFAULT NULL COMMENT 'Article publish time',
  `articleApproveStatus` varchar(255) DEFAULT NULL,
  `articleTitle` varchar(255) DEFAULT NULL COMMENT 'Title',
  `articleShortName` varchar(255) DEFAULT NULL COMMENT 'Short title',
  `articleConfig` text,
  `articleCoverImage` varchar(255) DEFAULT NULL COMMENT 'Cover image',
  `articleContent` longtext COMMENT 'Edited content',
  `articleContentForSeo` longtext COMMENT 'HTML for rendering',
  `articleAssignment` text COMMENT 'Article assignment [{ }]',
  `articleAssignmentWithAnswer` text COMMENT 'Article assignment answers [{ }]',
  `articleAudioUrl` varchar(255) DEFAULT NULL COMMENT 'Default audio URL unique',
  `articleVideoUrl` varchar(255) DEFAULT NULL COMMENT 'Default video URL',
  `articleCreateTime` varchar(255) DEFAULT NULL COMMENT 'Creation time',
  `articleCreateUserId` varchar(255) DEFAULT NULL COMMENT 'Creator user ID',
  `articleCreateUsername` varchar(255) DEFAULT NULL COMMENT 'Creator username',
  `articleUpdateTime` varchar(255) DEFAULT NULL COMMENT 'Update time',
  `articleUpdateUserId` varchar(255) DEFAULT NULL COMMENT 'Updater user ID',
  `articleUpdateUsername` varchar(255) DEFAULT NULL COMMENT 'Updater username',
  `operation` varchar(255) DEFAULT 'insert' COMMENT 'Operation: insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT 'Operator userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT 'Operator username',
  `operationAt` varchar(255) DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00',
  `articleAssignmentPublishStatus` varchar(255) DEFAULT NULL COMMENT 'Article assignment publish status; publish;',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 DEFAULT CHARSET = utf8mb4

assignment

CREATE TABLE `assignment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `assignmentId` varchar(150) DEFAULT NULL COMMENT 'Student assignment ID; articleId_userId_123456',
  `albumId` varchar(30) DEFAULT NULL COMMENT 'Course ID',
  `classId` varchar(50) DEFAULT NULL COMMENT 'Class ID',
  `courseId` varchar(255) DEFAULT NULL,
  `courseBatchId` varchar(255) DEFAULT NULL,
  `articleId` varchar(30) DEFAULT NULL COMMENT 'Article ID',
  `userId` varchar(50) DEFAULT NULL COMMENT 'User ID',
  `articleTitle` varchar(255) DEFAULT NULL COMMENT 'Article title',
  `assignmentRetryNumber` int(11) DEFAULT NULL COMMENT 'Assignment redo count',
  `assignmentScore` int(11) DEFAULT NULL COMMENT 'Assignment score',
  `assignmentFullMarks` int(11) DEFAULT NULL COMMENT 'Total score for assignment',
  `assignmentSubmitStatus` varchar(255) DEFAULT 'save' COMMENT 'Assignment submission status; publish',
  `assignmentSubmitAt` varchar(255) DEFAULT NULL COMMENT 'Assignment submission time',
  `assignmentUserAnswer` text COMMENT 'User assignment content',
  `assignmentStandardAnswer` text COMMENT 'Standard answer for assignment',
  `assignmentAnswerHistory` longtext COMMENT 'Assignment history records',
  `assignmentReview` text,
  `assignmentReviewUserId` varchar(255) DEFAULT NULL COMMENT 'Reviewer UserId',
  `assignmentReviewUser` varchar(255) DEFAULT NULL,
  `assignmentReviewStatus` varchar(255) DEFAULT '' COMMENT 'Review status; publish',
  `assignmentReviewAt` varchar(255) DEFAULT NULL COMMENT 'Review time',
  `operation` varchar(255) DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT 'Operator user ID; userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT 'Operator;',
  `operationAt` varchar(255) DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uniq_assignmentId` (`assignmentId`) USING BTREE,
  KEY `group` (`courseBatchId`, `articleId`, `userId`) USING BTREE,
  KEY `id` (`id`) USING BTREE,
  KEY `albumId` (`albumId`) USING BTREE,
  KEY `courseBatchId` (`courseBatchId`) USING BTREE,
  KEY `classId` (`classId`) USING BTREE,
  KEY `articleId` (`articleId`) USING BTREE,
  KEY `userId` (`userId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 DEFAULT CHARSET = utf8mb4

attendance

CREATE TABLE `attendance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `classId` varchar(255)  DEFAULT NULL,
  `courseId` varchar(255)  DEFAULT NULL,
  `courseBatchId` varchar(255)  DEFAULT NULL,
  `userId` varchar(255)  DEFAULT NULL COMMENT 'Student user id;',
  `lessonNumber` int(11) DEFAULT NULL COMMENT 'Lesson number;',
  `attendanceDate` varchar(255)  DEFAULT NULL COMMENT 'Attendance date;',
  `attendance` varchar(255)  DEFAULT NULL COMMENT 'Attendance type; present, absent, late, leave early',
  `articleId` varchar(255)  DEFAULT NULL COMMENT 'Article ID',
  `articleTitle` varchar(255)  DEFAULT NULL COMMENT 'Article title',
  `markedAt` varchar(255)  DEFAULT NULL COMMENT 'Creation time',
  `markedByUser` varchar(255)  DEFAULT NULL COMMENT 'Creator',
  `markedByUserId` varchar(255)  DEFAULT NULL COMMENT 'Creator Id;',
  `remarks` varchar(255)  DEFAULT NULL COMMENT 'Remarks; explanation of absence',
  `operation` varchar(255) CHARACTER SET utf8mb4 DEFAULT '',
  `operationAt` varchar(255) CHARACTER SET utf8mb4 DEFAULT '',
  `operationByUserId` varchar(255) CHARACTER SET utf8mb4 DEFAULT '',
  `operationByUser` varchar(255) CHARACTER SET utf8mb4 DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id` (`id`) USING BTREE,
  KEY `classId` (`classId`) USING BTREE,
  KEY `courseBatchId` (`courseBatchId`) USING BTREE,
  KEY `studentId` (`userId`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

behavior

CREATE TABLE `behavior` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` varchar(255)  DEFAULT NULL,
  `createTime` varchar(255)  DEFAULT NULL,
  `courseBatchId` varchar(255)  DEFAULT NULL,
  `albumId` varchar(255)  DEFAULT NULL,
  `classId` varchar(255)  DEFAULT NULL,
  `articleId` varchar(255)  DEFAULT NULL,
  `userActionType` varchar(255)  DEFAULT NULL,
  `operation` varchar(255) CHARACTER SET utf8mb4 DEFAULT 'insert' COMMENT 'Operation: insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Operator userId',
  `operationByUser` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Operator username',
  `operationAt` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `user_index` (`userId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

bot_report

CREATE TABLE `bot_report` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reportId` varchar(255)  DEFAULT NULL,
  `reportName` varchar(255)  DEFAULT NULL,
  `reportType` varchar(255)  DEFAULT NULL,
  `reportContent` mediumtext ,
  `reportReceipient` varchar(255)  DEFAULT NULL,
  `reportTime` varchar(255)  DEFAULT NULL,
  `reportStatus` varchar(255)  DEFAULT NULL,
  `reportRawData` mediumtext ,
  `processBatchId` varchar(255)  DEFAULT NULL,
  `operation` varchar(255)  DEFAULT NULL,
  `operationAt` varchar(255)  DEFAULT NULL,
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2977 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

category

CREATE TABLE `category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `categoryId` bigint(255) DEFAULT NULL COMMENT 'Category id',
  `categoryIntro` text CHARACTER SET utf8mb4 ,
  `categoryName` varchar(255) CHARACTER SET utf8mb4  DEFAULT '',
  `prefix` varchar(255) DEFAULT NULL,
  `sortNumber` varchar(255) DEFAULT NULL,
  `categoryGroup` varchar(255) DEFAULT NULL,
  `categoryGroupSort` varchar(255) DEFAULT NULL,
  `categoryMark` varchar(255) DEFAULT NULL COMMENT 'Remarks',
  `categoryPublishStatus` varchar(255) DEFAULT '',
  `categoryCreateTime` varchar(255) DEFAULT '',
  `categoryCreateUserId` varchar(255) DEFAULT '',
  `categoryCreateUsername` varchar(255) DEFAULT '',
  `categoryUpdateTime` varchar(255) DEFAULT '',
  `categoryUpdateUserId` varchar(255) DEFAULT '',
  `categoryUpdateUsername` varchar(255) DEFAULT '',
  `operation` varchar(255) DEFAULT '',
  `operationByUserId` varchar(255) DEFAULT '',
  `operationByUser` varchar(255) DEFAULT '',
  `operationAt` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `categoryId_unique` (`categoryId`) USING BTREE,
  KEY `categoryName_unique` (`categoryName`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 176 DEFAULT CHARSET = utf8mb4

cgg_course

• Course

CREATE TABLE `cgg_course` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `courseId` varchar(255)  DEFAULT NULL COMMENT 'Belonging course series',
  `courseBatch` varchar(255)  DEFAULT NULL COMMENT 'Course term number',
  `courseBatchId` varchar(255)  DEFAULT NULL COMMENT 'Current course ID',
  `courseName` varchar(255)  DEFAULT NULL COMMENT 'Course name',
  `courseOrProject` varchar(255)  DEFAULT NULL COMMENT 'Course type',
  `studentOrTeacher` varchar(255)  DEFAULT NULL COMMENT 'Student type',
  `applicationType` varchar(255)  DEFAULT NULL COMMENT 'Application type',
  `workload` text  COMMENT 'Weekly workload',
  `prerequisites` text  COMMENT 'Prerequisite courses',
  `nextCourseBatchId` varchar(255)  DEFAULT NULL COMMENT 'Next course',
  `courseDescription` longtext  COMMENT 'Course introduction',
  `courseLeader` varchar(255)  DEFAULT NULL COMMENT 'Person in charge',
  `courseUrl` varchar(255)  DEFAULT NULL COMMENT 'Course homepage',
  `teacherCourseBatchId` varchar(255)  DEFAULT NULL COMMENT 'Class leader course ID',
  `managerCourseBatchId` varchar(255)  DEFAULT NULL COMMENT 'Course manager course ID',
  `startDate` varchar(255)  DEFAULT NULL COMMENT 'Start date',
  `endDate` varchar(255)  DEFAULT NULL COMMENT 'End date',
  `totalClassHour` varchar(255)  DEFAULT NULL COMMENT 'Total class hours',
  `courseCredit` varchar(255)  DEFAULT NULL COMMENT 'Course credits',
  `courseStatus` varchar(255)  DEFAULT NULL COMMENT 'Course status',
  `operation` varchar(255)  DEFAULT NULL COMMENT 'Operation',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator username (display)',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `course_batch_id` (`courseBatchId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 143 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Course'

cgg_course_series

• Course Series

CREATE TABLE `cgg_course_series` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `courseId` varchar(255)  DEFAULT NULL COMMENT 'Belonging course series',
  `courseName` varchar(255)  DEFAULT NULL COMMENT 'Course name',
  `courseLeader` varchar(255)  DEFAULT NULL COMMENT 'Person in charge',
  `operation` varchar(255)  DEFAULT NULL COMMENT 'Operation',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator username (display)',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `courseId` (`courseId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 134 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Course Series'

cgg_member_v3

CREATE TABLE `cgg_member_v3` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `memberId` varchar(255)  DEFAULT NULL COMMENT 'Member number',
  `midNumber` int(20) DEFAULT NULL COMMENT 'Member number digits',
  `loginId` varchar(255)  DEFAULT NULL COMMENT 'User account',
  `sortId` varchar(255)  DEFAULT NULL COMMENT 'Sorting order',
  `netName` varchar(255)  DEFAULT NULL COMMENT 'Name',
  `district` varchar(255)  DEFAULT NULL COMMENT 'Organization district',
  `orgId` varchar(255)  DEFAULT NULL COMMENT 'Organization number',
  `orgName` varchar(255)  DEFAULT NULL COMMENT 'Organization name',
  `_orgName` varchar(255)  DEFAULT NULL COMMENT 'Old organization name',
  `orgPath` varchar(255)  DEFAULT NULL COMMENT 'Organization path',
  `roleId` varchar(255)  DEFAULT NULL COMMENT 'Organization role',
  `joinState` varchar(255)  DEFAULT NULL COMMENT 'Enrollment status',
  `joinAt` varchar(255)  DEFAULT NULL COMMENT 'Join time',
  `stage` varchar(255)  DEFAULT NULL COMMENT 'Growth stage',
  `position` varchar(255)  DEFAULT NULL COMMENT 'Growth level',
  `target` longtext  COMMENT 'Growth target',
  `note` longtext  COMMENT 'Remarks',
  `followUpBy` varchar(255)  DEFAULT NULL COMMENT 'Follower',
  `pendingAction` varchar(255)  DEFAULT NULL COMMENT 'Follow-up status',
  `referer` varchar(255)  DEFAULT NULL COMMENT 'Visitor source',
  `_referer` varchar(255)  DEFAULT NULL COMMENT 'Old visitor source',
  `wechatId` varchar(255)  DEFAULT NULL COMMENT 'WeChat ID',
  `qqNumber` varchar(255)  DEFAULT NULL COMMENT 'QQ',
  `alipayId` varchar(255)  DEFAULT NULL COMMENT 'Alipay',
  `lineId` varchar(255)  DEFAULT NULL COMMENT 'LINE',
  `whatsappId` varchar(255)  DEFAULT NULL COMMENT 'WhatsApp',
  `country` varchar(255)  DEFAULT NULL COMMENT 'Region',
  `countryCode` varchar(255)  DEFAULT NULL COMMENT 'Country code',
  `phoneNumber` varchar(255)  DEFAULT NULL COMMENT 'Phone number',
  `email` varchar(255)  DEFAULT NULL COMMENT 'Email',
  `address` varchar(255)  DEFAULT NULL COMMENT 'Address',
  `idName` varchar(255)  DEFAULT NULL COMMENT 'Name',
  `isChild` varchar(255)  DEFAULT NULL COMMENT 'Is minor',
  `guardianId` varchar(255)  DEFAULT NULL COMMENT 'Guardian ID',
  `guardianName` varchar(255)  DEFAULT NULL COMMENT 'Guardian name',
  `leaveAt` varchar(255)  DEFAULT NULL COMMENT 'Leave time',
  `leaveNote` longtext  COMMENT 'Leave remarks',
  `createAt` varchar(255)  DEFAULT NULL COMMENT 'Creation time',
  `updateAt` varchar(255)  DEFAULT NULL COMMENT 'Update time',
  `operation` varchar(255)  DEFAULT NULL COMMENT 'Operation',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operator userId',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator username (display)',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1002 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

class_member

CREATE TABLE `class_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `courseId` varchar(255)  DEFAULT NULL COMMENT 'Belonging ministry series',
  `courseMemberId` varchar(255)  DEFAULT NULL COMMENT 'Learning record number',
  `courseBatchId` varchar(255)  DEFAULT NULL COMMENT 'Current course ID',
  `courseName` varchar(255)  DEFAULT NULL COMMENT 'Course name',
  `classId` varchar(255)  DEFAULT NULL COMMENT 'Class ID',
  `className` varchar(255)  DEFAULT NULL COMMENT 'Class name',
  `memberId` varchar(255)  DEFAULT NULL COMMENT 'Student member number',
  `netName` varchar(255)  DEFAULT NULL COMMENT 'Student name',
  `loginId` varchar(255)  DEFAULT NULL COMMENT 'Student user ID',
  `district` varchar(255)  DEFAULT NULL COMMENT 'Student district',
  `classMemberRole` varchar(255)  DEFAULT NULL COMMENT 'Class student role',
  `classMemberStatus` varchar(255)  DEFAULT NULL COMMENT 'Class student status',
  `operation` varchar(255)  DEFAULT NULL COMMENT 'Operation',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation time',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `classId_memberId` (`classId`, `memberId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5870 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

course_article

• Class Course Table; Soft delete not enabled;

CREATE TABLE `course_article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `courseId` varchar(255) DEFAULT NULL COMMENT 'Course ID',
  `courseBatchId` varchar(255) DEFAULT NULL COMMENT 'Current course ID',
  `courseName` varchar(255) DEFAULT NULL COMMENT 'Course title',
  `albumId` varchar(255) DEFAULT NULL COMMENT 'Textbook ID',
  `albumTitle` varchar(255) DEFAULT NULL COMMENT 'Textbook title',
  `articleId` bigint(20) DEFAULT NULL COMMENT 'Article Id',
  `articleTitle` varchar(255) DEFAULT NULL COMMENT 'Article title',
  `articleShortName` varchar(255) DEFAULT NULL,
  `categoryName` varchar(255) DEFAULT NULL,
  `lessonNumber` int(11) DEFAULT NULL COMMENT 'Lesson number',
  `publishTime` varchar(255) DEFAULT NULL COMMENT 'Article publish time',
  `passcode` varchar(255) DEFAULT NULL COMMENT 'Course password',
  `isExam` varchar(255) DEFAULT NULL COMMENT 'Is it an exam',
  `examDuration` varchar(255) DEFAULT NULL COMMENT 'Exam time limit',
  `examExpiryTime` varchar(255) DEFAULT NULL COMMENT 'Exam expiry time',
  `examMaxRetryNumber` varchar(255) DEFAULT NULL COMMENT 'Allowed retake count',
  `examPassingScore` varchar(255) DEFAULT NULL COMMENT 'Passing score',
  `isShowAnswer` varchar(255) DEFAULT NULL COMMENT 'Whether to automatically show answers after the exam',
  `displayStatus` varchar(255) DEFAULT NULL COMMENT 'Display status: show, hide',
  `operation` varchar(255) DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT 'Operator userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT 'Operator username',
  `operationAt` varchar(255) DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `groupId_index` (`articleId`) USING BTREE,
  KEY `albumId_index` (`albumId`) USING BTREE,
  KEY `group_albumId_unique` (`articleId`, `albumId`) USING BTREE,
  KEY `courseBatchId` (`courseBatchId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1095 DEFAULT CHARSET = utf8mb4 COMMENT = 'Class Course Table; Soft delete not enabled;'

course_class

CREATE TABLE `course_class` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `courseId` varchar(255)  DEFAULT NULL COMMENT 'Belonging course series',
  `courseBatchId` varchar(255)  DEFAULT NULL COMMENT 'Current course ID',
  `courseName` varchar(255)  DEFAULT NULL COMMENT 'Course name',
  `courseBatch` varchar(255)  DEFAULT NULL COMMENT 'Course term number',
  `classId` varchar(255)  DEFAULT NULL COMMENT 'Class ID',
  `className` varchar(255)  DEFAULT NULL COMMENT 'Class name',
  `classNumber` varchar(255)  DEFAULT NULL COMMENT 'Class number',
  `classLeaderMemberId` varchar(255)  DEFAULT NULL COMMENT 'Class leader member number',
  `classLeaderUserId` varchar(255)  DEFAULT NULL COMMENT 'Class leader user ID',
  `classLeaderName` varchar(255)  DEFAULT NULL COMMENT 'Class leader name',
  `classLeaderDistrict` varchar(255)  DEFAULT NULL COMMENT 'Class leader district',
  `maxNumberOfMember` varchar(255)  DEFAULT NULL COMMENT 'Maximum number of students in class',
  `isJianghuGroup` varchar(255)  DEFAULT NULL COMMENT 'Is Jianghu group created',
  `isJianghuAllAdmin` varchar(255)  DEFAULT NULL COMMENT 'Are all members set as administrators in Jianghu',
  `isDuoxingGroup` varchar(255)  DEFAULT NULL COMMENT 'Is Duoxing group created',
  `isDuoxingAllAdmin` varchar(255)  DEFAULT NULL COMMENT 'Are all members set as administrators in Duoxing',
  `isBaofengGroup` varchar(255)  DEFAULT NULL COMMENT 'Is Baofeng group created',
  `isBaofengAllAdmin` varchar(255)  DEFAULT NULL COMMENT 'Are all members set as administrators in Baofeng',
  `groupCloudDriveStatus` varchar(255)  DEFAULT NULL COMMENT 'Is cloud drive enabled; on enabled, off disabled',
  `classStatus` varchar(255)  DEFAULT 'active' COMMENT 'Class status',
  `operation` varchar(255)  DEFAULT NULL,
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  `operationAt` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `classId` (`classId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 415 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

examination

CREATE TABLE `examination` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `assignmentId` varchar(150) DEFAULT NULL COMMENT 'Student assignment ID; articleId_userId_123456',
  `albumId` varchar(30) DEFAULT NULL COMMENT 'Course ID',
  `classId` varchar(50) DEFAULT NULL COMMENT 'Class ID',
  `courseBatchId` varchar(50) DEFAULT NULL,
  `articleId` varchar(30) DEFAULT NULL COMMENT 'Article ID',
  `userId` varchar(50) DEFAULT NULL COMMENT 'User ID',
  `examRetryNumber` varchar(30) DEFAULT NULL,
  `assignmentExamSeconds` int(11) DEFAULT NULL COMMENT 'Remaining answering seconds',
  `assignmentScore` int(11) DEFAULT NULL COMMENT 'Assignment score',
  `assignmentFullMarks` int(11) DEFAULT NULL,
  `assignmentSubmitStatus` varchar(255) DEFAULT 'save' COMMENT 'Assignment submission status; publish',
  `assignmentSubmitAt` varchar(255) DEFAULT NULL COMMENT 'Assignment submission time',
  `assignmentUserAnswer` text COMMENT 'User assignment content',
  `assignmentStandardAnswer` text COMMENT 'Standard answer for assignment',
  `assignmentAnswerHistory` longtext,
  `assignmentReview` text,
  `assignmentReviewUserId` varchar(255) DEFAULT NULL COMMENT 'Reviewer UserId',
  `assignmentReviewStatus` varchar(255) DEFAULT '' COMMENT 'Review status; publish',
  `assignmentReviewUser` varchar(255) DEFAULT NULL,
  `assignmentReviewAt` varchar(255) DEFAULT NULL COMMENT 'Review time',
  `operation` varchar(255) DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT 'Operator user ID; userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT 'Operator;',
  `operationAt` varchar(255) DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uniq_assignmentId` (`assignmentId`) USING BTREE,
  UNIQUE KEY `uniq` (`articleId`, `courseBatchId`, `userId`) USING BTREE,
  KEY `albumId` (`albumId`) USING BTREE,
  KEY `classId` (`classId`) USING BTREE,
  KEY `courseBatchId` (`courseBatchId`) USING BTREE,
  KEY `articleId` (`articleId`) USING BTREE,
  KEY `userId` (`userId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 DEFAULT CHARSET = utf8mb4

note

CREATE TABLE `note` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `noteId` bigint(20) DEFAULT NULL COMMENT 'Note ID',
  `articleId` varchar(50) DEFAULT NULL COMMENT 'Article ID',
  `classId` varchar(50) DEFAULT NULL COMMENT 'Class Id',
  `courseBatchId` varchar(255) DEFAULT NULL,
  `albumId` varchar(50) DEFAULT NULL COMMENT 'Course Id',
  `userId` varchar(50) DEFAULT NULL COMMENT 'User id',
  `noteContent` longtext COMMENT 'Note content',
  `noteContentForSeo` longtext COMMENT 'Note rendering content',
  `noteRemark` text COMMENT 'Student supplement',
  `noteReview` longtext COMMENT 'Note review',
  `noteRemarkReview` text COMMENT 'Review student supplement',
  `noteReviewStatus` varchar(255) DEFAULT NULL COMMENT 'Review status',
  `noteReviewAt` varchar(255) DEFAULT NULL,
  `noteSubmitStatus` varchar(255) DEFAULT 'save' COMMENT 'Note submission status',
  `noteSubmitAt` varchar(255) DEFAULT NULL COMMENT 'Note submission time',
  `operation` varchar(255) DEFAULT 'insert' COMMENT 'Operation: insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT 'Operator userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT 'Operator username',
  `operationAt` varchar(255) DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `group` (`courseBatchId`, `articleId`, `userId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 DEFAULT CHARSET = utf8mb4

question

CREATE TABLE `question` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `questionId` varchar(255) DEFAULT NULL COMMENT 'Question id, 10000 ++',
  `questionDesc` varchar(255) DEFAULT NULL COMMENT 'Question description',
  `questionType` varchar(255) DEFAULT NULL COMMENT 'Question type',
  `articleId` varchar(255) DEFAULT NULL COMMENT 'Article id, 10000 ++',
  `categoryId` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Category id',
  `categoryName` varchar(255) DEFAULT NULL COMMENT 'Category name',
  `courseId` varchar(255) DEFAULT NULL COMMENT 'Course id',
  `courseBatchId` varchar(255) DEFAULT NULL,
  `articleGroupName` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Article belonging group name',
  `articleTagList` text CHARACTER SET utf8mb4  COMMENT 'Tags; concatenated with ,',
  `articlePublishStatus` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Article type (status): public, login, draft, deleted',
  `articlePublishTime` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT 'Article publish time',
  `articleTitle` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT 'Title',
  `articleShortName` varchar(255) DEFAULT NULL COMMENT 'Short title',
  `articleConfig` text COMMENT 'Courseware configuration: whether to have exams, duration, etc.',
  `articleAssignmentPublishStatus` varchar(255) DEFAULT NULL COMMENT 'Assignment publish status',
  `questionTag` varchar(255) DEFAULT NULL COMMENT 'Question tag;',
  `questionStem` text COMMENT 'Stem;',
  `questionContent` text COMMENT 'Question body { }',
  `questionContentWithAnswer` text COMMENT 'Question answer body { }',
  `articleAudioUrl` varchar(1023) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT 'Default audio URL unique',
  `articleVideoUrl` varchar(1023) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Default video URL',
  `articleCreateTime` varchar(255) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT 'Creation time',
  `articleCreateUserId` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Creator user ID',
  `articleCreateUsername` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Creator username',
  `articleUpdateTime` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Update time',
  `articleUpdateUserId` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Updater user ID',
  `articleUpdateUsername` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Updater username',
  `operation` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Operation: insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Operator userId',
  `operationByUser` varchar(255) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'Operator username',
  `operationAt` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Operation time; E.g: 2021-05-28T10:24:54+08:00',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `question_unique` (`questionId`) USING BTREE,
  KEY `articleId_index` (`articleId`) USING BTREE,
  KEY `courseBatchId` (`courseBatchId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 49 DEFAULT CHARSET = utf8

student_complete_course_record

CREATE TABLE `student_complete_course_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `courseMemberId` varchar(255)  DEFAULT NULL COMMENT 'Learning record number',
  `courseBatchId` varchar(255)  DEFAULT NULL COMMENT 'Current course ID',
  `courseName` varchar(255)  DEFAULT NULL COMMENT 'Course name',
  `courseId` varchar(255)  DEFAULT NULL COMMENT 'Course series number',
  `classId` varchar(255)  DEFAULT NULL COMMENT 'Class number',
  `memberId` varchar(255)  DEFAULT NULL COMMENT 'Employee number',
  `netName` varchar(255)  DEFAULT NULL COMMENT 'Name',
  `loginId` varchar(255)  DEFAULT NULL COMMENT 'User ID',
  `district` varchar(255)  DEFAULT NULL COMMENT 'District',
  `result` varchar(50)  DEFAULT NULL COMMENT 'Graduation score',
  `teacherRecommendation` varchar(255)  DEFAULT NULL COMMENT 'Recommendation: graduation, drop course',
  `memberCourseStatus` varchar(255)  DEFAULT NULL COMMENT 'Course learning status',
  `learningRecordDetail` mediumtext  COMMENT 'Learning record details',
  `createByUserId` varchar(255)  DEFAULT NULL COMMENT 'Teacher user ID who submitted graduation decision',
  `createByUser` varchar(255)  DEFAULT NULL COMMENT 'Teacher who submitted graduation decision',
  `createAt` varchar(255)  DEFAULT NULL COMMENT 'Creation time of graduation decision submission',
  `nextCourseBatchId` varchar(255)  DEFAULT NULL COMMENT 'Automatically promoted course ID',
  `nextCourseClassId` varchar(255)  DEFAULT NULL COMMENT 'Automatically promoted class ID',
  `processStatus` varchar(255)  DEFAULT NULL COMMENT 'Processing status: new-created, processed-processed, error-error',
  `processBatchId` varchar(255)  DEFAULT NULL COMMENT 'Processing BatchId',
  `processResult` varchar(255)  DEFAULT NULL COMMENT 'Processing result: approved, rejected',
  `processDetails` text  COMMENT 'Processing details',
  `processByUserId` varchar(255)  DEFAULT NULL COMMENT 'Processor',
  `processByUser` varchar(255)  DEFAULT NULL COMMENT 'Processor',
  `deleteErrorRemarks` varchar(255)  DEFAULT NULL COMMENT 'Remarks on errors during deletion',
  `syncErrorRemarks` varchar(255)  DEFAULT NULL COMMENT 'Remarks on errors