Skip to main content
Version: Capstone Spring 2025 (Archived)

Entity Relation Diagram

Figure 1. ER Diagram & Design Schema of the CLOVER.

This database schema represents an AI-assisted code suggestion and user progress tracking system. It consists of entities for users, code suggestions, errors and others to help support logging.

  • The AI-MODEL generates CODE-GENERATION entries that lead to CODE-SUGGESTION records, which users interact with.
  • Users respond to suggestions, marking them as correct or modifying them, and these interactions are recorded in CODE-RESPONSE.
  • ADMIN oversees user progress, tracking warnings and limitations in the PROGRESS table, which stores levels and statuses based on user activity.
  • The PROGRESS-RESPONSE table links progress tracking to specific code suggestions.

This schema enables monitoring of user engagement with AI-generated code suggestions while maintaining administrative oversight.