okayapi_box_kb_article - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_box_kb_article：/tablelist/okayapi_box_kb_article.html


-- MySQL Table okayapi_box_kb_article
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_kb_article` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `kb_article_category_id` bigint(20) NULL COMMENT '',
    `views` int(11) NULL DEFAULT '0' COMMENT '',
    `title` varchar(100) NULL COMMENT '',
    `content` text NULL COMMENT '',
    `slug` varchar(255) NULL COMMENT '',
    `status` varchar(30) NULL DEFAULT 'active' COMMENT 'active, draft',
    KEY `kb_article_category_id` (`kb_article_category_id`),
    KEY `views` (`views`),
    KEY `title` (`title`),
    KEY `content` (`content`),
    KEY `slug` (`slug`),
    KEY `status` (`status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '主机销售-kb文章';

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

MySQL database table structure design

Displaying 1-6 of 6 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
kb_article_category_id	bigint(20)		是		Normal Index
views	int(11)	0	是			0
title	varchar(100)		是
content	text		是
slug	varchar(255)		是		Unique Index
status	varchar(30)	active	是	active, draft		active