+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_framework_log:/tablelist/okayapi_framework_log.html


-- MySQL Table okayapi_framework_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_framework_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `member_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
    `method` varchar(20) NOT NULL COMMENT '提交类型',
    `module` varchar(50) NOT NULL COMMENT '模块',
    `controller` varchar(50) NOT NULL COMMENT '控制器',
    `action` varchar(50) NOT NULL COMMENT '方法',
    `url` varchar(1000) NOT NULL COMMENT '提交url',
    `get_data` text NOT NULL COMMENT 'get数据',
    `post_data` longtext NOT NULL COMMENT 'post数据',
    `ip` varchar(16) NOT NULL COMMENT 'ip地址',
    `error_code` int(10) NOT NULL DEFAULT '0' COMMENT '报错code',
    `error_msg` varchar(200) NOT NULL COMMENT '报错信息',
    `error_data` longtext NOT NULL COMMENT '报错日志',
    `req_id` varchar(50) NOT NULL COMMENT '对外id',
    `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态(-1:已删除,0:禁用,1:正常)',
    KEY `member_id` (`member_id`),
    KEY `method` (`method`),
    KEY `module` (`module`),
    KEY `controller` (`controller`),
    KEY `action` (`action`),
    KEY `url` (`url`),
    KEY `get_data` (`get_data`),
    KEY `post_data` (`post_data`),
    KEY `ip` (`ip`),
    KEY `error_code` (`error_code`),
    KEY `error_msg` (`error_msg`),
    KEY `error_data` (`error_data`),
    KEY `req_id` (`req_id`),
    KEY `status` (`status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'api接口日志';

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


MySQL database table structure design

Displaying 1-14 of 14 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
member_idint(11)0用户id0
methodvarchar(20)提交类型
modulevarchar(50)模块
controllervarchar(50)控制器
actionvarchar(50)方法
urlvarchar(1000)提交url
get_datatextget数据
post_datalongtextpost数据
ipvarchar(16)ip地址
error_codeint(10)0报错codeNormal Index0
error_msgvarchar(200)报错信息
error_datalongtext报错日志
req_idvarchar(50)对外idNormal Index
statustinyint(4)1状态(-1:已删除,0:禁用,1:正常)1

Guess You Like

MySQL Table Design okayapi_file_uploads

MySQL Table Design okayapi_provinces_log

MySQL Table Design okayapi_sms_log

MySQL Table Design okayapi_member_datas_log

MySQL Table Design okayapi_member_vip

MySQL Table Design okayapi_sys_message

MySQL Table Design okayapi_sys_notice_manage

MySQL Table Design okayapi_sys_menu_manage

MySQL Table Design okayapi_sys_config_manage

MySQL Table Design okayapi_sys_addon_manage

MySQL Table Design okayapi_server_manage

TOP ↑