okayapi_72crm_crm_business_type - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_72crm_crm_business_type：/tablelist/okayapi_72crm_crm_business_type.html


-- MySQL Table okayapi_72crm_crm_business_type
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_crm_business_type` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `type_id` int(11) NOT NULL COMMENT '',
    `okayapi_72crm_crm_business_type_name` varchar(50) NOT NULL COMMENT '标识',
    `dept_ids` varchar(255) NOT NULL COMMENT '部门ID',
    `create_user_id` bigint(20) NOT NULL COMMENT '创建人ID',
    `create_time` datetime NOT NULL COMMENT '创建时间',
    `okayapi_72crm_crm_business_type_status` int(1) NOT NULL DEFAULT '1' COMMENT '1启用0禁用',
    KEY `type_id` (`type_id`),
    KEY `okayapi_72crm_crm_business_type_name` (`okayapi_72crm_crm_business_type_name`),
    KEY `dept_ids` (`dept_ids`),
    KEY `create_user_id` (`create_user_id`),
    KEY `create_time` (`create_time`),
    KEY `okayapi_72crm_crm_business_type_status` (`okayapi_72crm_crm_business_type_status`),
    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-6 of 6 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
type_id	int(11)		否
okayapi_72crm_crm_business_type_name	varchar(50)		否	标识
dept_ids	varchar(255)		否	部门ID
create_user_id	bigint(20)		否	创建人ID
create_time	datetime		否	创建时间
okayapi_72crm_crm_business_type_status	int(1)	1	否	1启用0禁用	1