+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
okayapi_travel_categories_namevarchar(100)种类名
activeint(1)00
updatedbigint(12)
consume_modeset('year','staff_card','only_one')only_one票的消费方式,年卡或一次性,员工卡only_one
group_ticketset('n','y')n是否是团队票n
support_refundset('y','n')y是否支持退票y
refund_ratioint(3)100退钱比例 默认100%100
refund_after_be_invalidset('y','n','','')n退票后是否自动作废n
default_expired_daysint(3)1默认有效期1天1
pricedecimal(8,2)
inventory_ticket_activation_modeset('set_expired_time','after_sell')after_sell库存票激活方式, 销售后激活,到具体时间后自动激活after_sell

Guess You Like

MySQL Table Design okayapi_opentrip_travel_admin

MySQL Table Design okayapi_opentrip_travel_category

MySQL Table Design okayapi_opentrip_travel_order

MySQL Table Design okayapi_opentrip_travel_product

MySQL Table Design okayapi_opentrip_travel_shopcart

MySQL Table Design okayapi_opentrip_travel_user

MySQL Table Design okayapi_travel_agents

MySQL Table Design okayapi_travel_agent_users

MySQL Table Design okayapi_travel_depots

MySQL Table Design okayapi_travel_depot_annuals

MySQL Table Design okayapi_travel_depot_logs

MySQL Table Design okayapi_travel_depot_staffs

MySQL Table Design okayapi_travel_depot_vouchers

MySQL Table Design okayapi_travel_devices

MySQL Table Design okayapi_travel_exist_statistics

MySQL Table Design okayapi_travel_features

MySQL Table Design okayapi_travel_groups

MySQL Table Design okayapi_travel_orders

MySQL Table Design okayapi_travel_staff_exchanges

MySQL Table Design okayapi_travel_users

TOP ↑