CREATE TABLE tankSizes (
    tankSizeID VARCHAR(32) PRIMARY KEY,
    manufacturerID VARCHAR(32) NOT NULL references manufacturers(manufacturerID),
    abbreviation varchar(16),
    length FLOAT NOT NULL,
    width FLOAT NOT NULL,
    height FLOAT NOT NULL,
    gallonsCommon FLOAT NOT NULL,
    gallonsExact FLOAT,
    link VARCHAR(128)
);
