Harvest Leader Manual

  Database: tables


Certified ('Ripe') harvest leaders are able to use the web site’s database to access information that may be useful for preparing for and leading harvests. They are able to view and change information that is there. Trainee ('Green') harvest leaders can access only pages that show information, not those where it can be changed. Merced County Gleaning and its volunteers depend heavily on the completeness and accuracy of the information in the database, so changes should be made very carefully. Remember that many people are relying on it. If for instance, a harvest time is incorrect dozens of people may arrive when there is no harvest. Harvest leaders do not need to know how the database pages work in any technical detail, but they must be comfortable and familiar with how to find and update information.

This section of the manual describes the database and how to find and change information in it. The pages that harvest leaders can see are not public and the information on them is confidential. It should be used only for official Merced County Gleaning business. The pages are protected by passwords. Approved harvest leaders have a username and password. The username is the initial of the first name plus the last name, all in lower case letters. So Susan Smith’s username is ssmith and John Volunteer’s username is jvolunteer. Passwords are assigned and can be changed only by the database manager. Please let him know if you think someone has accessed your password and it will be changed.

When you first try to look at a password protected page, you will be shown a login page. Enter your username and password. If at any time you click on a link to a page that your access level does not allow, you will again see the login page. If this happens, simply use the back button on your browser to return to the previous page that you did have access to.

Database tables

The database is just a collection of lists called ‘database tables.’ Various web pages pull information from the lists and combine it. Harvest leaders do not need to know in detail how these work but a general familiarity can be helpful. The main tables are:

Crops: A list of all the crops that have been registered. Each line in the table has the owner’s name and contact information, the address, type of crop, etc.

Volunteers: A list of all the people who have registered as volunteers. This includes information such as: name and contact information, interest in leading or assisting, computer IP address, ladder safety test score, etc.

Harvests: A list of all the harvest sessions. Information includes, among other things, the particular crop to be harvested (this is a number that refers to the Crop list), the harvest date and time, harvest leaders (these are numbers that refer to the People list), how many volunteers are to be on the roster, the weight of the produce that was picked, and information to be displayed when the harvest is posted.

Rosters: This is a list of all the roster slots for all harvests. Some of the information in this list refers back to the Volunteers and Harvests tables: the harvest number, the volunteer number, volunteer name, attendance at that harvest, and computer IP address.

There are other tables in the database but these are the ones with information that harvest leaders may need.


Certified ('Ripe') harvest leaders are able to use the web site’s database to access information that may be useful for preparing for and leading harvests. They are able to view and change information that is there. Trainee ('Green') harvest leaders can access only pages that show information, not those where it can be changed. Merced County Gleaning and its volunteers depend heavily on the completeness and accuracy of the information in the database, so changes should be made . Remember that many people are relying on it. If for instance, a harvest time is incorrect dozens of people may arrive when there is no harvest. Harvest leaders do not need to know how the database pages work in any technical detail, but they must be comfortable and familiar with how to find and update information.

This section of the manual describes the database and how to find and change information in it. The pages that harvest leaders can see are not public and the information on them is confidential. It should be used only for official Merced County Gleaning business. The pages are protected by passwords. Approved harvest leaders have a username and password. The username is the initial of the first name plus the last name, all in lower case letters. So Susan Smith’s username is ssmith and John Volunteer’s username is jvolunteer. Passwords are assigned and can be changed only by the database manager. Please let him know if you think someone has accessed your password and it will be changed.

When you first try to look at a password protected page, you will be shown a login page. Enter your username and password. If at any time you click on a link to a page that your access level does not allow, you will again see the login page. If this happens, simply use the back button on your browser to return to the previous page that you did have access to.

Database tables

The database is just a collection of lists called ‘database tables.’ Various web pages pull information from the lists and combine it. Harvest leaders do not need to know in detail how these work but a general familiarity can be helpful. The main tables are:

Crops: A list of all the crops that have been registered. Each line in the table has the owner’s name and contact information, the address, type of crop, etc.

Volunteers: A list of all the people who have registered as volunteers. This includes information such as: name and contact information, interest in leading or assisting, computer IP address, ladder safety test score, etc.

Harvests: A list of all the harvest sessions. Information includes, among other things, the particular crop to be harvested (this is a number that refers to the Crop list), the harvest date and time, harvest leaders (these are numbers that refer to the People list), how many volunteers are to be on the roster, the weight of the produce that was picked, and information to be displayed when the harvest is posted.

Rosters: This is a list of all the roster slots for all harvests. Some of the information in this list refers back to the Volunteers and Harvests tables: the harvest number, the volunteer number, volunteer name, attendance at that harvest, and computer IP address.

There are other tables in the database but these are the ones with information that harvest leaders may need.


Ripe harvest leaders:
can delete information in the database tables that is incorrect.
Can change their passwords directly.
Have a responsibility to change information carefully.
All harvest leaders can:
View information about schedules, crops, harvests, rosters and volunteers.
View information about schedules, crops, passwords, rosters and volunteers.
Change information about schedules, crops, harvests, rosters and volunteers.
The Harvests table:
Contains the list of everyone who attended.
Contains the weight of produce that was donated.
Contains a list of assistants that participated.
Deleting database records:
Means that the information can not be recovered.
Should be done by Ripe harvest leaders very carefully.
Can be done only by the database manager.