+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_migo_sys_log:/tablelist/okayapi_migo_sys_log.html


-- MySQL Table okayapi_migo_sys_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_migo_sys_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `username` varchar(50) NULL COMMENT '用户名',
    `operation` varchar(50) NULL COMMENT '用户操作',
    `method` varchar(200) NULL COMMENT '请求方法',
    `params` varchar(5000) NULL COMMENT '请求参数',
    `ip` varchar(64) NULL COMMENT 'IP地址',
    `create_date` datetime NULL COMMENT '创建时间',
    KEY `username` (`username`),
    KEY `operation` (`operation`),
    KEY `method` (`method`),
    KEY `params` (`params`),
    KEY `ip` (`ip`),
    KEY `create_date` (`create_date`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'migo权限管理-系统日志';

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
usernamevarchar(50)用户名
operationvarchar(50)用户操作
methodvarchar(200)请求方法
paramsvarchar(5000)请求参数
ipvarchar(64)IP地址
create_datedatetime创建时间

Guess You Like

MySQL Table Design okayapi_migo_schedule_job

MySQL Table Design okayapi_migo_schedule_job_log

MySQL Table Design okayapi_migo_sys_config

MySQL Table Design okayapi_migo_sys_menu

MySQL Table Design okayapi_migo_sys_oss

MySQL Table Design okayapi_migo_sys_role

MySQL Table Design okayapi_migo_sys_role_menu

MySQL Table Design okayapi_migo_sys_user

MySQL Table Design okayapi_migo_sys_user_role

MySQL Table Design okayapi_migo_tb_token

MySQL Table Design okayapi_migo_tb_user

MySQL Table Design okayapi_rights_assign

TOP ↑