okayapi_jsh_log - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_jsh_log：/tablelist/okayapi_jsh_log.html


-- MySQL Table okayapi_jsh_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_jsh_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `userID` bigint(20) NULL COMMENT '操作用户ID',
    `operation` varchar(500) NULL COMMENT '操作模块名称',
    `clientIP` varchar(50) NULL COMMENT '客户端IP',
    `createtime` datetime NULL COMMENT '创建时间',
    `status` tinyint(4) NULL COMMENT '操作状态 0==成功，1==失败',
    `contentdetails` varchar(1000) NULL COMMENT '操作详情',
    `remark` varchar(500) NULL COMMENT '备注信息',
    `tenant_id` bigint(20) NULL COMMENT '租户id',
    KEY `userID` (`userID`),
    KEY `operation` (`operation`),
    KEY `clientIP` (`clientIP`),
    KEY `createtime` (`createtime`),
    KEY `status` (`status`),
    KEY `contentdetails` (`contentdetails`),
    KEY `remark` (`remark`),
    KEY `tenant_id` (`tenant_id`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ERP进销存-操作日志';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-8 of 8 results.

Field Name	Field Type	IS NULL	Field Comment	Index
userID	bigint(20)	否	操作用户ID	Normal Index
operation	varchar(500)	是	操作模块名称
clientIP	varchar(50)	是	客户端IP
createtime	datetime	是	创建时间
status	tinyint(4)	是	操作状态 0==成功，1==失败
contentdetails	varchar(1000)	是	操作详情
remark	varchar(500)	是	备注信息
tenant_id	bigint(20)	是	租户id