투비소프트

테이블 (14)

p030_discord_user

  • DISCORD_ID — VARCHAR(50) — NOT NULL
  • USERNAME — VARCHAR(100)
  • RIOT_ID — VARCHAR(20)
  • RIOT_TAG — VARCHAR(10)
  • PERMISSION — VARCHAR(10)
  • SIGN_DATE — DATETIME
  • LOGIN_COUNT — INT(10)
  • LAST_LOGIN — DATETIME

p030_minigame_rank

  • DISCORD_ID — VARCHAR(50) — NOT NULL
  • USER_NAME — VARCHAR(100)
  • SPEED — INT(11)
  • TRACKER — INT(11)

p030_party

  • BOARD_NO — INT(11) — NOT NULL
  • DISCORD_ID — VARCHAR(50) — NOT NULL
  • USER_NAME — VARCHAR(20)
  • USER_TAG — VARCHAR(10)
  • USER_MEMO — VARCHAR(1000)
  • USER_CLASS — VARCHAR(10)
  • USER_MIC — VARCHAR(10)
  • TIER — VARCHAR(10)
  • TIER_ICON — VARCHAR(500)
  • WINS — VARCHAR(10)
  • GAMES — VARCHAR(10)
  • WIN_RATES — VARCHAR(20)
  • WRITE_TIME — DATETIME

p030_private_match

  • USER_NAME — VARCHAR(50) — 기본 키 — NOT NULL
  • MATCH_ID — VARCHAR(100) — 기본 키 — NOT NULL
  • DISCORD_ID — VARCHAR(50) — 기본 키 — NOT NULL
  • START_TIME — VARCHAR(50)
  • PLAY_TIME — VARCHAR(20)
  • MAP — VARCHAR(10)
  • AGENT_ICON — VARCHAR(500)
  • AGENT — VARCHAR(10)
  • RESULT — VARCHAR(5)
  • MY_SCORE — VARCHAR(5)
  • ENEMY_SCORE — VARCHAR(5)
  • RANK_INFO — VARCHAR(5)
  • TIER — VARCHAR(10)
  • KILL_CNT — VARCHAR(10)
  • DEATH_CNT — VARCHAR(10)
  • ASSIST_CNT — VARCHAR(10)
  • KD — VARCHAR(10)
  • ACS — VARCHAR(10)
  • HS_RATE — VARCHAR(10)
  • ADR — VARCHAR(10)
  • RESULT_COLOR — VARCHAR(50)
  • RESULT_BAR — VARCHAR(50)

p030_report

  • REPORT_NO — INT(11) — NOT NULL
  • BOARD_NO — INT(11)
  • REPORTER_RIOT_NAME — VARCHAR(20)
  • REPORTER_RIOT_TAG — VARCHAR(10)
  • REPORT_REASON — VARCHAR(200)
  • REPORTER_DISCORD_ID — VARCHAR(100)
  • WRITER_RIOT_NAME — VARCHAR(20)
  • WRITER_RIOT_TAG — VARCHAR(10)
  • WRITER_DISCORD_ID — VARCHAR(100)
  • WRITER_MEMO — VARCHAR(200)
  • REPORT_TIME — DATETIME

p030_skin

  • UUID — VARCHAR(100) — NOT NULL
  • WEAPON_UUID — VARCHAR(100) — NOT NULL
  • TIER_UUID — VARCHAR(100)
  • NAME — VARCHAR(100)
  • ICON — VARCHAR(500)
  • TIER_ICON — VARCHAR(500)
  • TIER_COLOR — VARCHAR(10)

p030_skin_tier

  • UUID — VARCHAR(100) — NOT NULL
  • NAME — VARCHAR(100)
  • ICON — VARCHAR(500)
  • COLOR — VARCHAR(10)

p030_skin_weapon

  • UUID — VARCHAR(100) — NOT NULL
  • NAME — VARCHAR(100)
  • ICON — VARCHAR(500)

p030_valorant_agent

  • UUID — VARCHAR(50) — NOT NULL
  • DISPLAY_NAME — VARCHAR(100)
  • DESCRIPTION — VARCHAR(4000)
  • FULL_PORTRAIT — VARCHAR(500)
  • DISPLAY_ICON — VARCHAR(500)
  • ROLE_NAME — VARCHAR(100)
  • ROLE_ICON — VARCHAR(500)

p030_valorant_agent_ability

  • AGENT_UUID — VARCHAR(50) — 기본 키 — NOT NULL
  • SLOT — VARCHAR(50) — 기본 키 — NOT NULL
  • DISPLAY_NAME — VARCHAR(100)
  • DESCRIPTION — VARCHAR(4000)
  • DISPLAY_ICON — VARCHAR(500)
  • SKILL_VIDEO — VARCHAR(500)

p030_valorant_map

  • UUID — VARCHAR(50) — NOT NULL
  • DISPLAY_NAME — VARCHAR(100)
  • LIST_VIEW_ICON_TALL — VARCHAR(1000)
  • DESCRIPTION — VARCHAR(300)

p030_valorant_ranking

  • RANKING — INT(11) — NOT NULL
  • USER_NAME — VARCHAR(30)
  • USER_TAG — VARCHAR(10)
  • TIER_ICON — VARCHAR(500)
  • TIER_NAME — VARCHAR(10)
  • RANKED_RATING — INT(11)
  • WINS — INT(11)
  • UPDATED_AT — DATETIME

p030_weapon_damage

  • ID — INT(11) — NOT NULL
  • WEAPON_UUID — VARCHAR(50) — 외래 키 → p030_weapon_info.UUID — NOT NULL
  • RANGE_START — INT(11)
  • RANGE_END — INT(11)
  • HEAD_DAMAGE — DOUBLE
  • BODY_DAMAGE — DOUBLE
  • LEG_DAMAGE — DOUBLE

p030_weapon_info

  • UUID — VARCHAR(50) — NOT NULL
  • DISPLAY_NAME — VARCHAR(100)
  • DESCRIPTION — TEXT
  • DISPLAY_ICON — TEXT
  • COST — INT(11)
  • CATEGORY — VARCHAR(50)
  • FIRE_RATE — DOUBLE
  • MAGAZINE_SIZE — INT(11)
  • EQUIP_TIME — DOUBLE
  • RELOAD_TIME — DOUBLE
  • RUN_SPEED_MULTIPLIER — DOUBLE
  • FIRST_BULLET_ACCURACY — DOUBLE
  • WALL_PENETRATION — VARCHAR(10)
  • HAS_ADS — CHAR(1)
  • ADS_ZOOM_MULTIPLIER — DOUBLE
  • ADS_FIRE_RATE — DOUBLE
  • ADS_RUN_SPEED — DOUBLE
  • ADS_ACCURACY — DOUBLE
  • ADS_BURST_COUNT — INT(11)
  • ALT_FIRE_TYPE — VARCHAR(50)
  • ALT_SHOTGUN_PELLETS — INT(11)
  • ALT_BURST_RATE — DOUBLE
  • ALT_BURST_DISTANCE — DOUBLE