okayapi_oa_workflow_log - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_oa_workflow_log：/tablelist/okayapi_oa_workflow_log.html


-- MySQL Table okayapi_oa_workflow_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_oa_workflow_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `workflow_id` int(11) NULL COMMENT '工作流ID',
    `workflow_step_id` int(11) NULL COMMENT '工作流步骤',
    `user_id` int(11) NULL COMMENT '用户id',
    `status` varchar(255) NULL COMMENT '状态,Y通过，N未通过,',
    `mark` tinytext NULL COMMENT '备注',
    KEY `workflow_id` (`workflow_id`),
    KEY `workflow_step_id` (`workflow_step_id`),
    KEY `user_id` (`user_id`),
    KEY `status` (`status`),
    KEY `mark` (`mark`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CRM-工作流历史记录表';

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	IS NULL	Field Comment
workflow_id	int(11)	是	工作流ID
workflow_step_id	int(11)	是	工作流步骤
user_id	int(11)	是	用户id
status	varchar(255)	是	状态,Y通过，N未通过,
mark	tinytext	是	备注