MySQL Create Table SQL
Table Structure: okayapi_crm_marketinggroupinfo：/tablelist/okayapi_crm_marketinggroupinfo.html
-- MySQL Table okayapi_crm_marketinggroupinfo
-- From: OkayAPI.com
CREATE TABLE `okayapi_crm_marketinggroupinfo` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`phone` varchar(255) NOT NULL COMMENT '手机号',
`marketinggroup_id` int(255) NOT NULL COMMENT '',
KEY `phone` (`phone`),
KEY `marketinggroup_id` (`marketinggroup_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-2 of 2 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| phone | varchar(255) | 是 | 手机号 | |||
| marketinggroup_id | int(255) | 否 |
