create table tankPlants (
    tankPlantID int not null primary key auto_increment,
    tankID varchar(32) not null references tanks(tankID),
    plantID varchar(32) not null references plants(plantID)
);
