+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
charter_timedatetime包车开始时间
license_platevarchar(50)车牌号码
beginvarchar(50)起点
endvarchar(50)终点
faredecimal(10,0)车票
schoolint(255)学校id
campusint(255)校区id
max_containint(255)最大容纳人数
carsicknessint(255)晕车人数
peopletext乘车人员(json格式化后存,id=>uuid)
leadertext跟车人(json格式化后存,id=>uuid)
tagint(11)0未开始,1正在进行,2已结束

Guess You Like

MySQL Table Design okayapi_mobile

MySQL Table Design okayapi_qq

MySQL Table Design okayapi_rank

MySQL Table Design okayapi_moment

MySQL Table Design okayapi_user

MySQL Table Design okayapi_friend

MySQL Table Design okayapi_qq_login

MySQL Table Design okayapi_lend_book

MySQL Table Design okayapi_charter_car_book

TOP ↑