MySQL Create Table SQL
Table Structure: okayapi_72crm_crm_customer:/tablelist/okayapi_72crm_crm_customer.html
-- MySQL Table okayapi_72crm_crm_customer
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_crm_customer` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`customer_id` int(11) NULL COMMENT '',
`customer_name` varchar(255) NULL COMMENT '客户名称',
`followup` int(11) NULL COMMENT '跟进状态 0未跟进1已跟进',
`is_lock` int(1) NULL DEFAULT '0' COMMENT '1锁定',
`next_time` datetime NULL COMMENT '下次联系时间',
`deal_status` int(4) NULL DEFAULT '0' COMMENT '成交状态 0未成交 1已成交',
`mobile` varchar(255) NULL COMMENT '手机',
`telephone` varchar(255) NULL COMMENT '电话',
`website` varchar(500) NULL COMMENT '网址',
`remark` varchar(500) NULL COMMENT '备注',
`create_user_id` bigint(20) NULL COMMENT '创建人ID',
`owner_user_id` bigint(20) NULL COMMENT '负责人ID',
`ro_user_id` longtext NULL COMMENT '只读权限',
`rw_user_id` longtext NULL COMMENT '读写权限',
`address` varchar(255) NULL COMMENT '省市区',
`location` varchar(255) NULL COMMENT '定位信息',
`detail_address` varchar(255) NULL COMMENT '详细地址',
`lng` varchar(255) NULL COMMENT '地理位置经度',
`lat` varchar(255) NULL COMMENT '地理位置维度',
`create_time` datetime NULL COMMENT '创建时间',
`batch_id` varchar(32) NULL COMMENT '批次 比如附件批次',
`last_content` varchar(1024) NULL COMMENT '',
KEY `customer_id` (`customer_id`),
KEY `customer_name` (`customer_name`),
KEY `followup` (`followup`),
KEY `is_lock` (`is_lock`),
KEY `next_time` (`next_time`),
KEY `deal_status` (`deal_status`),
KEY `mobile` (`mobile`),
KEY `telephone` (`telephone`),
KEY `website` (`website`),
KEY `remark` (`remark`),
KEY `create_user_id` (`create_user_id`),
KEY `owner_user_id` (`owner_user_id`),
KEY `ro_user_id` (`ro_user_id`),
KEY `rw_user_id` (`rw_user_id`),
KEY `address` (`address`),
KEY `location` (`location`),
KEY `detail_address` (`detail_address`),
KEY `lng` (`lng`),
KEY `lat` (`lat`),
KEY `create_time` (`create_time`),
KEY `batch_id` (`batch_id`),
KEY `last_content` (`last_content`),
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-22 of 22 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
customer_id | int(11) | 否 | ||||
customer_name | varchar(255) | 否 | 客户名称 | |||
followup | int(11) | 是 | 跟进状态 0未跟进1已跟进 | |||
is_lock | int(1) | 0 | 否 | 1锁定 | 0 | |
next_time | datetime | 是 | 下次联系时间 | |||
deal_status | int(4) | 0 | 否 | 成交状态 0未成交 1已成交 | 0 | |
mobile | varchar(255) | 是 | 手机 | |||
telephone | varchar(255) | 是 | 电话 | |||
website | varchar(500) | 是 | 网址 | |||
remark | varchar(500) | 是 | 备注 | |||
create_user_id | bigint(20) | 是 | 创建人ID | |||
owner_user_id | bigint(20) | 是 | 负责人ID | |||
ro_user_id | longtext | 是 | 只读权限 | |||
rw_user_id | longtext | 是 | 读写权限 | |||
address | varchar(255) | 是 | 省市区 | |||
location | varchar(255) | 是 | 定位信息 | |||
detail_address | varchar(255) | 是 | 详细地址 | |||
lng | varchar(255) | 是 | 地理位置经度 | |||
lat | varchar(255) | 是 | 地理位置维度 | |||
create_time | datetime | 否 | 创建时间 | |||
batch_id | varchar(32) | 否 | 批次 比如附件批次 | |||
last_content | varchar(1024) | 是 |