okayapi_eduwind_ew_quiz_report - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_quiz_report：/tablelist/okayapi_eduwind_ew_quiz_report.html


-- MySQL Table okayapi_eduwind_ew_quiz_report
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_quiz_report` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `quizId` int(11) NOT NULL COMMENT '',
    `userId` int(11) NOT NULL COMMENT '',
    `score` decimal(7,2) NOT NULL DEFAULT '0.00' COMMENT '得分',
    `correctNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `wrongNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `partialCorrectNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `teacherRemark` text NOT NULL COMMENT '',
    `remarkTime` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `addTime` int(11) NOT NULL DEFAULT '0' COMMENT '',
    KEY `quizId` (`quizId`),
    KEY `userId` (`userId`),
    KEY `score` (`score`),
    KEY `correctNum` (`correctNum`),
    KEY `wrongNum` (`wrongNum`),
    KEY `partialCorrectNum` (`partialCorrectNum`),
    KEY `teacherRemark` (`teacherRemark`),
    KEY `remarkTime` (`remarkTime`),
    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-9 of 9 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
quizId	int(11)		否
userId	int(11)		否
score	decimal(7,2)	0.00	否	得分	0.00
correctNum	int(11)	0	否		0
wrongNum	int(11)	0	否		0
partialCorrectNum	int(11)	0	否		0
teacherRemark	text		是
remarkTime	int(11)	0	否		0
addTime	int(11)	0	否		0