MySQL Create Table SQL
Table Structure: okayapi_travel_staff_exchanges：/tablelist/okayapi_travel_staff_exchanges.html
-- MySQL Table okayapi_travel_staff_exchanges
-- From: OkayAPI.com
CREATE TABLE `okayapi_travel_staff_exchanges` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(8) NOT NULL COMMENT '',
`created` bigint(12) NOT NULL COMMENT '',
`okayapi_travel_staff_exchanges_action` set('logout','login') NOT NULL DEFAULT 'logout' COMMENT '',
KEY `user_id` (`user_id`),
KEY `created` (`created`),
KEY `okayapi_travel_staff_exchanges_action` (`okayapi_travel_staff_exchanges_action`),
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-3 of 3 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| user_id | int(8) | 否 | Normal Index | |||
| created | bigint(12) | 否 | ||||
| okayapi_travel_staff_exchanges_action | set('logout','login') | logout | 否 | logout |
