MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_order_userinfo：/tablelist/okayapi_lvyou_jee_order_userinfo.html
-- MySQL Table okayapi_lvyou_jee_order_userinfo
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_order_userinfo` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL COMMENT '订单表ID号（非订单号）',
`okayapi_lvyou_jee_order_userinfo_names` varchar(16) NOT NULL COMMENT '用户姓名',
`old_type` smallint(2) NOT NULL DEFAULT '1' COMMENT '',
`credentials` smallint(2) NOT NULL COMMENT '证件类型',
`content` varchar(120) NOT NULL COMMENT '信息内容',
`okayapi_lvyou_jee_order_userinfo_type` varchar(10) NOT NULL COMMENT '信息所属分类（酒店、景点或线路）',
KEY `order_id` (`order_id`),
KEY `okayapi_lvyou_jee_order_userinfo_names` (`okayapi_lvyou_jee_order_userinfo_names`),
KEY `old_type` (`old_type`),
KEY `credentials` (`credentials`),
KEY `content` (`content`),
KEY `okayapi_lvyou_jee_order_userinfo_type` (`okayapi_lvyou_jee_order_userinfo_type`),
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-6 of 6 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| order_id | int(11) | 否 | 订单表ID号（非订单号） | |||
| okayapi_lvyou_jee_order_userinfo_names | varchar(16) | 否 | 用户姓名 | |||
| old_type | smallint(2) | 1 | 是 | 1 | ||
| credentials | smallint(2) | 否 | 证件类型 | |||
| content | varchar(120) | 是 | 信息内容 | |||
| okayapi_lvyou_jee_order_userinfo_type | varchar(10) | 否 | 信息所属分类（酒店、景点或线路） |
