TableSpec for Food Banks

USR_FOODBANK

A food bank is an extension of an organization constituent record. An example of a food bank would be the Lowcountry Food Bank (http://www.lowcountryfoodbank.org). To track food inventory for the Lowcountry Food Bank, we would need to add a constituent record within the CONSTITUENT table and a new row to the new USR_FOODBANK table. A one-to-one relationship will tie the USR_FOODBANK table to the CONSTITUENT table.

<TableSpec
	xmlns="bb_appfx_table"
	xmlns:common="bb_appfx_commontypes"
	ID="8158B4AD-932F-4b4c-86A2-8B8EE17819F3"
	Name="Food Bank"
	Description="The food bank which holds food inventory..."
	Author="Technical Training"
	IsCustomizable="true"
	Tablename="USR_FOODBANK"  
	>

	<!-- define fields on the table -->
	<Fields>

		<ForeignKeyField
			Name="CONSTITUENTID"
			ForeignTable="CONSTITUENT"
			Cardinality="OneToOne"
			Description="Organization that is tied to the food bank. A food bank is a type of organization."
			OnDelete="CascadeDelete"
			Required="false" />

		<MemoField
			Name="DESCRIPTION"
			Description="A description for the food bank"
			/>

		<MemoField
			Name="MISSIONSTATEMENT"
			Description="The mission statement for the food bank"
			/>

		<CodeTableField
			Name="FOODBANKTYPECODEID"
			Description="The type of food bank."
			CodeTable="USR_FOODBANKTYPECODE"
			Required="true"
			/>
	</Fields>
</TableSpec>