okayapi_opms_pms_messages - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_opms_pms_messages：/tablelist/okayapi_opms_pms_messages.html


-- MySQL Table okayapi_opms_pms_messages
-- From: OkayAPI.com
CREATE TABLE `okayapi_opms_pms_messages` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `userid` bigint(20) NULL COMMENT '',
    `touserid` bigint(20) NULL COMMENT '',
    `okayapi_opms_pms_messages_type` tinyint(2) NULL COMMENT '类型1评论2赞3审批',
    `subtype` tinyint(3) NULL COMMENT '11知识评论12相册评论21知识赞22相册赞31请假审批32加班33报销34出差35外出36物品',
    `title` varchar(200) NULL COMMENT '',
    `url` varchar(200) NULL COMMENT '',
    `okayapi_opms_pms_messages_view` tinyint(1) NULL DEFAULT '1' COMMENT '1未看，2已看',
    `created` int(10) NULL COMMENT '',
    KEY `userid` (`userid`),
    KEY `touserid` (`touserid`),
    KEY `okayapi_opms_pms_messages_type` (`okayapi_opms_pms_messages_type`),
    KEY `subtype` (`subtype`),
    KEY `title` (`title`),
    KEY `url` (`url`),
    KEY `okayapi_opms_pms_messages_view` (`okayapi_opms_pms_messages_view`),
    KEY `created` (`created`),
    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-8 of 8 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
userid	bigint(20)		是
touserid	bigint(20)		是
okayapi_opms_pms_messages_type	tinyint(2)		是	类型1评论2赞3审批
subtype	tinyint(3)		是	11知识评论12相册评论21知识赞22相册赞31请假审批32加班33报销34出差35外出36物品
title	varchar(200)		是
url	varchar(200)		是
okayapi_opms_pms_messages_view	tinyint(1)	1	是	1未看，2已看	1
created	int(10)		是