롤ERD
테이블 (12)
ALLTIER (Untitled7)
- Key (ID) — NUMBER — 기본 키 — NOT NULL
- Field1 (TIER) — VARCHAR2(15)
- Field2 (WIN) — VARCHAR(5)
- Field3 (COMSAVEID) — NUMBER
- Field (TOPID) — VARCHAR2(3)
- Field2 (JUNGLEID) — VARCHAR2(3)
- Field3 (MIDDLEID) — VARCHAR2(3)
- Field4 (BOTTOMID) — VARCHAR2(3)
- Field5 (UTILITYID) — VARCHAR2(3)
ALLTIER (Untitled8)
- Key (ID) — NUMBER — 기본 키 — NOT NULL
- Field1 (COMSAVEID) — NUMBER
- Field2 (TIER) — VARCHAR2(15)
- Field4 (TOPNAME) — VARCHAR(15)
- Field5 (JUNGLENAME) — VARCHAR(15)
- Field6 (MIDDLENAME) — VARCHAR(15)
- Field7 (BOTTOMNAME) — VARCHAR(15)
- Field8 (UTILITYNAME) — VARCHAR(15)
- Field9 (WINRATE) — NUMBER
- Field10 (PICKCOUNT) — NUMBER
CHAMPIONNAME (2)
- Key (ID) — NUMBER — 기본 키 — NOT NULL
- Field (CHAMPIONENGNAME) — VARCHAR2(15)
- Field (CHAMPIONKORNAME) — VARCHAR2(15
COMSAVE (1)
- Key (ID) — NUMBER — 기본 키 — NOT NULL
- Field1 (TOPNAME) — VARCHAR(15)
- Field2 (JUNGLENAME) — VARCHAR(15)
- Field3 (MIDDLENAME) — VARCHAR(15)
- Field4 (BOTTOMNAME) — VARCHAR(15)
- Field5 (UTILITYNAME) — VARCHAR(15)
LOSETEAM (Untitled9)
- Key (ID) — NUMBER — 기본 키 — NOT NULL
- Field1 (LOSECOMSAVEID) — NUMBER
- Field (WINCOMSAVEID) — NUMBER
- Field2 (TIER) — VARCHAR(15)
- Field3 (WINTOPID) — VARCHAR(3)
- Field4 (WINJUNGLEID) — VARCHAR(3)
- Field5 (WINMIDDLEID) — VARCHAR(3)
- Field6 (WINBOTTOMID) — VARCHAR(3)
- Field7 (WINUTILITYID) — VARCHAR(3)
- Field8 (WINRATE) — NUMBER
- Field9 (MATCHCOUNT) — NUMBER
ORIGINAL (Untitled6)
- Key (ID) — NUMBER — 기본 키 — NOT NULL
- Field1 (GAMETIME) — VARCHAR2(20)
- Field2 (INSERTTIME) — VARCHAR2(20)
- Field3 (TIER) — VARCHAR2(15)
- Field4 (MATCHID) — VARCHAR2(15)
- Field5 (TOPNAME) — VARCHAR2(15)
- Field6 (JUNGLENAME) — VARCHAR2(15)
- Field7 (MIDDLENAME) — VARCHAR2(15)
- Field8 (BOTTOMNAME) — VARCHAR2(15)
- Field9 (UTILITYNAME) — VARCHAR2(15)
- Field10 (COMSAVEID) — NUMBER
- Field11 (TEAMID) — VARCHAR2(3)
- Field12 (WIN) — VARCHAR2(5)
SUMMONERLIST (5)
- Key (ID) — NUMBER — 기본 키 — NOT NULL
- Field1 (TIER) — VARCHAR(15)
- Field2 (SUMMONERID) — VARCHAR(60)
- Field3 (SUMMONERNAME) — VARCHAR(60)
- Field4 (STATUS) — VARCHAR(1)
community (Untitled2)
- Key (id) — int — 기본 키 — NOT NULL
- Field1 (title) — String
- Field2 (content) — String
- Field3 (writer) — String
- Field4 (date) — Date
- Field5 (view) — int
- Field6 (like) — int
communityComment (Untitled3)
- Key (id) — int — 기본 키 — NOT NULL
- Field1 (content) — String
- Field2 (date) — Date
- Field3 (writer) — String
- Field4 (communityId) — int
communityLike (Untitled4)
- Key (id) — int — 기본 키 — NOT NULL
- Field1 (userId) — int
- Field2 (communityId) — int
lotation (Untitled5)
- Key (id) — int — 기본 키 — NOT NULL
- Field1 (championId) — int
user (Untitled)
- Key (id) — int — 기본 키 — NOT NULL
- Field (idName) — String
- Field (password) — String