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