MySQL Create Table SQL
Table Structure: okayapi_sys_notice_manage：/tablelist/okayapi_sys_notice_manage.html
-- MySQL Table okayapi_sys_notice_manage
-- From: OkayAPI.com
CREATE TABLE `okayapi_sys_notice_manage` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`manager_id` int(10) NOT NULL COMMENT '管理员id',
`notify_id` int(10) NOT NULL DEFAULT '0' COMMENT '消息id',
`is_read` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否已读 1已读',
`type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '消息类型[1:公告;2:提醒;3:信息(私信)',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
KEY `manager_id` (`manager_id`),
KEY `notify_id` (`notify_id`),
KEY `is_read` (`is_read`),
KEY `type` (`type`),
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-5 of 5 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| manager_id | int(10) | 否 | 管理员id | |||
| notify_id | int(10) | 0 | 是 | 消息id | 0 | |
| is_read | tinyint(2) | 0 | 是 | 是否已读 1已读 | 0 | |
| type | tinyint(1) | 0 | 是 | 消息类型[1:公告;2:提醒;3:信息(私信) | 0 | |
| status | tinyint(4) | 1 | 否 | 状态[-1:删除;0:禁用;1启用] | 1 |
