"Information Tracking and Data Management For The Agricultural Industry"
 
Base Data

These are the tables that allow us to uniquely identify each of the root components in a crop.
Foundation Seed
Product Name
Product No
Lot No
Mfg By
Mfg Date
Germination
This table would contain all of the pertinent information required to identify the seed used, so the limits of its usage could be found.

Grower

Name
Street
City
State, Zip
Phone
Email
This table contains the information to identify the individual grower.
CropField
Lot Serial #
GRower ID
Land Desc.
State
Gps Data
Acres
Growing
Last Grew
These are the tables that allow us to uniquely identify each of the root components in a crop.

 

From this point on we have all we need for everyday tracking of the item within the one table shown below.

The type of crop, and so its compatibility, can be coded into it's ID number. this would allow you to carry the necessary data to detect potential blending difficulties at remote sites without the need to be connected to the Internet or carry a copy of a large and cumbersome amount of data.

The information on the component parts of a crop are always available from an Internet connection by simply querying the main database using the Contract ID No.

Central Data


This table becomes the means to uniquely identifying each crop.
Corn Contract
Contract No. This table will have an accompanying
"event" table where entries regarding
what has happened to this crop since
it left the field. This would include
recording the carriers who transported
it, what types of processing it received
etc..
Seed Serial No.
Start Date
Grower ID
Crop Field
Crop Type
Harvest Date
Ship Date
Test Wt
Moisture Content
Dry Yield
Adj. Yield

Click here to Proceed

Copyright,2002 AgDataOne,Inc