okayapi_oa_workflow_user - MySQ Table Design - OkayAPI.com

+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_oa_workflow_user：/tablelist/okayapi_oa_workflow_user.html


-- MySQL Table okayapi_oa_workflow_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_oa_workflow_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `workflow_step_id` int(11) NOT NULL COMMENT '工作流步骤的ID',
    `user_id` int(11) NOT NULL COMMENT '后台管理员的ID',
    `workflow_id` int(11) NOT NULL COMMENT '工作流ID',
    KEY `workflow_step_id` (`workflow_step_id`),
    KEY `user_id` (`user_id`),
    KEY `workflow_id` (`workflow_id`),
    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-3 of 3 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
workflow_step_id	int(11)		否	工作流步骤的ID
user_id	int(11)		否	后台管理员的ID
workflow_id	int(11)		否	工作流ID

Guess You Like

MySQL Table Design okayapi_crm_accountrecordss

MySQL Table Design okayapi_crm_announcements

MySQL Table Design okayapi_crm_caigoutuihuos

MySQL Table Design okayapi_crm_campaigns

MySQL Table Design okayapi_crm_charges

MySQL Table Design okayapi_crm_chargesrecords

MySQL Table Design okayapi_crm_checks

MySQL Table Design okayapi_crm_competitor

MySQL Table Design okayapi_crm_complaints

MySQL Table Design okayapi_crm_contacter

MySQL Table Design okayapi_crm_contactlog

MySQL Table Design okayapi_crm_customer

MySQL Table Design okayapi_crm_dailylogs

MySQL Table Design okayapi_crm_deliverys

MySQL Table Design okayapi_crm_emailgroup

MySQL Table Design okayapi_crm_emailgroupinfo

MySQL Table Design okayapi_crm_expenses

MySQL Table Design okayapi_crm_faq

MySQL Table Design okayapi_crm_faqcategory

MySQL Table Design okayapi_crm_gathers