+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_fie_portal_category:/tablelist/okayapi_fie_portal_category.html


-- MySQL Table okayapi_fie_portal_category
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_portal_category` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `parent_id` bigint(20) NULL DEFAULT '0' COMMENT '分类父id',
    `post_count` bigint(20) NULL DEFAULT '0' COMMENT '分类文章数',
    `okayapi_fie_portal_category_status` tinyint(3) NULL DEFAULT '1' COMMENT '状态,1:发布,0:不发布',
    `delete_time` int(10) NULL DEFAULT '0' COMMENT '删除时间',
    `list_order` float NULL DEFAULT '10000' COMMENT '排序',
    `okayapi_fie_portal_category_name` varchar(200) NULL COMMENT '分类名称',
    `description` varchar(255) NULL COMMENT '分类描述',
    `path` varchar(255) NULL COMMENT '分类层级关系路径',
    `seo_title` varchar(100) NULL COMMENT '',
    `seo_keywords` varchar(255) NULL COMMENT '',
    `seo_description` varchar(255) NULL COMMENT '',
    `list_tpl` varchar(50) NULL COMMENT '分类列表模板',
    `one_tpl` varchar(50) NULL COMMENT '分类文章页模板',
    `more` text NULL COMMENT '扩展属性',
    KEY `parent_id` (`parent_id`),
    KEY `post_count` (`post_count`),
    KEY `okayapi_fie_portal_category_status` (`okayapi_fie_portal_category_status`),
    KEY `delete_time` (`delete_time`),
    KEY `list_order` (`list_order`),
    KEY `okayapi_fie_portal_category_name` (`okayapi_fie_portal_category_name`),
    KEY `description` (`description`),
    KEY `path` (`path`),
    KEY `seo_title` (`seo_title`),
    KEY `seo_keywords` (`seo_keywords`),
    KEY `seo_description` (`seo_description`),
    KEY `list_tpl` (`list_tpl`),
    KEY `one_tpl` (`one_tpl`),
    KEY `more` (`more`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'fie内容管理-portal应用 文章分类表';

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


MySQL database table structure design

Displaying 1-14 of 14 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
parent_idbigint(20)0分类父id0
post_countbigint(20)0分类文章数0
okayapi_fie_portal_category_statustinyint(3)1状态,1:发布,0:不发布1
delete_timeint(10)0删除时间0
list_orderfloat10000排序10000
okayapi_fie_portal_category_namevarchar(200)分类名称
descriptionvarchar(255)分类描述
pathvarchar(255)分类层级关系路径
seo_titlevarchar(100)
seo_keywordsvarchar(255)
seo_descriptionvarchar(255)
list_tplvarchar(50)分类列表模板
one_tplvarchar(50)分类文章页模板
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_comment

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_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 ↑