课程中心模块，Mysql数据库设计

最新推荐文章于 2023-04-21 09:18:51 发布

爱摄影的程序员。

最新推荐文章于 2023-04-21 09:18:51 发布

阅读量181

点赞数

分类专栏： Mysql专栏文章标签：数据库 mysql database

本文链接：https://blog.csdn.net/php_xml/article/details/121243371

版权

Mysql专栏专栏收录该内容

12 篇文章 1 订阅

订阅专栏

CREATE TABLE `lesson` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `less_name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '课程标题',
  `cat_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '分类id',
  `teacher_name` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '讲师名字',
  `send_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发布时间',
  `desc` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '简单描述',
  `auth` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0=公开1=指定用户查看2=知道角色查看',
  `role_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',
  `user_ids` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '可查看的用户ids',
  `read_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '查看次数',
  `company_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '细胞ID',
  `editor_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作人ID',
  `files_url` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '课件地址',
  `cover_url` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '课程封面图',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0=草稿1=发布2==下架',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cat_id` (`cat_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='课程：课程信息表';

CREATE TABLE `lesson_cat` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '分类名字',
  `p_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父类id',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0=正常1=隐藏',
  `editor_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作人ID',
  `sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `created_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `p_id` (`p_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='课程：课程分类表';

CREATE TABLE `lesson_records` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `lesson_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lesson_id` bigint(20) unsigned DEFAULT NULL COMMENT '课程操作id',
  `describe` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '记录描述',
  `type` tinyint(4) NOT NULL COMMENT '记录类型，删除，新增等',
  `subtype` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '子类型',
  `state` tinyint(3) unsigned DEFAULT NULL COMMENT '可用标志状态',
  `param` text COLLATE utf8mb4_unicode_ci COMMENT '记录参数',
  `editor_id` int(11) NOT NULL COMMENT '编辑人ID',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `lesson_id` (`lesson_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='课程：课程操作记录表';

CREATE TABLE `lesson_video` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `video_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '视频名字',
  `less_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '课程id',
  `video_url` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '视频地址',
  `files_url` varchar(4096) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '课件附件地址',
  `remark` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '描述',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0=正常1=隐藏',
  `editor_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作人ID',
  `created_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `less_id` (`less_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='课程：课程可见视频表';