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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
parent_id | bigint(20) | 0 | 否 | 父级id | Normal Index | 0 |
post_type | tinyint(3) | 1 | 否 | 类型,1:文章;2:页面 | Normal Index | 1 |
post_format | tinyint(3) | 1 | 否 | 内容格式;1:html;2:md | 1 | |
user_id | bigint(20) | 0 | 否 | 发表者用户id | Normal Index | 0 |
post_status | tinyint(3) | 1 | 否 | 状态;1:已发布;0:未发布; | 1 | |
comment_status | tinyint(3) | 1 | 否 | 评论状态;1:允许;0:不允许 | 1 | |
is_top | tinyint(3) | 0 | 否 | 是否置顶;1:置顶;0:不置顶 | 0 | |
recommended | tinyint(3) | 0 | 否 | 是否推荐;1:推荐;0:不推荐 | 0 | |
post_hits | bigint(20) | 0 | 否 | 查看数 | 0 | |
post_like | bigint(20) | 0 | 否 | 点赞数 | 0 | |
comment_count | bigint(20) | 0 | 否 | 评论数 | 0 | |
create_time | int(10) | 0 | 否 | 创建时间 | Normal Index | 0 |
published_time | int(10) | 0 | 否 | 发布时间 | 0 | |
delete_time | int(10) | 0 | 否 | 删除时间 | 0 | |
post_title | varchar(100) | 否 | post标题 | |||
post_subtitle | varchar(100) | 是 | 副标题 | |||
post_price | varchar(50) | 是 | 产品价格 | |||
post_start | varchar(5) | 是 | 星级 | |||
post_txque1 | varchar(255) | 是 | 产品特性问题1 | |||
post_txjd1 | text | 是 | 产品特性解答1 | |||
post_txque2 | varchar(255) | 是 | 产品特性问题2 | |||
post_txjd2 | text | 是 | 产品特性解答2 | |||
post_txque3 | varchar(255) | 是 | 产品特性问题3 | |||
post_txjd3 | text | 是 | 产品特性解答3 | |||
post_txque4 | varchar(255) | 是 | 产品特性问题4 | |||
post_txjd4 | text | 是 | 产品特性解答4 | |||
post_txque5 | varchar(255) | 是 | 产品特性问题5 | |||
post_txjd5 | text | 是 | 产品特性解答5 | |||
post_excerptd | varchar(255) | 是 | 产品简介(产品下方) | |||
post_keywords | varchar(150) | 否 | seo keywords | |||
post_excerpt | varchar(500) | 否 | post摘要 | |||
post_source | varchar(150) | 否 | 转载文章的来源 | |||
post_content | text | 是 | 文章内容 | |||
post_content_filtered | text | 是 | 处理过的文章内容 | |||
more | text | 是 | 扩展属性,如缩略图;格式为json |