create table plants (
    plantID varchar(32) primary key,
    name varchar(64) not null,
    hasImage boolean default false,
    scientificName varchar(64) not null,
    care varchar(32) not null,
    co2 boolean default false not null,
    growthRate varchar(32) not null,
    placement varchar(32) not null,
    lightingRequirements varchar(32) not null,
    color varchar(32) not null,
    maxSize varchar(64) not null,
    propagation varchar(256) not null,
    recommendedFertilizer varchar(32) not null,
    description text not null
);
