okayapi_eduwind_ew_question - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_question：/tablelist/okayapi_eduwind_ew_question.html


-- MySQL Table okayapi_eduwind_ew_question
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_question` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `stem` text NOT NULL COMMENT '',
    `quizId` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `okayapi_eduwind_ew_question_type` char(32) NOT NULL DEFAULT 'multiple-choice' COMMENT '',
    `score` decimal(7,1) NOT NULL DEFAULT '1.0' COMMENT '得分',
    `solution` text NOT NULL COMMENT '',
    `weight` int(11) NOT NULL DEFAULT '0' COMMENT '',
    KEY `stem` (`stem`),
    KEY `quizId` (`quizId`),
    KEY `okayapi_eduwind_ew_question_type` (`okayapi_eduwind_ew_question_type`),
    KEY `score` (`score`),
    KEY `solution` (`solution`),
    KEY `weight` (`weight`),
    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-6 of 6 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
stem	text		是
quizId	int(11)	0	否		0
okayapi_eduwind_ew_question_type	char(32)	multiple-choice	否		multiple-choice
score	decimal(7,1)	1.0	否	得分	1.0
solution	text		是
weight	int(11)	0	否		0