name-solver

Tables (5)

Match (Untitled4)

  • match_id (Key) — Primary key — NOT NULL
  • started_at (Field3)
  • end_at (Field)
  • type (Field2)
  • requester_start_rating (Field4)
  • accepter_start_rating (Field5)
  • requester (Key2) — Foreign key → Member.member_id — NOT NULL
  • accepter (Key3) — Foreign key → Member.member_id — NOT NULL

MatchRecord (Untitled5)

  • record_id (Key) — Primary key — NOT NULL
  • started_at (Field)
  • end_at (Field2)
  • type (Field3)
  • winner_increase_rating (Field4)
  • loser_increase_rating (Field5)
  • winner (Key2) — Foreign key → Member.member_id — NOT NULL
  • loser (Key3) — Foreign key → Member.member_id — NOT NULL

MatchRequest (Untitled2)

  • match_id (Key) — Primary key — NOT NULL
  • created_at (Field)
  • title (Field2)
  • member_id (Key2) — Foreign key → Member.member_id — NOT NULL

MatchRequestCandidate (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • match_id (Key2) — Foreign key → MatchRequest.match_id — NOT NULL
  • member_id (Key3) — Foreign key → Member.member_id — NOT NULL
  • response (Field)

Member (Untitled)

  • member_id (Key) — Primary key — NOT NULL
  • name (Field)
  • email (Field2)
  • solvedac_name (Field3)