okayapi_eduwind_ew_answer - MySQ Table Design - OkayAPI.com

+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_answer：/tablelist/okayapi_eduwind_ew_answer.html


-- MySQL Table okayapi_eduwind_ew_answer
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_answer` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `userId` int(11) NOT NULL COMMENT '',
    `questionId` int(11) NOT NULL COMMENT '',
    `content` text NOT NULL COMMENT '',
    `addTime` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `weight` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `isCorrect` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    KEY `userId` (`userId`),
    KEY `questionId` (`questionId`),
    KEY `content` (`content`),
    KEY `addTime` (`addTime`),
    KEY `weight` (`weight`),
    KEY `isCorrect` (`isCorrect`),
    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	Index	Demo Data
userId	int(11)		否
questionId	int(11)		否
content	text		是
addTime	int(11)	0	否			0
weight	int(11)	0	否			0
isCorrect	tinyint(1)	0	否			0

Guess You Like

MySQL Table Design okayapi_course_apply

MySQL Table Design okayapi_studyabc_articles

MySQL Table Design okayapi_studyabc_articles_content

MySQL Table Design okayapi_studyabc_cet

MySQL Table Design okayapi_studyabc_cetdesc

MySQL Table Design okayapi_studyabc_tinyenglish

MySQL Table Design okayapi_eduwind_AuthAssignment

MySQL Table Design okayapi_eduwind_AuthItem

MySQL Table Design okayapi_eduwind_AuthItemChild

MySQL Table Design okayapi_eduwind_Rights

MySQL Table Design okayapi_eduwind_YiiSession

MySQL Table Design okayapi_eduwind_ew_announcement

MySQL Table Design okayapi_eduwind_ew_area

MySQL Table Design okayapi_eduwind_ew_article

MySQL Table Design okayapi_eduwind_ew_bottom_text

MySQL Table Design okayapi_eduwind_ew_carousel

MySQL Table Design okayapi_eduwind_ew_category

MySQL Table Design okayapi_eduwind_ew_chapter

MySQL Table Design okayapi_eduwind_ew_city

MySQL Table Design okayapi_eduwind_ew_cms_people