While anyone will be allowed to query the database, only people with entries in this table can be granted database modification privileges.
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 |
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) |
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.
Allergen Table,
Allergens Table,
Allergen Category Table,
Availability Table,
Comments Table,
Company Table,
Cuisine Table,
Establishment Table,
Establishment Type Table,
Item Table,
Item_Category Table,
Location Table,
Region Table.Send comments and suggestions to:
DBA@AllergyFreeFood.orgHome | Documentation Last updated on 12/11/00