MySQL Create Table SQL
Table Structure: okayapi_landi_system_reminder：/tablelist/okayapi_landi_system_reminder.html
-- MySQL Table okayapi_landi_system_reminder
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_system_reminder` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NULL COMMENT '',
`title` varchar(200) NULL COMMENT '',
`content` varchar(500) NULL COMMENT '',
`remind_date` date NULL COMMENT '',
`state` varchar(10) NULL COMMENT '完成、未完成',
KEY `user_id` (`user_id`),
KEY `title` (`title`),
KEY `content` (`content`),
KEY `remind_date` (`remind_date`),
KEY `state` (`state`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'LD酒店租房管理-系统提醒';
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 |
|---|---|---|---|---|---|---|
| user_id | int(11) | 是 | ||||
| title | varchar(200) | 是 | ||||
| content | varchar(500) | 是 | ||||
| remind_date | date | 是 | ||||
| state | varchar(10) | 是 | 完成、未完成 |
