+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_appver_access_log:/tablelist/okayapi_appver_access_log.html


-- MySQL Table okayapi_appver_access_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_appver_access_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `api` varchar(128) NULL COMMENT '接口名',
    `api_description` varchar(255) NULL COMMENT '接口中文描述',
    `api_args` varchar(255) NULL COMMENT '接口入参',
    `return_code` int(8) NULL DEFAULT '0' COMMENT '接口返回code',
    `return_message` varchar(255) NULL COMMENT '接口返回信息',
    `req_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '访问时间',
    `req_isp` varchar(128) NULL COMMENT '访问运营商',
    `req_city` varchar(128) NULL COMMENT '城市',
    `req_city_id` varchar(10) NULL COMMENT '城市ID',
    `req_region` varchar(128) NULL COMMENT '访问省份',
    `req_region_id` varchar(10) NULL COMMENT '省份ID',
    `req_country` varchar(128) NULL COMMENT '访问国家',
    `req_country_id` varchar(10) NULL COMMENT '国家ID',
    `req_area` varchar(128) NULL COMMENT '访问区域',
    `req_os` varchar(128) NULL COMMENT '访问的操作系统',
    `req_browser` varchar(128) NULL COMMENT '访问的浏览器',
    `req_device` varchar(128) NULL COMMENT '设备型号',
    `req_ua` varchar(516) NULL COMMENT '请求时的userAgent',
    KEY `api` (`api`),
    KEY `api_description` (`api_description`),
    KEY `api_args` (`api_args`),
    KEY `return_code` (`return_code`),
    KEY `return_message` (`return_message`),
    KEY `req_time` (`req_time`),
    KEY `req_isp` (`req_isp`),
    KEY `req_city` (`req_city`),
    KEY `req_city_id` (`req_city_id`),
    KEY `req_region` (`req_region`),
    KEY `req_region_id` (`req_region_id`),
    KEY `req_country` (`req_country`),
    KEY `req_country_id` (`req_country_id`),
    KEY `req_area` (`req_area`),
    KEY `req_os` (`req_os`),
    KEY `req_browser` (`req_browser`),
    KEY `req_device` (`req_device`),
    KEY `req_ua` (`req_ua`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'App版本管理-版本访问日志';

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


MySQL database table structure design

Displaying 1-18 of 18 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
apivarchar(128)接口名
api_descriptionvarchar(255)接口中文描述
api_argsvarchar(255)接口入参
return_codeint(8)0接口返回code0
return_messagevarchar(255)接口返回信息
req_timetimestampCURRENT_TIMESTAMP访问时间CURRENT_TIMESTAMP
req_ispvarchar(128)访问运营商
req_cityvarchar(128)城市
req_city_idvarchar(10)城市ID
req_regionvarchar(128)访问省份
req_region_idvarchar(10)省份ID
req_countryvarchar(128)访问国家
req_country_idvarchar(10)国家ID
req_areavarchar(128)访问区域
req_osvarchar(128)访问的操作系统
req_browservarchar(128)访问的浏览器
req_devicevarchar(128)设备型号
req_uavarchar(516)请求时的userAgent

Guess You Like

MySQL Table Design okayapi_appver_android_version

MySQL Table Design okayapi_appver_apk

MySQL Table Design okayapi_appver_apk_download_record

MySQL Table Design okayapi_appver_app

MySQL Table Design okayapi_appver_channel

MySQL Table Design okayapi_appver_chat_bot

MySQL Table Design okayapi_appver_custom_api

MySQL Table Design okayapi_appver_ios_version

MySQL Table Design okayapi_appver_operation_record_log

MySQL Table Design okayapi_appver_rn_package

MySQL Table Design okayapi_appver_rn_route

MySQL Table Design okayapi_appver_user

MySQL Table Design okayapi_appver_user_app_rel

TOP ↑