투비소프트
테이블 (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