Comments Table

The purpose of this table is to hold any comments that a user might add to records in some of the other tables in the database.

Comments are optional on the records where they are allowed.  By putting the comments in a separate table, space should be saved in the other tables and searching will be more efficient.

Table Layout

Column Type Length Description
Comments_ID Number (Long)
4
 Unique ID for each comment record
Modified Date/Time
8
 Timestamp when this record was last modified.
Modified_By Number (Long)
4
 Record ID for the food detective that last updated this record.
Created Date/Time
8
 Timestamp when this record was created.
Created_By Number (Long)
4
 Record ID for the food detective that created this record.
Comment_Text Text variable The text of the comments.

Relationships

Each record in the Allergen, Allergens, Allergen_Category, Company, Food Detective and Location tables can have user comments. This can be a one to one relationship between these records and those records.

The Modified_By and Created_By fields in these records each point to single records in the Food Detective table. Because a food detective can create multiple entries in the database, this can produce a many to one relationship between these records and the Food Detective records.

See also:

Allergen Table,
Allergens Table,
Allergen Category Table,
Company Table,
Food Detective Table,
Location Table.
Send comments and suggestions to:
DBA@AllergyFreeFood.org

Home | Documentation

Last updated on 12/11/00