okayapi_oa_workflow - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_oa_workflow：/tablelist/okayapi_oa_workflow.html


-- MySQL Table okayapi_oa_workflow
-- From: OkayAPI.com
CREATE TABLE `okayapi_oa_workflow` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL COMMENT '工作流的名字',
    `description` text NOT NULL COMMENT '描述',
    `code` varchar(20) NOT NULL COMMENT '调用字符串，用于与程序结合',
    `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标识：0未删除,1删除',
    KEY `name` (`name`),
    KEY `description` (`description`),
    KEY `code` (`code`),
    KEY `deleted` (`deleted`),
    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-4 of 4 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
name	varchar(255)		否	工作流的名字
description	text		否	描述
code	varchar(20)		否	调用字符串，用于与程序结合
deleted	tinyint(4)	0	否	删除标识：0未删除,1删除	0