okayapi_travel_devices - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_travel_devices：/tablelist/okayapi_travel_devices.html


-- MySQL Table okayapi_travel_devices
-- From: OkayAPI.com
CREATE TABLE `okayapi_travel_devices` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `device_sid` varchar(50) NOT NULL COMMENT '设备号',
    `okayapi_travel_devices_name` varchar(100) NOT NULL COMMENT '',
    `okayapi_travel_devices_type` set('seller','exit','gates') NOT NULL DEFAULT 'gates' COMMENT '闸机，出口、销售终端',
    `created` bigint(12) NOT NULL COMMENT '',
    `active` int(1) NOT NULL DEFAULT '0' COMMENT '-1锁定',
    KEY `device_sid` (`device_sid`),
    KEY `okayapi_travel_devices_name` (`okayapi_travel_devices_name`),
    KEY `okayapi_travel_devices_type` (`okayapi_travel_devices_type`),
    KEY `created` (`created`),
    KEY `active` (`active`),
    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	Demo Data
device_sid	varchar(50)		否	设备号
okayapi_travel_devices_name	varchar(100)		否
okayapi_travel_devices_type	set('seller','exit','gates')	gates	否	闸机，出口、销售终端	gates
created	bigint(12)		否
active	int(1)	0	否	-1锁定	0