+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_qi_ace_sys_log:/tablelist/okayapi_qi_ace_sys_log.html


-- MySQL Table okayapi_qi_ace_sys_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_qi_ace_sys_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_qi_ace_sys_log_type` char(1) NULL DEFAULT '1' COMMENT '日志类型',
    `title` varchar(255) NULL COMMENT '日志标题',
    `service_id` varchar(32) NULL COMMENT '服务ID',
    `create_by` varchar(64) NULL COMMENT '创建者',
    `create_time` datetime NULL COMMENT '创建时间',
    `remote_addr` varchar(255) NULL COMMENT '操作IP地址',
    `user_agent` varchar(1000) NULL COMMENT '用户代理',
    `request_uri` varchar(255) NULL COMMENT '请求URI',
    `method` varchar(10) NULL COMMENT '操作方式',
    `params` text NULL COMMENT '操作提交的数据',
    `okayapi_qi_ace_sys_log_time` mediumtext NULL COMMENT '执行时间',
    `del_flag` char(1) NULL DEFAULT '0' COMMENT '删除标记',
    `exception` text NULL COMMENT '异常信息',
    KEY `okayapi_qi_ace_sys_log_type` (`okayapi_qi_ace_sys_log_type`),
    KEY `title` (`title`),
    KEY `service_id` (`service_id`),
    KEY `create_by` (`create_by`),
    KEY `create_time` (`create_time`),
    KEY `remote_addr` (`remote_addr`),
    KEY `user_agent` (`user_agent`),
    KEY `request_uri` (`request_uri`),
    KEY `method` (`method`),
    KEY `params` (`params`),
    KEY `okayapi_qi_ace_sys_log_time` (`okayapi_qi_ace_sys_log_time`),
    KEY `del_flag` (`del_flag`),
    KEY `exception` (`exception`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'qi后台管理系统-日志表';

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


MySQL database table structure design

Displaying 1-13 of 13 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
okayapi_qi_ace_sys_log_typechar(1)1日志类型Normal Index1
titlevarchar(255)日志标题
service_idvarchar(32)服务ID
create_byvarchar(64)创建者Normal Index
create_timedatetime创建时间Normal Index
remote_addrvarchar(255)操作IP地址
user_agentvarchar(1000)用户代理
request_urivarchar(255)请求URINormal Index
methodvarchar(10)操作方式
paramstext操作提交的数据
okayapi_qi_ace_sys_log_timemediumtext执行时间
del_flagchar(1)0删除标记0
exceptiontext异常信息

Guess You Like

MySQL Table Design okayapi_qi_ace_sys_dept_relation

MySQL Table Design okayapi_qi_ace_sys_oauth_client_details

MySQL Table Design okayapi_qi_ace_sys_role_menu

MySQL Table Design okayapi_qi_ace_base_group

MySQL Table Design okayapi_qi_ace_base_group_leader

MySQL Table Design okayapi_qi_ace_base_group_member

MySQL Table Design okayapi_qi_ace_base_group_type

MySQL Table Design okayapi_qi_ace_base_menu

MySQL Table Design okayapi_qi_ace_base_resource_authority

MySQL Table Design okayapi_qi_ace_base_user

MySQL Table Design okayapi_qi_ace_gate_log

MySQL Table Design okayapi_qi_ace_auth_client

MySQL Table Design okayapi_qi_ace_auth_client_service

MySQL Table Design okayapi_qi_ace_sys_dict

MySQL Table Design okayapi_qi_ace_sys_dict_item

MySQL Table Design okayapi_qi_ace_sys_menu

TOP ↑