MySQL Create Table SQL
Table Structure: okayapi_72crm_crm_customer_stats：/tablelist/okayapi_72crm_crm_customer_stats.html
-- MySQL Table okayapi_72crm_crm_customer_stats
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_crm_customer_stats` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NOT NULL COMMENT '用户id',
`customer_num` int(10) NOT NULL DEFAULT '0' COMMENT '客户总数',
`create_time` datetime NOT NULL COMMENT '统计时间',
KEY `user_id` (`user_id`),
KEY `customer_num` (`customer_num`),
KEY `create_time` (`create_time`),
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 |
|---|---|---|---|---|---|---|
| user_id | bigint(20) | 否 | 用户id | |||
| customer_num | int(10) | 0 | 否 | 客户总数 | 0 | |
| create_time | datetime | 否 | 统计时间 |
