Food Bank Customization Overview

The overall objective of the labs is to build a food bank management tool that allows a charitable organization/food bank to receive, distribute, manage, and track food inventory. A food bank is an extension of an organization constituent record. The food bank transaction (TX) header table stores top-level inventory transaction records for a food bank. Every time someone donates to or receives food from a food bank, a row is created in this table. Top-level transaction information such as the constituent who donated or received food, the total amount of food in the transaction, the transaction date, and receipt information are tracked in this table. The food bank transaction detail table stores the individual food items and amounts for a given transaction. If a user donates a gallon of milk, five boxes of cereal, and 10 cans of vegetables, then one row is created in the transaction header table and three rows are created in the transaction detail table. The transaction detail table references the food item table that is simple list of Food SKUs such as cereal, rice, or canned soup.