okayapi_opms_pms_knowledges - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_opms_pms_knowledges：/tablelist/okayapi_opms_pms_knowledges.html


-- MySQL Table okayapi_opms_pms_knowledges
-- From: OkayAPI.com
CREATE TABLE `okayapi_opms_pms_knowledges` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `userid` bigint(20) NULL COMMENT '用户ID',
    `sortid` bigint(20) NULL COMMENT '分类ID',
    `title` varchar(100) NULL COMMENT '标题',
    `tag` varchar(100) NULL COMMENT '标签',
    `summary` varchar(255) NULL COMMENT '简介',
    `url` varchar(255) NULL COMMENT 'URL',
    `color` varchar(10) NULL COMMENT '标题颜色',
    `content` text NULL COMMENT '正文',
    `viewnum` int(10) NULL DEFAULT '0' COMMENT '浏览数',
    `comtnum` int(10) NULL DEFAULT '0' COMMENT '评论数',
    `laudnum` int(10) NULL DEFAULT '0' COMMENT '赞数',
    `ispublis` tinyint(1) NULL DEFAULT '1' COMMENT '1发布2草稿',
    `okayapi_opms_pms_knowledges_status` tinyint(1) NULL DEFAULT '1' COMMENT '1正常2屏蔽',
    `created` int(10) NULL COMMENT '',
    `okayapi_opms_pms_knowledges_changed` int(10) NULL COMMENT '',
    KEY `userid` (`userid`),
    KEY `sortid` (`sortid`),
    KEY `title` (`title`),
    KEY `tag` (`tag`),
    KEY `summary` (`summary`),
    KEY `url` (`url`),
    KEY `color` (`color`),
    KEY `content` (`content`),
    KEY `viewnum` (`viewnum`),
    KEY `comtnum` (`comtnum`),
    KEY `laudnum` (`laudnum`),
    KEY `ispublis` (`ispublis`),
    KEY `okayapi_opms_pms_knowledges_status` (`okayapi_opms_pms_knowledges_status`),
    KEY `created` (`created`),
    KEY `okayapi_opms_pms_knowledges_changed` (`okayapi_opms_pms_knowledges_changed`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'OPMS和OA管理-知识分享表';

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

MySQL database table structure design

Displaying 1-15 of 15 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
userid	bigint(20)		是	用户ID
sortid	bigint(20)		是	分类ID
title	varchar(100)		是	标题
tag	varchar(100)		是	标签
summary	varchar(255)		是	简介
url	varchar(255)		是	URL
color	varchar(10)		是	标题颜色
content	text		是	正文
viewnum	int(10)	0	是	浏览数	0
comtnum	int(10)	0	是	评论数	0
laudnum	int(10)	0	是	赞数	0
ispublis	tinyint(1)	1	是	1发布2草稿	1
okayapi_opms_pms_knowledges_status	tinyint(1)	1	是	1正常2屏蔽	1
created	int(10)		是
okayapi_opms_pms_knowledges_changed	int(10)		是