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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_eduwind_ew_group_name | char(64) | 否 | 名称 | |||
face | char(255) | 否 | 头像存放位置 | |||
userId | int(11) | 否 | 小组创建人id | Normal Index | ||
addTime | int(11) | 0 | 否 | 添加时间 | 0 | |
introduction | text | 是 | 课程简介 | |||
okayapi_eduwind_ew_group_status | char(32) | 否 | 状态,ok,applied,created | |||
memberNum | int(11) | 0 | 否 | 人数 | 0 | |
viewNum | int(11) | 0 | 否 | 点击量 | 0 | |
postableEntityId | int(11) | 是 | 发帖对象id | Unique Index | ||
joinType | char(32) | free | 否 | 加入方式:apply,free | free | |
entityId | int(11) | 0 | 否 | Entity对象Id | 0 | |
isTop | tinyint(4) | 0 | 否 | 是否推荐 | 0 | |
categoryId | int(11) | 0 | 否 | 分类 | 0 | |
deleted | tinyint(1) | 0 | 否 | 0 | ||
deleteTime | int(11) | 0 | 否 | 0 | ||
leaderTitle | char(32) | 组长 | 否 | 组长 | ||
memberTitle | char(32) | 成员 | 否 | 成员 | ||
adminTitle | char(32) | 管理员 | 否 | 管理员 |