okayapi_eduwind_ew_question_report - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_question_report：/tablelist/okayapi_eduwind_ew_question_report.html


-- MySQL Table okayapi_eduwind_ew_question_report
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_question_report` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `questionId` int(11) NOT NULL COMMENT '',
    `memberNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `partialCorrectRate` decimal(5,4) NOT NULL DEFAULT '0.0000' COMMENT '',
    `wrongRate` decimal(5,4) NOT NULL DEFAULT '0.0000' COMMENT '',
    `correctRate` decimal(5,4) NOT NULL DEFAULT '0.0000' COMMENT '',
    `aNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `bNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `cNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `dNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `okayapi_eduwind_ew_question_report_eNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `fNum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    KEY `questionId` (`questionId`),
    KEY `memberNum` (`memberNum`),
    KEY `partialCorrectRate` (`partialCorrectRate`),
    KEY `wrongRate` (`wrongRate`),
    KEY `correctRate` (`correctRate`),
    KEY `aNum` (`aNum`),
    KEY `bNum` (`bNum`),
    KEY `cNum` (`cNum`),
    KEY `dNum` (`dNum`),
    KEY `okayapi_eduwind_ew_question_report_eNum` (`okayapi_eduwind_ew_question_report_eNum`),
    KEY `fNum` (`fNum`),
    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-11 of 11 results.

Field Name	Field Type	Default	IS NULL	Demo Data
questionId	int(11)		否
memberNum	int(11)	0	否	0
partialCorrectRate	decimal(5,4)	0.0000	是	0.0000
wrongRate	decimal(5,4)	0.0000	是	0.0000
correctRate	decimal(5,4)	0.0000	是	0.0000
aNum	int(11)	0	否	0
bNum	int(11)	0	否	0
cNum	int(11)	0	否	0
dNum	int(11)	0	否	0
okayapi_eduwind_ew_question_report_eNum	int(11)	0	否	0
fNum	int(11)	0	否	0