+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_fie_portal_post:/tablelist/okayapi_fie_portal_post.html


-- MySQL Table okayapi_fie_portal_post
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_portal_post` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `parent_id` bigint(20) NULL DEFAULT '0' COMMENT '父级id',
    `post_type` tinyint(3) NULL DEFAULT '1' COMMENT '类型,1:文章;2:页面',
    `post_format` tinyint(3) NULL DEFAULT '1' COMMENT '内容格式;1:html;2:md',
    `user_id` bigint(20) NULL DEFAULT '0' COMMENT '发表者用户id',
    `post_status` tinyint(3) NULL DEFAULT '1' COMMENT '状态;1:已发布;0:未发布;',
    `comment_status` tinyint(3) NULL DEFAULT '1' COMMENT '评论状态;1:允许;0:不允许',
    `is_top` tinyint(3) NULL DEFAULT '0' COMMENT '是否置顶;1:置顶;0:不置顶',
    `recommended` tinyint(3) NULL DEFAULT '0' COMMENT '是否推荐;1:推荐;0:不推荐',
    `post_hits` bigint(20) NULL DEFAULT '0' COMMENT '查看数',
    `post_like` bigint(20) NULL DEFAULT '0' COMMENT '点赞数',
    `comment_count` bigint(20) NULL DEFAULT '0' COMMENT '评论数',
    `create_time` int(10) NULL DEFAULT '0' COMMENT '创建时间',
    `published_time` int(10) NULL DEFAULT '0' COMMENT '发布时间',
    `delete_time` int(10) NULL DEFAULT '0' COMMENT '删除时间',
    `post_title` varchar(100) NULL COMMENT 'post标题',
    `post_subtitle` varchar(100) NULL COMMENT '副标题',
    `post_price` varchar(50) NULL COMMENT '产品价格',
    `post_start` varchar(5) NULL COMMENT '星级',
    `post_txque1` varchar(255) NULL COMMENT '产品特性问题1',
    `post_txjd1` text NULL COMMENT '产品特性解答1',
    `post_txque2` varchar(255) NULL COMMENT '产品特性问题2',
    `post_txjd2` text NULL COMMENT '产品特性解答2',
    `post_txque3` varchar(255) NULL COMMENT '产品特性问题3',
    `post_txjd3` text NULL COMMENT '产品特性解答3',
    `post_txque4` varchar(255) NULL COMMENT '产品特性问题4',
    `post_txjd4` text NULL COMMENT '产品特性解答4',
    `post_txque5` varchar(255) NULL COMMENT '产品特性问题5',
    `post_txjd5` text NULL COMMENT '产品特性解答5',
    `post_excerptd` varchar(255) NULL COMMENT '产品简介(产品下方)',
    `post_keywords` varchar(150) NULL COMMENT 'seo keywords',
    `post_excerpt` varchar(500) NULL COMMENT 'post摘要',
    `post_source` varchar(150) NULL COMMENT '转载文章的来源',
    `post_content` text NULL COMMENT '文章内容',
    `post_content_filtered` text NULL COMMENT '处理过的文章内容',
    `more` text NULL COMMENT '扩展属性,如缩略图;格式为json',
    KEY `parent_id` (`parent_id`),
    KEY `post_type` (`post_type`),
    KEY `post_format` (`post_format`),
    KEY `user_id` (`user_id`),
    KEY `post_status` (`post_status`),
    KEY `comment_status` (`comment_status`),
    KEY `is_top` (`is_top`),
    KEY `recommended` (`recommended`),
    KEY `post_hits` (`post_hits`),
    KEY `post_like` (`post_like`),
    KEY `comment_count` (`comment_count`),
    KEY `create_time` (`create_time`),
    KEY `published_time` (`published_time`),
    KEY `delete_time` (`delete_time`),
    KEY `post_title` (`post_title`),
    KEY `post_subtitle` (`post_subtitle`),
    KEY `post_price` (`post_price`),
    KEY `post_start` (`post_start`),
    KEY `post_txque1` (`post_txque1`),
    KEY `post_txjd1` (`post_txjd1`),
    KEY `post_txque2` (`post_txque2`),
    KEY `post_txjd2` (`post_txjd2`),
    KEY `post_txque3` (`post_txque3`),
    KEY `post_txjd3` (`post_txjd3`),
    KEY `post_txque4` (`post_txque4`),
    KEY `post_txjd4` (`post_txjd4`),
    KEY `post_txque5` (`post_txque5`),
    KEY `post_txjd5` (`post_txjd5`),
    KEY `post_excerptd` (`post_excerptd`),
    KEY `post_keywords` (`post_keywords`),
    KEY `post_excerpt` (`post_excerpt`),
    KEY `post_source` (`post_source`),
    KEY `post_content` (`post_content`),
    KEY `post_content_filtered` (`post_content_filtered`),
    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-35 of 35 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
parent_idbigint(20)0父级idNormal Index0
post_typetinyint(3)1类型,1:文章;2:页面Normal Index1
post_formattinyint(3)1内容格式;1:html;2:md1
user_idbigint(20)0发表者用户idNormal Index0
post_statustinyint(3)1状态;1:已发布;0:未发布;1
comment_statustinyint(3)1评论状态;1:允许;0:不允许1
is_toptinyint(3)0是否置顶;1:置顶;0:不置顶0
recommendedtinyint(3)0是否推荐;1:推荐;0:不推荐0
post_hitsbigint(20)0查看数0
post_likebigint(20)0点赞数0
comment_countbigint(20)0评论数0
create_timeint(10)0创建时间Normal Index0
published_timeint(10)0发布时间0
delete_timeint(10)0删除时间0
post_titlevarchar(100)post标题
post_subtitlevarchar(100)副标题
post_pricevarchar(50)产品价格
post_startvarchar(5)星级
post_txque1varchar(255)产品特性问题1
post_txjd1text产品特性解答1
post_txque2varchar(255)产品特性问题2
post_txjd2text产品特性解答2
post_txque3varchar(255)产品特性问题3
post_txjd3text产品特性解答3
post_txque4varchar(255)产品特性问题4
post_txjd4text产品特性解答4
post_txque5varchar(255)产品特性问题5
post_txjd5text产品特性解答5
post_excerptdvarchar(255)产品简介(产品下方)
post_keywordsvarchar(150)seo keywords
post_excerptvarchar(500)post摘要
post_sourcevarchar(150)转载文章的来源
post_contenttext文章内容
post_content_filteredtext处理过的文章内容
moretext扩展属性,如缩略图;格式为json

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

MySQL Table Design okayapi_fie_portal_category_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 ↑