+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_ry_sys_oper_log:/tablelist/okayapi_ry_sys_oper_log.html


-- MySQL Table okayapi_ry_sys_oper_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_ry_sys_oper_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `oper_id` bigint(20) NULL COMMENT '日志主键',
    `title` varchar(50) NULL COMMENT '模块标题',
    `business_type` int(2) NULL DEFAULT '0' COMMENT '业务类型(0其它 1新增 2修改 3删除)',
    `method` varchar(100) NULL COMMENT '方法名称',
    `request_method` varchar(10) NULL COMMENT '请求方式',
    `operator_type` int(1) NULL DEFAULT '0' COMMENT '操作类别(0其它 1后台用户 2手机端用户)',
    `oper_name` varchar(50) NULL COMMENT '操作人员',
    `dept_name` varchar(50) NULL COMMENT '部门名称',
    `oper_url` varchar(255) NULL COMMENT '请求URL',
    `oper_ip` varchar(128) NULL COMMENT '主机地址',
    `oper_location` varchar(255) NULL COMMENT '操作地点',
    `oper_param` varchar(2000) NULL COMMENT '请求参数',
    `json_result` varchar(2000) NULL COMMENT '返回参数',
    `okayapi_ry_sys_oper_log_status` int(1) NULL DEFAULT '0' COMMENT '操作状态(0正常 1异常)',
    `error_msg` varchar(2000) NULL COMMENT '错误消息',
    `oper_time` datetime NULL COMMENT '操作时间',
    KEY `oper_id` (`oper_id`),
    KEY `title` (`title`),
    KEY `business_type` (`business_type`),
    KEY `method` (`method`),
    KEY `request_method` (`request_method`),
    KEY `operator_type` (`operator_type`),
    KEY `oper_name` (`oper_name`),
    KEY `dept_name` (`dept_name`),
    KEY `oper_url` (`oper_url`),
    KEY `oper_ip` (`oper_ip`),
    KEY `oper_location` (`oper_location`),
    KEY `oper_param` (`oper_param`),
    KEY `json_result` (`json_result`),
    KEY `okayapi_ry_sys_oper_log_status` (`okayapi_ry_sys_oper_log_status`),
    KEY `error_msg` (`error_msg`),
    KEY `oper_time` (`oper_time`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'RuoYi后台管理系统-操作日志记录';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-16 of 16 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
oper_idbigint(20)日志主键
titlevarchar(50)模块标题
business_typeint(2)0业务类型(0其它 1新增 2修改 3删除)0
methodvarchar(100)方法名称
request_methodvarchar(10)请求方式
operator_typeint(1)0操作类别(0其它 1后台用户 2手机端用户)0
oper_namevarchar(50)操作人员
dept_namevarchar(50)部门名称
oper_urlvarchar(255)请求URL
oper_ipvarchar(128)主机地址
oper_locationvarchar(255)操作地点
oper_paramvarchar(2000)请求参数
json_resultvarchar(2000)返回参数
okayapi_ry_sys_oper_log_statusint(1)0操作状态(0正常 1异常)0
error_msgvarchar(2000)错误消息
oper_timedatetime操作时间

Guess You Like

MySQL Table Design okayapi_ry_sys_dept

MySQL Table Design okayapi_ry_sys_user

MySQL Table Design okayapi_ry_sys_post

MySQL Table Design okayapi_ry_sys_role

MySQL Table Design okayapi_ry_sys_menu

MySQL Table Design okayapi_ry_sys_user_role

MySQL Table Design okayapi_ry_sys_role_menu

MySQL Table Design okayapi_ry_sys_role_dept

MySQL Table Design okayapi_ry_sys_user_post

MySQL Table Design okayapi_ry_sys_dict_type

MySQL Table Design okayapi_ry_sys_dict_data

MySQL Table Design okayapi_ry_sys_config

MySQL Table Design okayapi_ry_sys_logininfor

MySQL Table Design okayapi_ry_sys_user_online

MySQL Table Design okayapi_ry_sys_job

MySQL Table Design okayapi_ry_sys_job_log

MySQL Table Design okayapi_ry_sys_notice

MySQL Table Design okayapi_ry_gen_table

MySQL Table Design okayapi_ry_gen_table_column

TOP ↑