MySQL Create Table SQL
Table Structure: okayapi_charter_car_book:/tablelist/okayapi_charter_car_book.html
-- MySQL Table okayapi_charter_car_book
-- From: OkayAPI.com
CREATE TABLE `okayapi_charter_car_book` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`car_id` int(11) NULL COMMENT '对应car里面的id',
`name` varchar(50) NULL COMMENT '姓名',
`school` int(11) NULL COMMENT '学校id',
`campus` int(11) NULL COMMENT '校区id',
`is_sick` int(11) NULL COMMENT '是否晕车(0表示否,1表示是)',
`tag` int(11) NULL COMMENT '确认(0表示是,1表示取消)',
KEY `car_id` (`car_id`),
KEY `name` (`name`),
KEY `school` (`school`),
KEY `campus` (`campus`),
KEY `is_sick` (`is_sick`),
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-6 of 6 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
car_id | int(11) | 是 | 对应car里面的id | |||
name | varchar(50) | 是 | 姓名 | |||
school | int(11) | 是 | 学校id | |||
campus | int(11) | 是 | 校区id | |||
is_sick | int(11) | 是 | 是否晕车(0表示否,1表示是) | |||
tag | int(11) | 是 | 确认(0表示是,1表示取消) |