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