ERD_DB

Tables (8)

inventory

  • player_id — Primary key — NOT NULL — player id
  • invenSlot_num — Primary key — NOT NULL — 인벤토리 슬롯 number
  • weapon_id — Primary key — NOT NULL — weapon id
  • weapon_name — Primary key — NOT NULL — weapon name
  • equip — Primary key — NOT NULL — 무기 착용중인지의 여부 0 : 가용 1 : 착용

monster

  • monster_id — int — Primary key — NOT NULL — monster id
  • monster_name — varchar(45) — Primary key — NOT NULL — monster name
  • cur_hp — int — Primary key — NOT NULL — 현재 hp

monsterbase

  • monster_name — varchar(45) — Primary key — NOT NULL — monster_name
  • monster_level — int — Primary key — NOT NULL — monster level
  • att — int — Primary key — NOT NULL — 몬스터 공격력
  • def — int — Primary key — NOT NULL — 방어력
  • max_hp — int — Primary key — NOT NULL — 최대 hp

player

  • player_id — Primary key — NOT NULL — player id
  • max_hp — Primary key — NOT NULL — 최대 hp
  • cur_hp — Primary key — NOT NULL — 현재 hp
  • att — Primary key — NOT NULL — 공격력
  • def — Primary key — NOT NULL — 방어력
  • level — Primary key — NOT NULL — 현재 레벨
  • max_exp — Primary key — NOT NULL — 최대 경험치
  • cur_exp — Primary key — NOT NULL — 현재 경험치
  • coin — Primary key — NOT NULL — 소지금
  • weapon_id — Primary key — NOT NULL — 플레이어가 현재 착용중인 무기 id

save

  • slot_num — int — Primary key — NOT NULL — player slot number
  • player_id — int — Primary key — NOT NULL — player id

store

  • weapon_name — varchar(45) — Primary key — NOT NULL — weapon name
  • price — int — Primary key — NOT NULL — 무기 가격

weapon

  • weapon_id — int — Primary key — NOT NULL — weapon id
  • weapon_name — varchar(45) — Primary key — NOT NULL — weapon name
  • equip — varchar(45) — Primary key — NOT NULL — 무기 착용중인지의 여부 0 : 가용 1 : 착용

weaponbase

  • weapon_name — varchar(45) — Primary key — NOT NULL — weapon name
  • att — int — Primary key — NOT NULL — 무기 공격력
  • price — int — Primary key — NOT NULL — 무기 가격