okayapi_eduwind_ew_course_member - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_course_member：/tablelist/okayapi_eduwind_ew_course_member.html


-- MySQL Table okayapi_eduwind_ew_course_member
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_course_member` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `orderId` int(11) NULL DEFAULT '0' COMMENT '',
    `startTime` int(11) NULL COMMENT '',
    `endTime` int(11) NULL DEFAULT '0' COMMENT '',
    `courseId` int(11) NULL DEFAULT '0' COMMENT '',
    `userId` int(11) NULL DEFAULT '0' COMMENT '',
    `roles` char(64) NULL DEFAULT '0' COMMENT '',
    `okayapi_eduwind_ew_course_member_status` int(11) NULL DEFAULT '0' COMMENT '',
    `commentNum` int(11) NULL COMMENT '',
    KEY `orderId` (`orderId`),
    KEY `startTime` (`startTime`),
    KEY `endTime` (`endTime`),
    KEY `courseId` (`courseId`),
    KEY `userId` (`userId`),
    KEY `roles` (`roles`),
    KEY `okayapi_eduwind_ew_course_member_status` (`okayapi_eduwind_ew_course_member_status`),
    KEY `commentNum` (`commentNum`),
    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-8 of 8 results.

Field Name	Field Type	Default	IS NULL	Index	Demo Data
orderId	int(11)	0	否		0
startTime	int(11)		否
endTime	int(11)	0	否		0
courseId	int(11)	0	否	Normal Index	0
userId	int(11)	0	否		0
roles	char(64)	0	否		0
okayapi_eduwind_ew_course_member_status	int(11)	0	否		0
commentNum	int(11)		是