okayapi_crm_faq - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_crm_faq：/tablelist/okayapi_crm_faq.html


-- MySQL Table okayapi_crm_faq
-- From: OkayAPI.com
CREATE TABLE `okayapi_crm_faq` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `product_name` varchar(255) NULL COMMENT '产品名称',
    `faqcategory_id` int(255) NULL COMMENT '产品分类ID',
    `status` varchar(255) NULL COMMENT '状态',
    `keyword` varchar(255) NULL COMMENT '关键字',
    `question` varchar(255) NULL COMMENT '问题',
    `solution` text NULL COMMENT '处理方式',
    KEY `product_name` (`product_name`),
    KEY `faqcategory_id` (`faqcategory_id`),
    KEY `status` (`status`),
    KEY `keyword` (`keyword`),
    KEY `question` (`question`),
    KEY `solution` (`solution`),
    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
product_name	varchar(255)	是	产品名称
faqcategory_id	int(255)	是	产品分类ID
status	varchar(255)	是	状态
keyword	varchar(255)	是	关键字
question	varchar(255)	是	问题
solution	text	是	处理方式