Codefolio

Tables (5)

achievements

  • achivement_id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • certificate_url — VARCHAR(500)
  • achieved_at — DATE
  • created_at — DATETIME
  • updated_at — DATETIME

applications

  • application_id — BIGINT — Primary key
  • post_id — BIGINT — Foreign key → posts.post_id
  • user_id — BIGINT — Foreign key → posts.user_id
  • status — ENUM('pending','accepted','rejected')
  • applied_at — DATETIME

posts

  • post_id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • target_role — ENUM('student','professor')
  • created_at — DATETIME
  • updated_at — DATETIME

projects

  • project_id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • repo_url — VARCHAR(500)
  • start_date — DATE
  • end_date — DATE
  • created_at — DATETIME
  • updated_at — DATETIME

users

  • user_id — BIGINT — Primary key
  • github_name — VARCHAR(255) — NOT NULL
  • github_id — BIGINT — NOT NULL
  • access_token_encrypted — TEXT
  • scope — VARCHAR(255)
  • last_synced_at — DATETIME
  • role — ENUM('student','professor')
  • email — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME