MySQL Create Table SQL
Table Structure: okayapi_eduwind_ew_group_course：/tablelist/okayapi_eduwind_ew_group_course.html
-- MySQL Table okayapi_eduwind_ew_group_course
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_group_course` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`groupId` int(11) NOT NULL DEFAULT '0' COMMENT '小组id',
`courseId` int(11) NOT NULL DEFAULT '0' COMMENT '课程id',
`userId` int(11) NOT NULL DEFAULT '0' COMMENT '收录者id',
`addTime` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
KEY `groupId` (`groupId`),
KEY `courseId` (`courseId`),
KEY `userId` (`userId`),
KEY `addTime` (`addTime`),
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-4 of 4 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| groupId | int(11) | 0 | 否 | 小组id | Normal Index | 0 |
| courseId | int(11) | 0 | 否 | 课程id | Normal Index | 0 |
| userId | int(11) | 0 | 否 | 收录者id | Normal Index | 0 |
| addTime | int(11) | 0 | 否 | 添加时间 | 0 |
