Vehicle Part

gistfile1.sql

CREATE TABLE vcdb_VehiclePart (
	ID int IDENTITY(1,1) PRIMARY KEY NOT NULL,
	BaseVehicleID int NOT NULL FOREIGN KEY REFERENCES BaseVehicle (ID),
	SubmodelID int NOT NULL FOREIGN KEY REFERENCES Submodel (ID),
	PartNumber int NOT NULL,
	VehicleConfigID int NULL FOREIGN KEY REFERENCES VehicleConfig (ID)
)
GO

CREATE TABLE VehicleConfig (
	ID int IDENTITY(1,1) PRIMARY KEY NOT NULL,
	AAIAVehicleConfigID int NOT NULL,
	differentiator varchar(250) NULL
)
GO