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)