*Parent table* : Vehicle
*父表*:车辆
CREATE TABLE `vehicle` (
`vehicle_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`version_number` INT(10) UNSIGNED NULL DEFAULT '0',
`vehicle_no` VARCHAR(64) NOT NULL COLLATE 'utf8_bin',
`vehicle_reg_no` VARCHAR(64) NOT NULL COLLATE 'utf8_bin',
`vehicle_name` VARCHAR(64) NOT NULL COLLATE 'utf8_bin',
`total_seat` INT(15) NOT NULL,
`route_id` INT(10) UNSIGNED NOT NULL,
`available_seat` INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (`vehicle_id`)
)
CREATE TAB