Schema

Schema

1. User Table UserID: Integer - Uniquely identifies each user. Username: String - The user's chosen username. Email: String - The user's email address. Password: String - Stored in encrypted form for security.

2. Item Table ItemID: Integer - Unique identifier for each item. Name: String - Name of the item. Description: String - A brief description of the item.

3. ScavengerHunt Table WalkID: Integer - Unique identifier for each scavenger hunt. UserID: Integer - References User.UserID. Links the hunt to a specific user.

4. Image Table ImageID: Integer - Unique identifier for each image. WalkID: Integer - References ScavengerHunt.WalkID. Connects the image to a specific scavenger hunt. ItemID: Integer - References Item.ItemID. Indicates which item was photographed. URL: String - URL where the image is stored.

5. WalkItems Table WalkItemID: Integer - Unique identifier for each scavenger hunt-item association. WalkID: Integer - References ScavengerHunt.WalkID. Links to a specific scavenger hunt. ItemID: Integer - References Item.ItemID. Links to a specific item. Found: Boolean - Indicates whether the item was found during the hunt.

Relationships

• User-ScavengerHunt Relationship: One-to-Many (One user can initiate multiple scavenger hunts, but each hunt is associated with one user). - ScavengerHunt-Image Relationship: One-to-Many (Each scavenger hunt can have multiple images, each image belongs to one hunt).
• Item-Image Relationship: One-to-Many (An item can be photographed multiple times in different hunts, but each image is of one specific item).
• ScavengerHunt-WalkItems Relationship: One-to-Many (Each scavenger hunt can include searching for multiple items).
• Item-WalkItems Relationship: One-to-Many (Items can be included in multiple hunts through the WalkItems association, representing a many-to-many relationship facilitated by WalkItems).