+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_sys_message:/tablelist/okayapi_sys_message.html


-- MySQL Table okayapi_sys_message
-- From: OkayAPI.com
CREATE TABLE `okayapi_sys_message` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(150) NOT NULL COMMENT '标题',
    `content` text NOT NULL COMMENT '消息内容',
    `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '消息类型[1:公告;2:提醒;3:信息(私信)',
    `target_id` int(10) NOT NULL DEFAULT '0' COMMENT '目标id',
    `target_type` varchar(100) NOT NULL COMMENT '目标类型',
    `target_display` int(10) NOT NULL DEFAULT '1' COMMENT '接受者是否删除',
    `action` varchar(100) NOT NULL COMMENT '动作',
    `view` int(10) NOT NULL DEFAULT '0' COMMENT '浏览量',
    `sender_id` int(10) NOT NULL DEFAULT '0' COMMENT '发送者id',
    `sender_display` tinyint(1) NOT NULL DEFAULT '1' COMMENT '发送者是否删除',
    `sender_withdraw` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否撤回 0是撤回',
    `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
    KEY `title` (`title`),
    KEY `content` (`content`),
    KEY `type` (`type`),
    KEY `target_id` (`target_id`),
    KEY `target_type` (`target_type`),
    KEY `target_display` (`target_display`),
    KEY `action` (`action`),
    KEY `view` (`view`),
    KEY `sender_id` (`sender_id`),
    KEY `sender_display` (`sender_display`),
    KEY `sender_withdraw` (`sender_withdraw`),
    KEY `status` (`status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '系统消息表';

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


MySQL database table structure design

Displaying 1-12 of 12 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
titlevarchar(150)标题
contenttext消息内容
typetinyint(1)0消息类型[1:公告;2:提醒;3:信息(私信)0
target_idint(10)0目标id0
target_typevarchar(100)目标类型
target_displayint(10)1接受者是否删除1
actionvarchar(100)动作
viewint(10)0浏览量0
sender_idint(10)0发送者id0
sender_displaytinyint(1)1发送者是否删除1
sender_withdrawtinyint(1)1是否撤回 0是撤回1
statustinyint(4)1状态[-1:删除;0:禁用;1启用]1

Guess You Like

MySQL Table Design okayapi_file_uploads

MySQL Table Design okayapi_framework_log

MySQL Table Design okayapi_provinces_log

MySQL Table Design okayapi_sms_log

MySQL Table Design okayapi_member_datas_log

MySQL Table Design okayapi_member_vip

MySQL Table Design okayapi_sys_notice_manage

MySQL Table Design okayapi_sys_menu_manage

MySQL Table Design okayapi_sys_config_manage

MySQL Table Design okayapi_sys_addon_manage

MySQL Table Design okayapi_server_manage

TOP ↑