Database Schema
Database Schema
Section titled “Database Schema”Evergreeners uses a relational database (PostgreSQL) managed with Drizzle ORM.
Core Tables
Section titled “Core Tables”id: UUID (Primary Key)username: String (Unique)email: String (Unique)github_id: Stringreputation: Integer
streaks
Section titled “streaks”id: UUIDuser_id: UUID (Foreign Key)current_count: Integerhighest_count: Integerlast_activity_at: Timestamp
quests
Section titled “quests”id: UUIDtitle: Stringdescription: Textxp_reward: Integertype: Enum (onboarding, skill, community)
Relationships
Section titled “Relationships”- A User has one Streak.
- A User can have many Quests (through a join table
user_quests). - A User can track many Repositories.