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