okayapi_eduwind_ew_group_member - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_group_member：/tablelist/okayapi_eduwind_ew_group_member.html


-- MySQL Table okayapi_eduwind_ew_group_member
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_group_member` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `userId` int(11) NOT NULL COMMENT '发表者id',
    `memberableEntityId` int(11) NOT NULL DEFAULT '0' COMMENT '拥有成员的entity',
    `addTime` int(11) NOT NULL DEFAULT '0' COMMENT '加入时间',
    `upTime` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
    `roles` char(64) NOT NULL COMMENT '角色组',
    `groupId` int(11) NOT NULL DEFAULT '0' COMMENT '',
    KEY `userId` (`userId`),
    KEY `memberableEntityId` (`memberableEntityId`),
    KEY `addTime` (`addTime`),
    KEY `upTime` (`upTime`),
    KEY `roles` (`roles`),
    KEY `groupId` (`groupId`),
    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)		否	发表者id	Normal Index
memberableEntityId	int(11)	0	否	拥有成员的entity		0
addTime	int(11)	0	是	加入时间		0
upTime	int(11)	0	是	更新时间		0
roles	char(64)		否	角色组
groupId	int(11)	0	否			0