🎮 Foghaven Game Store

A full-stack game store web application where users can browse, purchase, and manage their game library.
Built with Flask (Python), React (JavaScript), and SQLite.

---

👥 Team

• Eric Cun
• Quang Pham

---

🚀 Features

• 🕹️ Browse games with detailed descriptions, screenshots, and achievements
• 🏷️ Filter games by genres and supported platforms
• 👤 User system with authentication, payment methods, account balance, and game ownership
• ⭐ Star rating system
• 📸 Game galleries with banners and screenshots
• 🔑 Admin controls for managing games and users

---

🗂️ Database Schema

Main entities include:

• Games: title, images, price, descriptions, developer/publisher info, release date
• Users: account details, balances, admin/active status
• Genres, Platforms: categorizations for games
• Screenshots, Movies, Achievements, Payment Cards: one-to-many game assets
• GameUsers: many-to-many relation tracking ownership, ratings, and purchases
• GameGenres, GamePlatforms: many-to-many relations for metadata

---

🛠️ Tech Stack

• Backend: Flask (Python), SQLAlchemy
• Frontend: React (JavaScript), Vite, Tailwind CSS
• Database: SQLite