MATCH

테이블 (9)

Copy Of Copy Of Copy Of Copy Of Untitled (Duo_lostark)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(255) — NOT NULL
  • Field2 (boss) — varchar(255) — NOT NULL — valtan / viackiss / abrelshud / illiakan / kouku / kamen
  • Field3 (position) — varchar(255) — NOT NULL — deal / heal
  • Field (card) — varchar(255) — NOT NULL — loseight / losthree / klceight / klcthree / lctwelve / lcthree
  • Field6 (voice) — boolean — NOT NULL
  • Field (content) — varchar(255) — NOT NULL
  • Field5 (expire) — varchar(255) — NOT NULL
  • Field7 (regdate) — datetime(6) — NOT NULL

Copy Of Copy Of Copy Of Untitled (Duo_maplestory)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(255) — NOT NULL
  • Field (type) — varchar(255) — NOT NULL — luna / scania / elisium / croa / vera / reboot / others
  • Field2 (boss) — varchar(255) — NOT NULL — suu / demian / guardian / lucid / will / dusk / darknell / hilla / seren / kalos / black
  • Field3 (tier) — varchar(255) — NOT NULL — easy / normal / hard / extream
  • Field6 (voice) — boolean — NOT NULL
  • Field (content) — varchar(255) — NOT NULL
  • Field5 (expire) — varchar(255) — NOT NULL
  • Field7 (regdate) — datetime(6) — NOT NULL

Copy Of Copy Of Untitled (Duo_pubg)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(255) — NOT NULL
  • Field (type) — varchar(255) — NOT NULL — normal_duo / normal_squad / rank_squad / deathmatch
  • Field2 (platform) — varchar(255) — NOT NULL — steam / kakao
  • Field3 (tier) — varchar(255) — NOT NULL — bronze / silver / gold / platinum / diamond / master
  • Field6 (voice) — boolean — NOT NULL
  • Field (fpp) — boolean — NOT NULL
  • Field (content) — varchar(255) — NOT NULL
  • Field5 (expire) — varchar(255) — NOT NULL
  • Field7 (regdate) — datetime(6) — NOT NULL

Copy Of Untitled (Duo_overwatch)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(255) — NOT NULL
  • Field2 (type) — varchar(255) — NOT NULL — rank / normal / arcade
  • Field3 (tier) — varchar(255) — NOT NULL — bronze / silver / gold / platinum / diamond / master / grandmaster / challenger
  • Field4 (position) — varchar(255) — NOT NULL — tank / deal / heal
  • Field6 (voice) — boolean — NOT NULL
  • Field (content) — varchar(255) — NOT NULL
  • Field5 (expire) — varchar(255) — NOT NULL
  • Field7 (regdate) — datetime(6) — NOT NULL

Untitled (User)

  • Key (id) — bigint — 기본 키 — NOT NULL — 회원 고유번호
  • Field (oauth2_id) — varchar(255) — NOT NULL — oauth 고유번호
  • Field2 (email) — varchar(255) — 카카오 수집 동의 시
  • Field3 (phone) — varchar(255) — 휴대폰 인증 시
  • Field2 (representative) — varchar(255)
  • Field (lol) — varchar(255) — 리그오브레전드
  • Field (overwatch) — varchar(255) — 오버워치
  • Field (pubg) — varchar(255) — 배틀그라운드
  • Field (maplestory) — varchar(255) — 메이플스토리
  • Field (lostark) — varchar(255) — 로스트아크
  • Field (play_count) — bigint
  • Field (like) — bigint
  • Field (dislike) — bigint
  • Field (regdate) — datetime(6) — 생성일자

Untitled (Follow)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (follower) — varchar(255) — NOT NULL
  • Field2 (following) — varchar(255) — NOT NULL

Untitled (Duo_lol)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(255) — NOT NULL
  • Field2 (type) — varchar(255) — NOT NULL — duo_rank / free_rank / normal / aram
  • Field3 (tier) — varchar(255) — NOT NULL — iron / bronze / silver / gold / platinum / diamond / master
  • Field4 (position) — varchar(255) — NOT NULL — top / jug / mid / adc / sup
  • Field6 (voice) — boolean — NOT NULL
  • Field (content) — varchar(255) — NOT NULL
  • Field5 (expire) — varchar(255) — NOT NULL
  • Field7 (regdate) — datetime(6) — NOT NULL

Untitled (Report)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (oauth2_id) — varchar(255) — NOT NULL
  • Field (content) — varchar(255) — NOT NULL

유저 (Token)

  • Key (id) — bigint — 기본 키 — NOT NULL — 토큰 고유번호
  • Field (oauth2_id) — varchar(255) — NOT NULL — oauth 고유번호
  • Field2 (refresh_token) — varchar(255) — NOT NULL
  • Field3 (created_at) — datetime(6) — NOT NULL
  • Field4 (updated_at) — datetime(6) — NOT NULL