+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_studyabc_articles_content:/tablelist/okayapi_studyabc_articles_content.html


-- MySQL Table okayapi_studyabc_articles_content
-- From: OkayAPI.com
CREATE TABLE `okayapi_studyabc_articles_content` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `fid` int(10) NOT NULL COMMENT '',
    `englishjson` text NOT NULL COMMENT '',
    `chinesejson` text NOT NULL COMMENT '',
    `idate` date NOT NULL COMMENT '',
    KEY `fid` (`fid`),
    KEY `englishjson` (`englishjson`),
    KEY `chinesejson` (`chinesejson`),
    KEY `idate` (`idate`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '学英语社区-文章内容';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-4 of 4 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
fidint(10)Normal Index
englishjsontext
chinesejsontext
idatedate

Guess You Like

MySQL Table Design okayapi_course_apply

MySQL Table Design okayapi_studyabc_articles

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_answer

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

TOP ↑