+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_article_tag:/tablelist/okayapi_article_tag.html


-- MySQL Table okayapi_article_tag
-- From: OkayAPI.com
CREATE TABLE `okayapi_article_tag` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(20) NOT NULL COMMENT '标题',
    `sort` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
    `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
    KEY `title` (`title`),
    KEY `sort` (`sort`),
    KEY `status` (`status`),
    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-3 of 3 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
titlevarchar(20)标题
sortint(10)0排序0
statustinyint(4)1状态1

Guess You Like

MySQL Table Design okayapi_seo_article

MySQL Table Design okayapi_article_ad

MySQL Table Design okayapi_article_cate

MySQL Table Design okayapi_article_map

MySQL Table Design okayapi_access

MySQL Table Design okayapi_comment

MySQL Table Design okayapi_document

MySQL Table Design okayapi_function

MySQL Table Design okayapi_login

MySQL Table Design okayapi_moment

MySQL Table Design okayapi_praise

MySQL Table Design okayapi_request

MySQL Table Design okayapi_response

MySQL Table Design okayapi_test_record

MySQL Table Design okayapi_verify

MySQL Table Design okayapi_apijson_privacy

MySQL Table Design okayapi_apijson_user

TOP ↑