Skip to content

Database Schema

Evergreeners uses a relational database (PostgreSQL) managed with Drizzle ORM.

  • id: UUID (Primary Key)
  • username: String (Unique)
  • email: String (Unique)
  • github_id: String
  • reputation: Integer
  • id: UUID
  • user_id: UUID (Foreign Key)
  • current_count: Integer
  • highest_count: Integer
  • last_activity_at: Timestamp
  • id: UUID
  • title: String
  • description: Text
  • xp_reward: Integer
  • type: Enum (onboarding, skill, community)
  • A User has one Streak.
  • A User can have many Quests (through a join table user_quests).
  • A User can track many Repositories.