+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_zheng_upms_log:/tablelist/okayapi_zheng_upms_log.html


-- MySQL Table okayapi_zheng_upms_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_zheng_upms_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `description` varchar(100) NULL COMMENT '操作描述',
    `username` varchar(20) NULL COMMENT '操作用户',
    `start_time` bigint(20) NULL COMMENT '操作时间',
    `spend_time` int(11) NULL COMMENT '消耗时间',
    `base_path` varchar(500) NULL COMMENT '根路径',
    `uri` varchar(500) NULL COMMENT 'URI',
    `url` varchar(500) NULL COMMENT 'URL',
    `method` varchar(10) NULL COMMENT '请求类型',
    `parameter` mediumtext NULL COMMENT '',
    `user_agent` varchar(500) NULL COMMENT '用户标识',
    `ip` varchar(30) NULL COMMENT 'IP地址',
    `result` mediumtext NULL COMMENT '',
    `permissions` varchar(100) NULL COMMENT '权限值',
    KEY `description` (`description`),
    KEY `username` (`username`),
    KEY `start_time` (`start_time`),
    KEY `spend_time` (`spend_time`),
    KEY `base_path` (`base_path`),
    KEY `uri` (`uri`),
    KEY `url` (`url`),
    KEY `method` (`method`),
    KEY `parameter` (`parameter`),
    KEY `user_agent` (`user_agent`),
    KEY `ip` (`ip`),
    KEY `result` (`result`),
    KEY `permissions` (`permissions`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'zheng敏捷开发-操作日志';

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
descriptionvarchar(100)操作描述
usernamevarchar(20)操作用户
start_timebigint(20)操作时间
spend_timeint(11)消耗时间
base_pathvarchar(500)根路径
urivarchar(500)URI
urlvarchar(500)URL
methodvarchar(10)请求类型
parametermediumtext
user_agentvarchar(500)用户标识
ipvarchar(30)IP地址
resultmediumtext
permissionsvarchar(100)权限值

Guess You Like

MySQL Table Design okayapi_logs

MySQL Table Design okayapi_app_version

MySQL Table Design okayapi_tea

MySQL Table Design okayapi_tea_swiper

MySQL Table Design okayapi_tea_moment

MySQL Table Design okayapi_tea_order

MySQL Table Design okayapi_tea_user

MySQL Table Design okayapi_tea_shopcar

MySQL Table Design okayapi_zheng_cms_article

MySQL Table Design okayapi_zheng_cms_article_category

MySQL Table Design okayapi_zheng_cms_article_tag

MySQL Table Design okayapi_zheng_cms_category

MySQL Table Design okayapi_zheng_cms_comment

MySQL Table Design okayapi_zheng_cms_page

MySQL Table Design okayapi_zheng_cms_setting

MySQL Table Design okayapi_zheng_cms_system

MySQL Table Design okayapi_zheng_cms_tag

MySQL Table Design okayapi_zheng_cms_topic

MySQL Table Design okayapi_zheng_pay_in_order

MySQL Table Design okayapi_zheng_pay_in_order_detail

TOP ↑