MySQL Create Table SQL
Table Structure: okayapi_appver_operation_record_log:/tablelist/okayapi_appver_operation_record_log.html
-- MySQL Table okayapi_appver_operation_record_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_appver_operation_record_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`operator` varchar(32) NOT NULL COMMENT '操作者',
`app_id` int(10) NOT NULL DEFAULT '0' COMMENT '被操作的appid',
`operation_resource` varchar(32) NOT NULL COMMENT '被操作的资源,通常为表名',
`operation_type` varchar(32) NOT NULL COMMENT '操作类型:增删改查',
`operation_description` varchar(32) NOT NULL COMMENT '操作内容的中文描述',
`operation_content` text NOT NULL COMMENT '操作的数据内容',
`operation_result` varchar(32) NOT NULL COMMENT '操作结果:成功、失败',
`result_message` varchar(255) NOT NULL COMMENT '操作返回内容',
`created_by` varchar(32) NOT NULL COMMENT '',
`updated_by` varchar(32) NOT NULL COMMENT '更新人',
`del_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
KEY `operator` (`operator`),
KEY `app_id` (`app_id`),
KEY `operation_resource` (`operation_resource`),
KEY `operation_type` (`operation_type`),
KEY `operation_description` (`operation_description`),
KEY `operation_content` (`operation_content`),
KEY `operation_result` (`operation_result`),
KEY `result_message` (`result_message`),
KEY `created_by` (`created_by`),
KEY `updated_by` (`updated_by`),
KEY `del_flag` (`del_flag`),
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-11 of 11 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
operator | varchar(32) | 否 | 操作者 | |||
app_id | int(10) | 0 | 否 | 被操作的appid | 0 | |
operation_resource | varchar(32) | 否 | 被操作的资源,通常为表名 | |||
operation_type | varchar(32) | 否 | 操作类型:增删改查 | |||
operation_description | varchar(32) | 否 | 操作内容的中文描述 | |||
operation_content | text | 否 | 操作的数据内容 | |||
operation_result | varchar(32) | 否 | 操作结果:成功、失败 | |||
result_message | varchar(255) | 否 | 操作返回内容 | |||
created_by | varchar(32) | 否 | ||||
updated_by | varchar(32) | 否 | 更新人 | |||
del_flag | tinyint(1) | 0 | 否 | 是否删除 | 0 |