okayapi_fl_guestbook - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_fl_guestbook：/tablelist/okayapi_fl_guestbook.html


-- MySQL Table okayapi_fl_guestbook
-- From: OkayAPI.com
CREATE TABLE `okayapi_fl_guestbook` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(150) NOT NULL COMMENT '标题',
    `msg` varchar(250) NOT NULL COMMENT '描述',
    `name` varchar(30) NOT NULL COMMENT '姓名',
    `mobile` varchar(20) NOT NULL COMMENT '电话',
    `email` varchar(60) NOT NULL COMMENT '邮箱',
    `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否阅读，默认0未阅读',
    `shop_id` int(11) NOT NULL DEFAULT '0' COMMENT '店铺ID',
    `delete_time` int(11) NOT NULL DEFAULT '0' COMMENT '删除时间',
    KEY `title` (`title`),
    KEY `msg` (`msg`),
    KEY `name` (`name`),
    KEY `mobile` (`mobile`),
    KEY `email` (`email`),
    KEY `status` (`status`),
    KEY `shop_id` (`shop_id`),
    KEY `delete_time` (`delete_time`),
    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-8 of 8 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
title	varchar(150)		否	标题
msg	varchar(250)		否	描述
name	varchar(30)		否	姓名
mobile	varchar(20)		否	电话
email	varchar(60)		否	邮箱
status	tinyint(1)	0	否	是否阅读，默认0未阅读	0
shop_id	int(11)	0	否	店铺ID	0
delete_time	int(11)	0	否	删除时间	0