okayapi_jeewms_jform_order_ticket - MySQ Table Design - OkayAPI.com

+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_jeewms_jform_order_ticket：/tablelist/okayapi_jeewms_jform_order_ticket.html


-- MySQL Table okayapi_jeewms_jform_order_ticket
-- From: OkayAPI.com
CREATE TABLE `okayapi_jeewms_jform_order_ticket` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `ticket_code` varchar(100) NOT NULL COMMENT '航班号',
    `tickect_date` datetime NOT NULL COMMENT '航班时间',
    `fck_id` varchar(36) NOT NULL COMMENT '外键',
    KEY `ticket_code` (`ticket_code`),
    KEY `tickect_date` (`tickect_date`),
    KEY `fck_id` (`fck_id`),
    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
ticket_code	varchar(100)		是	航班号
tickect_date	datetime		是	航班时间
fck_id	varchar(36)		否	外键

Guess You Like

MySQL Table Design okayapi_jeewms_ba_act_type

MySQL Table Design okayapi_jeewms_ba_area

MySQL Table Design okayapi_jeewms_ba_barea

MySQL Table Design okayapi_jeewms_ba_bin_type

MySQL Table Design okayapi_jeewms_ba_buss_type

MySQL Table Design okayapi_jeewms_ba_city

MySQL Table Design okayapi_jeewms_ba_city_type

MySQL Table Design okayapi_jeewms_ba_classfl

MySQL Table Design okayapi_jeewms_ba_com_deg

MySQL Table Design okayapi_jeewms_ba_com_type

MySQL Table Design okayapi_jeewms_ba_comp

MySQL Table Design okayapi_jeewms_ba_cont_spec

MySQL Table Design okayapi_jeewms_ba_cont_type

MySQL Table Design okayapi_jeewms_ba_cost

MySQL Table Design okayapi_jeewms_ba_cost_conf

MySQL Table Design okayapi_jeewms_ba_cost_type

MySQL Table Design okayapi_jeewms_ba_cus_sta

MySQL Table Design okayapi_jeewms_ba_deg_type

MySQL Table Design okayapi_jeewms_ba_del_mode

MySQL Table Design okayapi_jeewms_ba_edu_sta