+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_group:/tablelist/okayapi_eduwind_ew_group.html


-- MySQL Table okayapi_eduwind_ew_group
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_group` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_eduwind_ew_group_name` char(64) NOT NULL COMMENT '名称',
    `face` char(255) NOT NULL COMMENT '头像存放位置',
    `userId` int(11) NOT NULL COMMENT '小组创建人id',
    `addTime` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
    `introduction` text NOT NULL COMMENT '课程简介',
    `okayapi_eduwind_ew_group_status` char(32) NOT NULL COMMENT '状态,ok,applied,created',
    `memberNum` int(11) NOT NULL DEFAULT '0' COMMENT '人数',
    `viewNum` int(11) NOT NULL DEFAULT '0' COMMENT '点击量',
    `postableEntityId` int(11) NOT NULL COMMENT '发帖对象id',
    `joinType` char(32) NOT NULL DEFAULT 'free' COMMENT '加入方式:apply,free',
    `entityId` int(11) NOT NULL DEFAULT '0' COMMENT 'Entity对象Id',
    `isTop` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否推荐',
    `categoryId` int(11) NOT NULL DEFAULT '0' COMMENT '分类',
    `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `deleteTime` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `leaderTitle` char(32) NOT NULL DEFAULT '组长' COMMENT '',
    `memberTitle` char(32) NOT NULL DEFAULT '成员' COMMENT '',
    `adminTitle` char(32) NOT NULL DEFAULT '管理员' COMMENT '',
    KEY `okayapi_eduwind_ew_group_name` (`okayapi_eduwind_ew_group_name`),
    KEY `face` (`face`),
    KEY `userId` (`userId`),
    KEY `addTime` (`addTime`),
    KEY `introduction` (`introduction`),
    KEY `okayapi_eduwind_ew_group_status` (`okayapi_eduwind_ew_group_status`),
    KEY `memberNum` (`memberNum`),
    KEY `viewNum` (`viewNum`),
    KEY `postableEntityId` (`postableEntityId`),
    KEY `joinType` (`joinType`),
    KEY `entityId` (`entityId`),
    KEY `isTop` (`isTop`),
    KEY `categoryId` (`categoryId`),
    KEY `deleted` (`deleted`),
    KEY `deleteTime` (`deleteTime`),
    KEY `leaderTitle` (`leaderTitle`),
    KEY `memberTitle` (`memberTitle`),
    KEY `adminTitle` (`adminTitle`),
    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-18 of 18 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
okayapi_eduwind_ew_group_namechar(64)名称
facechar(255)头像存放位置
userIdint(11)小组创建人idNormal Index
addTimeint(11)0添加时间0
introductiontext课程简介
okayapi_eduwind_ew_group_statuschar(32)状态,ok,applied,created
memberNumint(11)0人数0
viewNumint(11)0点击量0
postableEntityIdint(11)发帖对象idUnique Index
joinTypechar(32)free加入方式:apply,freefree
entityIdint(11)0Entity对象Id0
isToptinyint(4)0是否推荐0
categoryIdint(11)0分类0
deletedtinyint(1)00
deleteTimeint(11)00
leaderTitlechar(32)组长组长
memberTitlechar(32)成员成员
adminTitlechar(32)管理员管理员

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_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

TOP ↑