MySQL Create Table SQL
Table Structure: okayapi_charter_car_info:/tablelist/okayapi_charter_car_info.html
-- MySQL Table okayapi_charter_car_info
-- From: OkayAPI.com
CREATE TABLE `okayapi_charter_car_info` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`charter_time` datetime NULL COMMENT '包车开始时间',
`license_plate` varchar(50) NULL COMMENT '车牌号码',
`begin` varchar(50) NULL COMMENT '起点',
`end` varchar(50) NULL COMMENT '终点',
`fare` decimal(10,0) NULL COMMENT '车票',
`school` int(255) NULL COMMENT '学校id',
`campus` int(255) NULL COMMENT '校区id',
`max_contain` int(255) NULL COMMENT '最大容纳人数',
`carsickness` int(255) NULL COMMENT '晕车人数',
`people` text NULL COMMENT '乘车人员(json格式化后存,id=>uuid)',
`leader` text NULL COMMENT '跟车人(json格式化后存,id=>uuid)',
`tag` int(11) NULL COMMENT '0未开始,1正在进行,2已结束',
KEY `charter_time` (`charter_time`),
KEY `license_plate` (`license_plate`),
KEY `begin` (`begin`),
KEY `end` (`end`),
KEY `fare` (`fare`),
KEY `school` (`school`),
KEY `campus` (`campus`),
KEY `max_contain` (`max_contain`),
KEY `carsickness` (`carsickness`),
KEY `people` (`people`),
KEY `leader` (`leader`),
KEY `tag` (`tag`),
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-12 of 12 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
charter_time | datetime | 是 | 包车开始时间 | |||
license_plate | varchar(50) | 是 | 车牌号码 | |||
begin | varchar(50) | 是 | 起点 | |||
end | varchar(50) | 是 | 终点 | |||
fare | decimal(10,0) | 是 | 车票 | |||
school | int(255) | 是 | 学校id | |||
campus | int(255) | 是 | 校区id | |||
max_contain | int(255) | 是 | 最大容纳人数 | |||
carsickness | int(255) | 是 | 晕车人数 | |||
people | text | 是 | 乘车人员(json格式化后存,id=>uuid) | |||
leader | text | 是 | 跟车人(json格式化后存,id=>uuid) | |||
tag | int(11) | 是 | 0未开始,1正在进行,2已结束 |