Food Detective Table

Food_Detective Table

This table hold identification information for the people that will be contributing information to the database. The Public field allows the individual users to control general viewing rights to other information detailed in that individual record.

While anyone will be allowed to query the database, only people with entries in this table can be granted database modification privileges.

Table Layout

Column	Type	Length	Description
Food_Detective_ID	Number (Long)	4	Unique ID for the a person that has added information to the database.
Name	Text	25	User's name
Email	Text	50	User's email address
Public	Yes/No	1	Can the user's name and contact information be viewed by visitor's to the web site.
Privileges	Text	50	What database modification privileges does this user have.
Comments_ID	Number (Long)	4	Record ID of any comments that the user want to add. (May be NULL)

Relationships

These records are used by the all the other tables. Each record in those tables can point to as many as three records in this table by way of the Modified_By, Created_By and Confirmed_By fields. This is a many to many relationship between this table all the other tables.

The Comments_ID field in this record can point to a record in the Comments Table. This can be a one to one relationship between this table and to that table. If the user does not wish to add any comments to the their information, then this ID field will be NULL.