RpgGame
Tables (5)
BattleHistory (전투기록)
- id (아이디) — INT — Primary key — NOT NULL
- player_id (플레이어ID) — INT — Foreign key → Player.id — NOT NULL
- battle_date (배틀일자) — DATETIME
Job (직업)
- id (아이디) — INT — Primary key — NOT NULL
- name (직업이름) — VARCHAR2(255)
Monster (몬스터)
- id (아이디) — INT — Primary key — NOT NULL
- name (이름) — VARCHAR(255)
- hp (체력) — INT
- level (레벨) — INT
- gain_exp (얻게될경험치) — INT
- attack_damage (공격력) — INT
Player (플레이어)
- id (아이디) — INT — Primary key — NOT NULL
- user_id (유저ID) — INT — Foreign key → User.id — NOT NULL
- job_id (직업ID) — INT — Foreign key → Job.id — NOT NULL
- name (닉네임) — VARCHAR2(255)
- hp (체력) — INT
- level (레벨) — INT
- exp (경험치) — INT
- attack_damage (공격력) — INT
- registered_date (생성일자) — DATETIME
User (유저)
- id (아이디) — INT — Primary key — NOT NULL
- email (이메일) — VARCHAR(255)
- password (비밀번호) — VARCHAR(255)
- registered_date (가입일자) — DATETIME