롤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