+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
car_idint(11)对应car里面的id
namevarchar(50)姓名
schoolint(11)学校id
campusint(11)校区id
is_sickint(11)是否晕车(0表示否,1表示是)
tagint(11)确认(0表示是,1表示取消)

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_info

TOP ↑