$ Source Code

Frontend

https://github.com/hekoh99/colorOfDay_front

Backend

https://github.com/hekoh99/colorOfTheDay

$ Overview

The goal of this project is to provide a visual representation of your emotional journey over time. By translating your daily moods into colors, you can observe patterns and trends in how you feel throughout the days, weeks, and months.

$ Database Structure

The backend uses a MySQL database to store user mood data. To efficiently manage data load, a new table is created for each year and month (e.g., colorlog_2024_08 for August 2024). This approach helps prevent excessive data accumulation in a single table, optimizing performance and scalability.

Each mood entry is stored as individual RGB values, where each RGB component reflects different emotions:

• Red (R): Achievement
• Green (G): Stability
• Blue (B): Fatigue

These RGB values combine to form a representative color that reflects the user's mood for each day.

Example Table Structure

For a given month, the table might look like this: table name : colorlog_2024_08