1

Tables (5)

Chat

  • chat_id — INT — Primary key — NOT NULL
  • matching_id — INT — Foreign key → Matching.matching_id — NOT NULL
  • sender_id — INT — Foreign key → User.user_id — NOT NULL
  • message — TEXT
  • sent_at — DATETIME

Game_Profile

  • profile_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.user_id — NOT NULL
  • game_name — VARCHAR(50)
  • rank_level — VARCHAR(30)
  • position — VARCHAR(30)
  • play_time — VARCHAR(50)
  • mic_use — BOOLEAN

Matching

  • matching_id — INT — Primary key — NOT NULL
  • sender_id — INT — Foreign key → User.user_id — NOT NULL
  • receiver_id — INT — Foreign key → User.user_id — NOT NULL
  • status — VARCHAR(20)
  • created_at — DATETIME

Review

  • review_id — INT — Primary key — NOT NULL
  • reviewer_id — INT — Foreign key → User.user_id — NOT NULL
  • target_id — INT — Foreign key → User.user_id — NOT NULL
  • rating — INT
  • content — TEXT
  • created_at — DATETIME

User

  • user_id — INT — Primary key — NOT NULL
  • name — VARCHAR(50)
  • email — VARCHAR(100)
  • password — VARCHAR(100)
  • nickname — VARCHAR(50)
  • created_at — DATETIME