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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
description | varchar(100) | 是 | 操作描述 | |||
username | varchar(20) | 是 | 操作用户 | |||
start_time | bigint(20) | 是 | 操作时间 | |||
spend_time | int(11) | 是 | 消耗时间 | |||
base_path | varchar(500) | 是 | 根路径 | |||
uri | varchar(500) | 是 | URI | |||
url | varchar(500) | 是 | URL | |||
method | varchar(10) | 是 | 请求类型 | |||
parameter | mediumtext | 是 | ||||
user_agent | varchar(500) | 是 | 用户标识 | |||
ip | varchar(30) | 是 | IP地址 | |||
result | mediumtext | 是 | ||||
permissions | varchar(100) | 是 | 权限值 |