MySQL Create Table SQL
Table Structure: okayapi_eduwind_ew_lesson_doc：/tablelist/okayapi_eduwind_ew_lesson_doc.html
-- MySQL Table okayapi_eduwind_ew_lesson_doc
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_lesson_doc` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`lessonId` int(11) NOT NULL DEFAULT '0' COMMENT '课时id',
`fileId` int(11) NOT NULL DEFAULT '0' COMMENT '文件id，reference(upload_file)',
`description` text NOT NULL COMMENT '文件描述',
`downloadNum` int(11) NOT NULL DEFAULT '0' COMMENT '下载次数',
KEY `lessonId` (`lessonId`),
KEY `fileId` (`fileId`),
KEY `description` (`description`),
KEY `downloadNum` (`downloadNum`),
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 |
|---|---|---|---|---|---|---|
| lessonId | int(11) | 0 | 否 | 课时id | 0 | |
| fileId | int(11) | 0 | 否 | 文件id，reference(upload_file) | 0 | |
| description | text | 是 | 文件描述 | |||
| downloadNum | int(11) | 0 | 否 | 下载次数 | 0 |
