okayapi_72crm_work

-- MySQL Table okayapi_72crm_work
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_work` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `work_id` int(11) NULL COMMENT '项目ID',
    `okayapi_72crm_work_name` varchar(50) NULL COMMENT '项目名字',
    `okayapi_72crm_work_status` int(2) NULL DEFAULT '1' COMMENT '状态 1启用 3归档 2 删除',
    `create_time` datetime NULL COMMENT '创建时间',
    `create_user_id` bigint(20) NULL COMMENT '创建人ID',
    `description` text NULL COMMENT '描述',
    `color` varchar(15) NULL COMMENT '颜色',
    `is_open` int(2) NULL DEFAULT '1' COMMENT '是否所有人可见 1 是 0 否',
    `owner_user_id` varchar(50) NULL COMMENT '项目成员',
    `archive_time` datetime NULL COMMENT '归档时间',
    `delete_time` datetime NULL COMMENT '删除时间',
    `batch_id` varchar(32) NULL COMMENT '',
    KEY `work_id` (`work_id`),
    KEY `okayapi_72crm_work_name` (`okayapi_72crm_work_name`),
    KEY `okayapi_72crm_work_status` (`okayapi_72crm_work_status`),
    KEY `create_time` (`create_time`),
    KEY `create_user_id` (`create_user_id`),
    KEY `description` (`description`),
    KEY `color` (`color`),
    KEY `is_open` (`is_open`),
    KEY `owner_user_id` (`owner_user_id`),
    KEY `archive_time` (`archive_time`),
    KEY `delete_time` (`delete_time`),
    KEY `batch_id` (`batch_id`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CRM-项目表';

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