DB APP ARPG
Tables (3)
Equipment Record Management (Untitled2)
- PlayerEquipmentID (PK2) — INT — Foreign key → Equipment Usage Entry.PlayerEquipmentID — NOT NULL
- EquipmentID (FK) — INT — Foreign key → Equipment Usage Entry.EquipmentID — NOT NULL
- PlayerID ((FK)) — INT — Foreign key → Equipment Usage Entry.PlayerID — NOT NULL
- EquipmentName (Field) — VARCHAR
- EquipmentType (Field2) — VARCHAR
- EquipmentAttack (Field3) — INT
- EquipmentDefense (Field4) — INT
- EquipmentDescription (Field5) — VARCHAR
Equipment Usage Entry (Untitled3)
- PlayerEquipmentID (PK) — INT — Primary key — NOT NULL
- EquipmentID (FK) — INT — Primary key — NOT NULL
- PlayerID ((FK)) — INT — Primary key — NOT NULL
- EquipmentDurability (Field) — INT
- EquipmentEnchancements (Field2)
- IsEquipped (Field3) — Boolean
- Field4
Player Profile Record Management (Untitled)
- PlayerID (PK) — INT — Primary key — NOT NULL
- PlayerName (Field) — VARCHAR
- PlayerLevel (Field2) — INT
- PlayerEXP (Field3) — DOUBLE
- PlayerHP (Field4) — DOUBLE
- PlayerMan (Field5) — INT
- PlayerAchievements (Field6) — INT
- AccumulatedPlaytime (Field7)