okayapi_lvyou_jee_line_pin - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_lvyou_jee_line_pin：/tablelist/okayapi_lvyou_jee_line_pin.html


-- MySQL Table okayapi_lvyou_jee_line_pin
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_line_pin` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_lvyou_jee_line_pin_type` tinyint(4) NULL DEFAULT '0' COMMENT '',
    `state` tinyint(4) NULL DEFAULT '0' COMMENT '',
    `orderid` varchar(20) NULL DEFAULT '0' COMMENT '支付订单号',
    `lid` int(11) NULL DEFAULT '0' COMMENT '',
    `lcode` varchar(50) NULL COMMENT '',
    `cmoney` int(11) NULL DEFAULT '0' COMMENT '',
    `num` int(11) NULL DEFAULT '0' COMMENT '',
    `price` int(11) NULL DEFAULT '0' COMMENT '',
    `payclass` int(11) NULL DEFAULT '0' COMMENT '',
    `tuan_name` varchar(50) NULL COMMENT '',
    `okayapi_lvyou_jee_line_pin_start` varchar(50) NULL COMMENT '',
    `okayapi_lvyou_jee_line_pin_ends` varchar(50) NULL COMMENT '',
    `people` int(11) NULL DEFAULT '0' COMMENT '',
    `woman` int(11) NULL DEFAULT '0' COMMENT '',
    `chd` int(11) NULL DEFAULT '0' COMMENT '',
    `mins` int(11) NULL DEFAULT '0' COMMENT '',
    `maxs` int(11) NULL DEFAULT '0' COMMENT '',
    `must` tinyint(4) NULL DEFAULT '0' COMMENT '',
    `cheap` int(11) NULL DEFAULT '0' COMMENT '',
    `okayapi_lvyou_jee_line_pin_name` varchar(50) NULL COMMENT '',
    `phone` varchar(50) NULL COMMENT '',
    `phones` varchar(50) NULL COMMENT '',
    `email` varchar(50) NULL COMMENT '',
    `okayapi_lvyou_jee_line_pin_desc` varchar(255) NULL COMMENT '',
    KEY `okayapi_lvyou_jee_line_pin_type` (`okayapi_lvyou_jee_line_pin_type`),
    KEY `state` (`state`),
    KEY `orderid` (`orderid`),
    KEY `lid` (`lid`),
    KEY `lcode` (`lcode`),
    KEY `cmoney` (`cmoney`),
    KEY `num` (`num`),
    KEY `price` (`price`),
    KEY `payclass` (`payclass`),
    KEY `tuan_name` (`tuan_name`),
    KEY `okayapi_lvyou_jee_line_pin_start` (`okayapi_lvyou_jee_line_pin_start`),
    KEY `okayapi_lvyou_jee_line_pin_ends` (`okayapi_lvyou_jee_line_pin_ends`),
    KEY `people` (`people`),
    KEY `woman` (`woman`),
    KEY `chd` (`chd`),
    KEY `mins` (`mins`),
    KEY `maxs` (`maxs`),
    KEY `must` (`must`),
    KEY `cheap` (`cheap`),
    KEY `okayapi_lvyou_jee_line_pin_name` (`okayapi_lvyou_jee_line_pin_name`),
    KEY `phone` (`phone`),
    KEY `phones` (`phones`),
    KEY `email` (`email`),
    KEY `okayapi_lvyou_jee_line_pin_desc` (`okayapi_lvyou_jee_line_pin_desc`),
    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-24 of 24 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
okayapi_lvyou_jee_line_pin_type	tinyint(4)	0	是		0
state	tinyint(4)	0	是		0
orderid	varchar(20)	0	是	支付订单号	0
lid	int(11)	0	是		0
lcode	varchar(50)		是
cmoney	int(11)	0	是		0
num	int(11)	0	是		0
price	int(11)	0	是		0
payclass	int(11)	0	是		0
tuan_name	varchar(50)		是
okayapi_lvyou_jee_line_pin_start	varchar(50)		是
okayapi_lvyou_jee_line_pin_ends	varchar(50)		是
people	int(11)	0	是		0
woman	int(11)	0	是		0
chd	int(11)	0	是		0
mins	int(11)	0	是		0
maxs	int(11)	0	是		0
must	tinyint(4)	0	是		0
cheap	int(11)	0	是		0
okayapi_lvyou_jee_line_pin_name	varchar(50)		是
phone	varchar(50)		是
phones	varchar(50)		是
email	varchar(50)		是
okayapi_lvyou_jee_line_pin_desc	varchar(255)		是