okayapi_travel_depot_vouchers - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_travel_depot_vouchers：/tablelist/okayapi_travel_depot_vouchers.html


-- MySQL Table okayapi_travel_depot_vouchers
-- From: OkayAPI.com
CREATE TABLE `okayapi_travel_depot_vouchers` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `depot_id` int(9) NOT NULL COMMENT '',
    `voucher_type` set('barcode','fingerprint','rfid','idcard','qrcode') NOT NULL DEFAULT 'barcode' COMMENT '条型码、二维码、身份证、rfid、指纹、',
    `voucher_number` varchar(100) NOT NULL COMMENT '',
    KEY `depot_id` (`depot_id`),
    KEY `voucher_type` (`voucher_type`),
    KEY `voucher_number` (`voucher_number`),
    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
depot_id	int(9)		否		Normal Index
voucher_type	set('barcode','fingerprint','rfid','idcard','qrcode')	barcode	否	条型码、二维码、身份证、rfid、指纹、		barcode
voucher_number	varchar(100)		否