+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
operatorvarchar(32)操作者
app_idint(10)0被操作的appid0
operation_resourcevarchar(32)被操作的资源,通常为表名
operation_typevarchar(32)操作类型:增删改查
operation_descriptionvarchar(32)操作内容的中文描述
operation_contenttext操作的数据内容
operation_resultvarchar(32)操作结果:成功、失败
result_messagevarchar(255)操作返回内容
created_byvarchar(32)
updated_byvarchar(32)更新人
del_flagtinyint(1)0是否删除0

Guess You Like

MySQL Table Design okayapi_appver_access_log

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_rn_package

MySQL Table Design okayapi_appver_rn_route

MySQL Table Design okayapi_appver_user

MySQL Table Design okayapi_appver_user_app_rel

TOP ↑