okayapi_crm_complaints - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_crm_complaints：/tablelist/okayapi_crm_complaints.html


-- MySQL Table okayapi_crm_complaints
-- From: OkayAPI.com
CREATE TABLE `okayapi_crm_complaints` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(255) NULL COMMENT '投诉主题',
    `customer_id` int(11) NULL COMMENT '客户',
    `complaints_type` varchar(255) NULL COMMENT '投诉类型',
    `complaints_date` datetime NULL COMMENT '投诉时间',
    `result` varchar(255) NULL COMMENT '处理结果',
    `urgencydegree` varchar(255) NULL COMMENT '紧急程度',
    KEY `title` (`title`),
    KEY `customer_id` (`customer_id`),
    KEY `complaints_type` (`complaints_type`),
    KEY `complaints_date` (`complaints_date`),
    KEY `result` (`result`),
    KEY `urgencydegree` (`urgencydegree`),
    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-6 of 6 results.

Field Name	Field Type	IS NULL	Field Comment
title	varchar(255)	是	投诉主题
customer_id	int(11)	是	客户
complaints_type	varchar(255)	是	投诉类型
complaints_date	datetime	是	投诉时间
result	varchar(255)	是	处理结果
urgencydegree	varchar(255)	是	紧急程度