TC

Tables (7)

Friends

  • Key — Primary key — NOT NULL
  • 요청 건 사람 (UID) — integer — Foreign key → User.유저ID — NOT NULL
  • 요청 받은 사람 (UID2) — integer — Foreign key → User.유저ID — NOT NULL

Match

  • match_id (TID) — Primary key — NOT NULL
  • round (0)
  • status (Field2)
  • tm_id (GID) — Foreign key → Tournament.tm_id — NOT NULL

Match_1on1 (CopyOfMatch)

  • 1on1_id (TID) — Primary key — NOT NULL
  • user1_점수 (Field3) — NOT NULL
  • user2_점수 (Field4) — NOT NULL
  • status (Field5) — NOT NULL
  • 유저1 (UID) — integer — Foreign key → User.유저ID — NOT NULL
  • 유저2 (UID2) — integer — Foreign key → User.유저ID — NOT NULL

Participant (CopyOfTornament)

  • Participant_id (GID) — Primary key — NOT NULL
  • tm_id (GID2) — Foreign key → Tournament.tm_id — NOT NULL
  • 유저ID (UID) — integer — Foreign key → User.유저ID — NOT NULL

Tournament (Tornament)

  • tm_id (GID) — Primary key — NOT NULL
  • status (Field2)

User

  • 유저ID (UID) — integer — Primary key — NOT NULL
  • 닉네임 (Nickname) — varchar — NOT NULL — unique
  • 비밀번호 (Password) — text — NOT NULL
  • 포로필 이미지 (Profile) — text
  • 이메일 (email) — text — NOT NULL

matchResult (CopyOfMatch2)

  • id (TID) — Primary key — NOT NULL
  • score (Field) — NOT NULL
  • match_id (TID2) — Foreign key → Match.match_id — NOT NULL
  • Participant_id (GID) — Foreign key → Participant.Participant_id — NOT NULL