okayapi_eduwind_ew_course - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_course：/tablelist/okayapi_eduwind_ew_course.html


-- MySQL Table okayapi_eduwind_ew_course
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_course` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_eduwind_ew_course_name` char(64) NOT NULL COMMENT '课程名称',
    `userId` int(11) NOT NULL COMMENT '课程创建人id',
    `memberNum` int(11) NOT NULL DEFAULT '0' COMMENT '修课人数',
    `viewNum` int(11) NOT NULL DEFAULT '0' COMMENT '点击量',
    `fee` decimal(7,2) NOT NULL DEFAULT '0.00' COMMENT '费用',
    `entityId` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `categoryId` int(11) NOT NULL DEFAULT '0' COMMENT '课程分类',
    `face` char(255) NOT NULL COMMENT '课程头像存放位置',
    `introduction` text NOT NULL COMMENT '课程简介',
    `addTime` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
    `okayapi_eduwind_ew_course_status` int(11) NOT NULL DEFAULT '0' COMMENT '状态，ok,applied,created',
    `rateScore` decimal(3,1) NOT NULL DEFAULT '0.0' COMMENT '平均得分',
    `rateNum` int(11) NOT NULL DEFAULT '0' COMMENT '评分人次',
    `targetStudent` varchar(1024) NOT NULL COMMENT '目标学员',
    `subTitle` char(255) NOT NULL COMMENT '副标题',
    `isTop` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否推荐',
    `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `deleteTime` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `studentNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `validTime` int(11) NOT NULL DEFAULT '0' COMMENT '',
    KEY `okayapi_eduwind_ew_course_name` (`okayapi_eduwind_ew_course_name`),
    KEY `userId` (`userId`),
    KEY `memberNum` (`memberNum`),
    KEY `viewNum` (`viewNum`),
    KEY `fee` (`fee`),
    KEY `entityId` (`entityId`),
    KEY `categoryId` (`categoryId`),
    KEY `face` (`face`),
    KEY `introduction` (`introduction`),
    KEY `addTime` (`addTime`),
    KEY `okayapi_eduwind_ew_course_status` (`okayapi_eduwind_ew_course_status`),
    KEY `rateScore` (`rateScore`),
    KEY `rateNum` (`rateNum`),
    KEY `targetStudent` (`targetStudent`),
    KEY `subTitle` (`subTitle`),
    KEY `isTop` (`isTop`),
    KEY `deleted` (`deleted`),
    KEY `deleteTime` (`deleteTime`),
    KEY `studentNum` (`studentNum`),
    KEY `validTime` (`validTime`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'EW在线教育-课程表';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-20 of 20 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
okayapi_eduwind_ew_course_name	char(64)		否	课程名称
userId	int(11)		否	课程创建人id	Normal Index
memberNum	int(11)	0	否	修课人数		0
viewNum	int(11)	0	否	点击量		0
fee	decimal(7,2)	0.00	否	费用		0.00
entityId	int(11)	0	否			0
categoryId	int(11)	0	否	课程分类		0
face	char(255)		否	课程头像存放位置
introduction	text		是	课程简介
addTime	int(11)	0	否	添加时间		0
okayapi_eduwind_ew_course_status	int(11)	0	否	状态，ok,applied,created		0
rateScore	decimal(3,1)	0.0	否	平均得分		0.0
rateNum	int(11)	0	否	评分人次		0
targetStudent	varchar(1024)		否	目标学员
subTitle	char(255)		否	副标题
isTop	tinyint(4)	0	否	是否推荐		0
deleted	tinyint(1)	0	否			0
deleteTime	int(11)	0	否			0
studentNum	int(11)	0	否			0
validTime	int(11)	0	否			0