need help database

I'm learning mysql. I'm 50 + years old. So this may be slow. If I am sucessful it will belong to rollitup.

data base rollitup has been created
data base rollitup is connected

the first table I'm entering is seed;

I need to know from experience what are the types of info that needs to go with seed and how should it be broken down.

I don't mind the work I just don't want to add any dead horse info.

If your riding a dead horse your not going to get very far.

here is what I have so far

Table Seeds
name
soil
hydro
in_door
out_door
sativia
indicia
date

Hey man,

Some suggestions that will help make your DB a little more scaleable...

I would rearrange your table structure to something like this to make it more relational.

tblSeeds:
SeedID (int -- Identity -- Primary Key)
Name (varchar(255))
SoilID (int -- ID that maps to a lookup table)
PlantTypeID (int -- ID that maps to a lookup table)
DateEntered (default to GetDate())

lpkPlantTypes
PlantTypeID (int -- Identity -- Primary Key)
Name (indoor, outdoor, greenhouse, etc)

lpkSoils
SoilID (int -- Identity -- Primary Key)
SoilName (Hydro, miracle grow, etc)
PH
etc.....


I have been working on a grow journal program myself, that sounds similiar to what your making. Send me a PM and I can share what I have come up with for a DB structure so far.

Been doing DB design for 10+ years now, so I may be able to teach ya a thing or two =)

Cheers,
-Bwbig

Thanks I'm just starting.