Test_ERD

Tables (4)

Untitled (클래스)

  • Key (클래스구분) — VARCHAR — Primary key — NOT NULL
  • Field (클래스명) — VARCHAR

Untitled (종족)

  • Key (종족구분) — VARCHAR — Primary key — NOT NULL
  • Field (종족명) — VARCHAR

Untitled (클래스종족별기본능력치)

  • Key (클래스구분2) — VARCHAR — Foreign key → Untitled.Key — NOT NULL
  • Key (종족구분2) — VARCHAR — Foreign key → Untitled.Key — NOT NULL
  • Field (물리공격력) — FLOAT
  • Field (마법공격력) — FLOAT
  • Field (물리방어력) — FLOAT
  • Field (마법방어력) — FLOAT
  • Field (치명타율) — FLOAT
  • Field (치명타피해율) — FLOAT
  • Field (HP) — FLOAT
  • Field (MP) — FLOAT
  • Field (공격속도) — FLOAT
  • Field (이동속도) — FLOAT

Untitled (클래스종족별전직)

  • Key (전직ID) — VARCHAR — Primary key — NOT NULL
  • Field (클래스종족별기본능력치_클래스_클래스구분) — VARCHAR(FK)
  • Field (클래스종족별기본능력치_종족_종족구분) — VARCHAR(FK)
  • Field (물리공격력) — FLOAT
  • Field (마법공격력) — FLOAT
  • Field (물리방어력) — FLOAT
  • Field (마법방어력) — FLOAT
  • Field (치명타율) — FLOAT
  • Field (치명타피해율) — FLOAT
  • Field (HP) — FLOAT
  • Field (MP) — FLOAT
  • Field (공격속도) — FLOAT
  • Field (이동속도) — FLOAT
  • Key (클래스구분2) — VARCHAR — Foreign key → Untitled.Key — NOT NULL
  • Key (종족구분2) — VARCHAR — Foreign key → Untitled.Key — NOT NULL