MySQL Create Table SQL
Table Structure: okayapi_72crm_crm_business_change：/tablelist/okayapi_72crm_crm_business_change.html
-- MySQL Table okayapi_72crm_crm_business_change
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_crm_business_change` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`change_id` int(10) NOT NULL COMMENT '',
`business_id` int(10) NOT NULL COMMENT '商机ID',
`status_id` int(10) NOT NULL COMMENT '阶段ID',
`create_time` datetime NOT NULL COMMENT '创建时间',
`create_user_id` bigint(20) NOT NULL COMMENT '创建人',
KEY `change_id` (`change_id`),
KEY `business_id` (`business_id`),
KEY `status_id` (`status_id`),
KEY `create_time` (`create_time`),
KEY `create_user_id` (`create_user_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-5 of 5 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| change_id | int(10) | 否 | ||||
| business_id | int(10) | 否 | 商机ID | |||
| status_id | int(10) | 否 | 阶段ID | |||
| create_time | datetime | 否 | 创建时间 | |||
| create_user_id | bigint(20) | 否 | 创建人 |
