okayapi_lvyou_jee_ticket_contactor - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_lvyou_jee_ticket_contactor：/tablelist/okayapi_lvyou_jee_ticket_contactor.html


-- MySQL Table okayapi_lvyou_jee_ticket_contactor
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_ticket_contactor` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `contact_name` varchar(256) NULL COMMENT '',
    `contact_phone` varchar(16) NULL COMMENT '',
    `contact_email` varchar(256) NULL COMMENT '',
    `user_id` int(11) NULL COMMENT '',
    `okayapi_lvyou_jee_ticket_contactor_status` int(11) NULL COMMENT '',
    KEY `contact_name` (`contact_name`),
    KEY `contact_phone` (`contact_phone`),
    KEY `contact_email` (`contact_email`),
    KEY `user_id` (`user_id`),
    KEY `okayapi_lvyou_jee_ticket_contactor_status` (`okayapi_lvyou_jee_ticket_contactor_status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'lvyou旅游-联系人';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-5 of 5 results.

Field Name	Field Type	IS NULL
contact_name	varchar(256)	否
contact_phone	varchar(16)	是
contact_email	varchar(256)	是
user_id	int(11)	否
okayapi_lvyou_jee_ticket_contactor_status	int(11)	是