okayapi_72crm_crm_business_status - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_72crm_crm_business_status：/tablelist/okayapi_72crm_crm_business_status.html


-- MySQL Table okayapi_72crm_crm_business_status
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_crm_business_status` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `status_id` int(11) NULL COMMENT '',
    `type_id` int(11) NULL COMMENT '商机状态类别ID',
    `okayapi_72crm_crm_business_status_name` varchar(50) NULL COMMENT '标识',
    `rate` varchar(20) NULL COMMENT '赢单率',
    `order_num` int(4) NULL COMMENT '排序',
    KEY `status_id` (`status_id`),
    KEY `type_id` (`type_id`),
    KEY `okayapi_72crm_crm_business_status_name` (`okayapi_72crm_crm_business_status_name`),
    KEY `rate` (`rate`),
    KEY `order_num` (`order_num`),
    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
status_id	int(11)	否
type_id	int(11)	否	商机状态类别ID
okayapi_72crm_crm_business_status_name	varchar(50)	否	标识
rate	varchar(20)	是	赢单率
order_num	int(4)	是	排序