+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_fie_comment:/tablelist/okayapi_fie_comment.html


-- MySQL Table okayapi_fie_comment
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_comment` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `parent_id` bigint(20) NULL DEFAULT '0' COMMENT '被回复的评论id',
    `user_id` int(10) NULL DEFAULT '0' COMMENT '发表评论的用户id',
    `to_user_id` int(10) NULL DEFAULT '0' COMMENT '被评论的用户id',
    `object_id` int(10) NULL DEFAULT '0' COMMENT '评论内容 id',
    `like_count` int(10) NULL DEFAULT '0' COMMENT '点赞数',
    `dislike_count` int(10) NULL DEFAULT '0' COMMENT '不喜欢数',
    `floor` int(10) NULL DEFAULT '0' COMMENT '楼层数',
    `create_time` int(10) NULL DEFAULT '0' COMMENT '评论时间',
    `delete_time` int(10) NULL DEFAULT '0' COMMENT '删除时间',
    `okayapi_fie_comment_status` tinyint(3) NULL DEFAULT '1' COMMENT '状态,1:已审核,0:未审核',
    `okayapi_fie_comment_type` tinyint(3) NULL DEFAULT '1' COMMENT '评论类型;1实名评论',
    `okayapi_fie_comment_table_name` varchar(64) NULL COMMENT '评论内容所在表,不带表前缀',
    `full_name` varchar(50) NULL COMMENT '评论者昵称',
    `email` varchar(255) NULL COMMENT '评论者邮箱',
    `path` varchar(255) NULL COMMENT '层级关系',
    `url` text NULL COMMENT '原文地址',
    `content` text NULL COMMENT '评论内容',
    `more` text NULL COMMENT '扩展属性',
    KEY `parent_id` (`parent_id`),
    KEY `user_id` (`user_id`),
    KEY `to_user_id` (`to_user_id`),
    KEY `object_id` (`object_id`),
    KEY `like_count` (`like_count`),
    KEY `dislike_count` (`dislike_count`),
    KEY `floor` (`floor`),
    KEY `create_time` (`create_time`),
    KEY `delete_time` (`delete_time`),
    KEY `okayapi_fie_comment_status` (`okayapi_fie_comment_status`),
    KEY `okayapi_fie_comment_type` (`okayapi_fie_comment_type`),
    KEY `okayapi_fie_comment_table_name` (`okayapi_fie_comment_table_name`),
    KEY `full_name` (`full_name`),
    KEY `email` (`email`),
    KEY `path` (`path`),
    KEY `url` (`url`),
    KEY `content` (`content`),
    KEY `more` (`more`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'fie内容管理-评论表';

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


MySQL database table structure design

Displaying 1-18 of 18 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
parent_idbigint(20)0被回复的评论idNormal Index0
user_idint(10)0发表评论的用户id0
to_user_idint(10)0被评论的用户id0
object_idint(10)0评论内容 idNormal Index0
like_countint(10)0点赞数0
dislike_countint(10)0不喜欢数0
floorint(10)0楼层数0
create_timeint(10)0评论时间Normal Index0
delete_timeint(10)0删除时间0
okayapi_fie_comment_statustinyint(3)1状态,1:已审核,0:未审核Normal Index1
okayapi_fie_comment_typetinyint(3)1评论类型;1实名评论1
okayapi_fie_comment_table_namevarchar(64)评论内容所在表,不带表前缀Normal Index
full_namevarchar(50)评论者昵称
emailvarchar(255)评论者邮箱
pathvarchar(255)层级关系
urltext原文地址
contenttext评论内容
moretext扩展属性

Guess You Like

MySQL Table Design okayapi_message

MySQL Table Design okayapi_article

MySQL Table Design okayapi_fie_admin_menu

MySQL Table Design okayapi_fie_asset

MySQL Table Design okayapi_fie_auth_access

MySQL Table Design okayapi_fie_auth_rule

MySQL Table Design okayapi_fie_hook

MySQL Table Design okayapi_fie_hook_plugin

MySQL Table Design okayapi_fie_link

MySQL Table Design okayapi_fie_nav

MySQL Table Design okayapi_fie_nav_menu

MySQL Table Design okayapi_fie_option

MySQL Table Design okayapi_fie_plugin

MySQL Table Design okayapi_fie_portal_category

MySQL Table Design okayapi_fie_portal_category_post

MySQL Table Design okayapi_fie_portal_post

MySQL Table Design okayapi_fie_portal_tag

MySQL Table Design okayapi_fie_portal_tag_post

MySQL Table Design okayapi_fie_recycle_bin

MySQL Table Design okayapi_fie_role

TOP ↑