+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_topic:/tablelist/okayapi_topic.html


-- MySQL Table okayapi_topic
-- From: OkayAPI.com
CREATE TABLE `okayapi_topic` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `topic_title` varchar(64) NULL COMMENT '话题标题',
    `discuss_count` int(11) NULL DEFAULT '0' COMMENT '讨论计数',
    `topic_description` text NULL COMMENT '话题描述',
    `topic_pic` varchar(255) NULL COMMENT '话题图片',
    `topic_lock` tinyint(2) NULL DEFAULT '0' COMMENT '话题是否锁定 1 锁定 0 未锁定',
    `focus_count` int(11) NULL DEFAULT '0' COMMENT '关注计数',
    `seo_title` varchar(255) NULL COMMENT '',
    `parent_id` int(10) NULL DEFAULT '0' COMMENT '',
    `is_parent` tinyint(1) NULL DEFAULT '0' COMMENT '',
    KEY `topic_title` (`topic_title`),
    KEY `discuss_count` (`discuss_count`),
    KEY `topic_description` (`topic_description`),
    KEY `topic_pic` (`topic_pic`),
    KEY `topic_lock` (`topic_lock`),
    KEY `focus_count` (`focus_count`),
    KEY `seo_title` (`seo_title`),
    KEY `parent_id` (`parent_id`),
    KEY `is_parent` (`is_parent`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '话题';

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


MySQL database table structure design

Displaying 1-9 of 9 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
topic_titlevarchar(64)话题标题
discuss_countint(11)0讨论计数0
topic_descriptiontext话题描述
topic_picvarchar(255)话题图片
topic_locktinyint(2)0话题是否锁定 1 锁定 0 未锁定0
focus_countint(11)0关注计数0
seo_titlevarchar(255)
parent_idint(10)00
is_parenttinyint(1)00

Guess You Like

MySQL Table Design okayapi_question

MySQL Table Design okayapi_report

MySQL Table Design okayapi_social_users

MySQL Table Design okayapi_sina_weibo

MySQL Table Design okayapi_ucenter

TOP ↑