MySQL Create Table SQL
Table Structure: okayapi_activity_client_email：/tablelist/okayapi_activity_client_email.html
-- MySQL Table okayapi_activity_client_email
-- From: OkayAPI.com
CREATE TABLE `okayapi_activity_client_email` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`client_id` bigint(20) NULL COMMENT '',
`sender` varchar(255) NULL COMMENT '',
`recipients` text NULL COMMENT '',
`subject` varchar(255) NULL COMMENT '',
`content_html` text NULL COMMENT '',
`content_text` text NULL COMMENT '',
KEY `client_id` (`client_id`),
KEY `sender` (`sender`),
KEY `recipients` (`recipients`),
KEY `subject` (`subject`),
KEY `content_html` (`content_html`),
KEY `content_text` (`content_text`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '主机销售-活动客户邮箱';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-6 of 6 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| client_id | bigint(20) | 是 | Normal Index | |||
| sender | varchar(255) | 是 | ||||
| recipients | text | 是 | ||||
| subject | varchar(255) | 是 | ||||
| content_html | text | 是 | ||||
| content_text | text | 是 |
