MySQL Create Table SQL
Table Structure: okayapi_travel_categories:/tablelist/okayapi_travel_categories.html
-- MySQL Table okayapi_travel_categories
-- From: OkayAPI.com
CREATE TABLE `okayapi_travel_categories` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_travel_categories_name` varchar(100) NOT NULL COMMENT '种类名',
`active` int(1) NOT NULL DEFAULT '0' COMMENT '',
`updated` bigint(12) NOT NULL COMMENT '',
`consume_mode` set('year','staff_card','only_one') NOT NULL DEFAULT 'only_one' COMMENT '票的消费方式,年卡或一次性,员工卡',
`group_ticket` set('n','y') NOT NULL DEFAULT 'n' COMMENT '是否是团队票',
`support_refund` set('y','n') NOT NULL DEFAULT 'y' COMMENT '是否支持退票',
`refund_ratio` int(3) NOT NULL DEFAULT '100' COMMENT '退钱比例 默认100%',
`refund_after_be_invalid` set('y','n','','') NOT NULL DEFAULT 'n' COMMENT '退票后是否自动作废',
`default_expired_days` int(3) NOT NULL DEFAULT '1' COMMENT '默认有效期1天',
`price` decimal(8,2) NOT NULL COMMENT '',
`inventory_ticket_activation_mode` set('set_expired_time','after_sell') NOT NULL DEFAULT 'after_sell' COMMENT '库存票激活方式, 销售后激活,到具体时间后自动激活',
KEY `okayapi_travel_categories_name` (`okayapi_travel_categories_name`),
KEY `active` (`active`),
KEY `updated` (`updated`),
KEY `consume_mode` (`consume_mode`),
KEY `group_ticket` (`group_ticket`),
KEY `support_refund` (`support_refund`),
KEY `refund_ratio` (`refund_ratio`),
KEY `refund_after_be_invalid` (`refund_after_be_invalid`),
KEY `default_expired_days` (`default_expired_days`),
KEY `price` (`price`),
KEY `inventory_ticket_activation_mode` (`inventory_ticket_activation_mode`),
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-11 of 11 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_travel_categories_name | varchar(100) | 否 | 种类名 | |||
active | int(1) | 0 | 否 | 0 | ||
updated | bigint(12) | 否 | ||||
consume_mode | set('year','staff_card','only_one') | only_one | 否 | 票的消费方式,年卡或一次性,员工卡 | only_one | |
group_ticket | set('n','y') | n | 否 | 是否是团队票 | n | |
support_refund | set('y','n') | y | 否 | 是否支持退票 | y | |
refund_ratio | int(3) | 100 | 否 | 退钱比例 默认100% | 100 | |
refund_after_be_invalid | set('y','n','','') | n | 否 | 退票后是否自动作废 | n | |
default_expired_days | int(3) | 1 | 否 | 默认有效期1天 | 1 | |
price | decimal(8,2) | 否 | ||||
inventory_ticket_activation_mode | set('set_expired_time','after_sell') | after_sell | 否 | 库存票激活方式, 销售后激活,到具体时间后自动激活 | after_sell |