MySQL Create Table SQL
Table Structure: okayapi_vhr_sysmsg：/tablelist/okayapi_vhr_sysmsg.html
-- MySQL Table okayapi_vhr_sysmsg
-- From: OkayAPI.com
CREATE TABLE `okayapi_vhr_sysmsg` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`mid` int(11) NULL COMMENT '消息id',
`type` int(11) NULL DEFAULT '0' COMMENT '0表示群发消息',
`hrid` int(11) NULL COMMENT '这条消息是给谁的',
`state` int(11) NULL DEFAULT '0' COMMENT '0 未读 1 已读',
KEY `mid` (`mid`),
KEY `type` (`type`),
KEY `hrid` (`hrid`),
KEY `state` (`state`),
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-4 of 4 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| mid | int(11) | 是 | 消息id | Normal Index | ||
| type | int(11) | 0 | 是 | 0表示群发消息 | 0 | |
| hrid | int(11) | 是 | 这条消息是给谁的 | Normal Index | ||
| state | int(11) | 0 | 是 | 0 未读 1 已读 | 0 |
