okayapi_eduwind_ew_log - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_log：/tablelist/okayapi_eduwind_ew_log.html


-- MySQL Table okayapi_eduwind_ew_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_eduwind_ew_log_level` varchar(128) NOT NULL COMMENT '',
    `category` varchar(128) NOT NULL COMMENT '',
    `logtime` int(11) NOT NULL COMMENT '',
    `message` text NOT NULL COMMENT '',
    `userId` int(11) NOT NULL COMMENT '',
    `ip` varchar(128) NOT NULL COMMENT '写log时用户的ip',
    KEY `okayapi_eduwind_ew_log_level` (`okayapi_eduwind_ew_log_level`),
    KEY `category` (`category`),
    KEY `logtime` (`logtime`),
    KEY `message` (`message`),
    KEY `userId` (`userId`),
    KEY `ip` (`ip`),
    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	IS NULL	Field Comment
okayapi_eduwind_ew_log_level	varchar(128)	是
category	varchar(128)	是
logtime	int(11)	是
message	text	是
userId	int(11)	否
ip	varchar(128)	否	写log时用户的ip