MySQL Create Table SQL
Table Structure: okayapi_f_base_log_info：/tablelist/okayapi_f_base_log_info.html
-- MySQL Table okayapi_f_base_log_info
-- From: OkayAPI.com
CREATE TABLE `okayapi_f_base_log_info` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`create_time` datetime NULL COMMENT '',
`ip_address` varchar(16) NULL COMMENT '',
`log_level` varchar(16) NULL COMMENT '',
`message` varchar(256) NULL COMMENT '',
`username` varchar(32) NULL COMMENT '',
KEY `create_time` (`create_time`),
KEY `ip_address` (`ip_address`),
KEY `log_level` (`log_level`),
KEY `message` (`message`),
KEY `username` (`username`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '财务管理-日志信息';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-5 of 5 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| create_time | datetime | 是 | ||||
| ip_address | varchar(16) | 是 | ||||
| log_level | varchar(16) | 是 | ||||
| message | varchar(256) | 是 | ||||
| username | varchar(32) | 是 |
