Java Backend Hibernate Inheritance

SQL Code

USE jadedb;
DROP TABLE IF EXISTS vehicle;
CREATE TABLE vehicle(
     id          INT UNSIGNED auto_increment PRIMARY KEY,
     `type`      VARCHAR(50) NOT NULL,
     -- moto, car, aircraft, ship
     `name`      VARCHAR(50) NOT NULL,
     numdoor     INT,
     numfootrest INT
);

INSERT INTO vehicle
            (`type`,
             `name`,
             numdoor,
             numfootrest)
VALUES      ("moto",
             "h2r",
             NULL,
             4);

INSERT INTO vehicle
            (`type`,
             `name`,
             numdoor,
             numfootrest)
VALUES      ("moto",
             "z1000",
             NULL,
             4);

INSERT INTO vehicle
            (`type`,
             `name`,
             numdoor,
             numfootrest)
VALUES      ("car",
             "honda civic",
             4,
             NULL);

SELECT *
FROM   vehicle