hackathon

Tables (5)

Untitled (check)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (check_date) — DATETIME
  • Field (content) — VARCHAR(255)
  • id (user_id) — INT — Foreign key → user.id — NOT NULL

Untitled (honor_rank)

  • Key (id) — INT — Primary key — NOT NULL
  • id (first_user_id) — INT — Foreign key → user.id — NOT NULL
  • id (second_user_id) — INT — Foreign key → user.id — NOT NULL
  • id (third_user_id) — INT — Foreign key → user.id — NOT NULL
  • Field (week) — INT
  • Field (month) — INT

Untitled (user_rival)

  • id (to_user) — INT — Foreign key → user.id — NOT NULL
  • Field (from_user) — INT

Untitled (prev_first)

  • id (prev_id) — INT — Foreign key → user.id — NOT NULL

user

  • id — INT — Primary key — NOT NULL
  • Field (nickname) — VARCHAR(255)
  • Field (GitHub_email) — VARCHAR(255)
  • Field (profile_image_url) — VARCHAR(255)
  • Field (point) — INT
  • Field (commit_streak) — INT
  • Field (github_url) — VARCHAR(255)