okayapi_eduwind_ew_course_quiz_report - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_course_quiz_report：/tablelist/okayapi_eduwind_ew_course_quiz_report.html


-- MySQL Table okayapi_eduwind_ew_course_quiz_report
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_course_quiz_report` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `avgScore` decimal(5,2) NOT NULL COMMENT '',
    `totalScore` decimal(5,2) NOT NULL COMMENT '',
    `quizNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `correctNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `partialCorrectNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `wrongNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `userId` int(11) NOT NULL COMMENT '',
    `courseId` int(11) NOT NULL COMMENT '',
    `quizIds` char(255) NOT NULL COMMENT '',
    KEY `avgScore` (`avgScore`),
    KEY `totalScore` (`totalScore`),
    KEY `quizNum` (`quizNum`),
    KEY `correctNum` (`correctNum`),
    KEY `partialCorrectNum` (`partialCorrectNum`),
    KEY `wrongNum` (`wrongNum`),
    KEY `userId` (`userId`),
    KEY `courseId` (`courseId`),
    KEY `quizIds` (`quizIds`),
    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-9 of 9 results.

Field Name	Field Type	Default	IS NULL	Demo Data
avgScore	decimal(5,2)		是
totalScore	decimal(5,2)		是
quizNum	int(11)	0	否	0
correctNum	int(11)	0	否	0
partialCorrectNum	int(11)	0	否	0
wrongNum	int(11)	0	否	0
userId	int(11)		否
courseId	int(11)		否
quizIds	char(255)		否