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 — 무기 가격