okayapi_fl_feedback - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_fl_feedback：/tablelist/okayapi_fl_feedback.html


-- MySQL Table okayapi_fl_feedback
-- From: OkayAPI.com
CREATE TABLE `okayapi_fl_feedback` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `type` varchar(20) NOT NULL COMMENT '意见反馈类型，选填',
    `title` varchar(150) NOT NULL COMMENT '标题，选填',
    `content` mediumtext NOT NULL COMMENT '意见反馈内容',
    `mobile` varchar(20) NOT NULL COMMENT '手机号码，选填',
    `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
    KEY `type` (`type`),
    KEY `title` (`title`),
    KEY `content` (`content`),
    KEY `mobile` (`mobile`),
    KEY `user_id` (`user_id`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CMS建站系统-意见反馈表';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-5 of 5 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
type	varchar(20)		否	意见反馈类型，选填
title	varchar(150)		否	标题，选填
content	mediumtext		是	意见反馈内容
mobile	varchar(20)		否	手机号码，选填
user_id	int(11)	0	否	用户id	0