Skip to main content

Entity-Relationship Diagram – NAVIGO

This document shows the Entity-Relationship Diagram for the NAVIGO application.
It visualizes the relationships between the main entities used in the application, including users, quests, collectibles, and leaderboards.

1. ERD Overview​

The ERD highlights the following entities and their relationships:

  • Users

    • Stores user information (name, email, profile picture, points).
    • Related to UserQuests and CollectedItems.

  • Quests

    • Contains quest information (title, description, location, difficulty).
    • Related to UserQuests for tracking quest completions.

  • UserQuests

    • A join table tracking which quests each user has completed.
    • Includes completion date and points awarded.

  • Collectibles

    • Badges and rewards users can earn.
    • Related to CollectedItems for user ownership.

  • CollectedItems

    • Tracks which collectibles each user has collected.
    • Includes collection date and status.

  • Leaderboard

    • Aggregates user points and ranks users based on their achievements.
    • Updates automatically when users complete quests or earn collectibles.

2. ERD Image​

NAVIGO ERD