DROP TABLE Vehicle IF EXISTS; /* Datasource created */ DROP TABLE AutoMaker IF EXISTS; /* Datasource created */ /**********************************/ /* Table Name: AutoMaker */ /**********************************/ CREATE TABLE AutoMaker( AutoMakerID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 101, INCREMENT BY 1), AutoMakerName VARCHAR(64) NOT NULL, CONSTRAINT IDX_AutoMakerName UNIQUE (AutoMakerName) ); /**********************************/ /* Table Name: Vehicle */ /**********************************/ CREATE TABLE Vehicle( VehicleID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 101, INCREMENT BY 1), VehicleName VARCHAR(64) NOT NULL, AutoMakerID BIGINT NOT NULL, CONSTRAINT IDX_Vehicle_AutoMaker FOREIGN KEY (AutoMakerID) REFERENCES AutoMaker (AutoMakerID), CONSTRAINT IDX_VehicleName UNIQUE (VehicleName) );