okayapi_travel_depot_logs - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_travel_depot_logs：/tablelist/okayapi_travel_depot_logs.html


-- MySQL Table okayapi_travel_depot_logs
-- From: OkayAPI.com
CREATE TABLE `okayapi_travel_depot_logs` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` int(8) NOT NULL COMMENT '',
    `okayapi_travel_depot_logs_action` set('return','export','cancel','import') NOT NULL DEFAULT 'import' COMMENT '入库，出库，返库, 作废 记录',
    `created` bigint(12) NOT NULL DEFAULT '0' COMMENT '',
    `start_no` varchar(100) NOT NULL COMMENT '票号',
    `end_no` varchar(100) NOT NULL COMMENT '',
    `okayapi_travel_depot_logs_number` int(3) NOT NULL DEFAULT '0' COMMENT '入库张数',
    KEY `user_id` (`user_id`),
    KEY `okayapi_travel_depot_logs_action` (`okayapi_travel_depot_logs_action`),
    KEY `created` (`created`),
    KEY `start_no` (`start_no`),
    KEY `end_no` (`end_no`),
    KEY `okayapi_travel_depot_logs_number` (`okayapi_travel_depot_logs_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-6 of 6 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
user_id	int(8)		否		Normal Index
okayapi_travel_depot_logs_action	set('return','export','cancel','import')	import	否	入库，出库，返库, 作废记录		import
created	bigint(12)	0	否			0
start_no	varchar(100)		否	票号
end_no	varchar(100)		否
okayapi_travel_depot_logs_number	int(3)	0	否	入库张数		0