+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_seo_article:/tablelist/okayapi_seo_article.html


-- MySQL Table okayapi_seo_article
-- From: OkayAPI.com
CREATE TABLE `okayapi_seo_article` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(50) NOT NULL COMMENT '标题',
    `cover` varchar(100) NOT NULL COMMENT '封面',
    `seo_key` varchar(50) NOT NULL COMMENT 'seo关键字',
    `seo_content` varchar(1000) NOT NULL COMMENT 'seo内容',
    `cate_id` int(10) NOT NULL DEFAULT '0' COMMENT '分类id',
    `description` char(140) NOT NULL COMMENT '描述',
    `position` smallint(5) NOT NULL DEFAULT '0' COMMENT '推荐位',
    `content` longtext NOT NULL COMMENT '文章内容',
    `link` varchar(100) NOT NULL COMMENT '外链',
    `author` varchar(40) NOT NULL COMMENT '作者',
    `view` int(10) NOT NULL DEFAULT '0' COMMENT '浏览量',
    `sort` int(10) NOT NULL DEFAULT '0' COMMENT '优先级',
    `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
    KEY `title` (`title`),
    KEY `cover` (`cover`),
    KEY `seo_key` (`seo_key`),
    KEY `seo_content` (`seo_content`),
    KEY `cate_id` (`cate_id`),
    KEY `description` (`description`),
    KEY `position` (`position`),
    KEY `content` (`content`),
    KEY `link` (`link`),
    KEY `author` (`author`),
    KEY `view` (`view`),
    KEY `sort` (`sort`),
    KEY `status` (`status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '推广文章-seo';

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


MySQL database table structure design

Displaying 1-13 of 13 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
titlevarchar(50)标题
covervarchar(100)封面
seo_keyvarchar(50)seo关键字
seo_contentvarchar(1000)seo内容
cate_idint(10)0分类id0
descriptionchar(140)描述
positionsmallint(5)0推荐位0
contentlongtext文章内容
linkvarchar(100)外链
authorvarchar(40)作者
viewint(10)0浏览量0
sortint(10)0优先级0
statustinyint(4)1状态1

Guess You Like

MySQL Table Design okayapi_article_ad

MySQL Table Design okayapi_article_cate

MySQL Table Design okayapi_article_tag

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 ↑