Players(customers)
  - requirements:
    - A player must have at least one character (Characters_owned)
      - can create a new character or 
      - deactivate one they no longer wish to play
        - Once a player unsubscribed from the game, the character is also removed from the system.
    - A player will be billed at the end of a calendar month 
      - for all active characters for any part of that month.

  - fields:
    - Account_Number(pk)
    - Forename
    - surname
    - e-mail_Address
    - Characters_owned(1 to many to characters)

Characters
  - requirements:
    - Characters have combat info (see Combat.csv)

  - fields:
    - Name(Character_Name)
    - Type(Character_Type)
    - Level
    - ExperiencePoints
    - Max_Health
    - Health
    - AttackInScore
    - DefenceScore
    - StealthScore
    - ManaScore
    - MoneyBank
    - MoneyWallet
    - OwnedBy (many to 1 to players)
    - Items (1 to Many to items table)
    - CombatInvolved (1 to many to Combat table / Battle)
    - CreationDate(Character_CreationDate)
    - ExpiryDate(Character_Expiry_Date)

Inventory(Items)
  - for the various weapons and armour a character may possess
  - Weapons: 
    - range 
    - damage points.
  - Armours:
    - defence score 
    - worn on a speciÞc body part.
  - Supplies: 
    - healing score, 
    - mana score
      - if consumed increase the character’s life score by that amount (after which time the character will possess one fewer of that type of item)

  - fields:
    - ItemsKey(pk)
    - Item_Name(Item)
    - Item_Type
    - WeaponType
    - Range
    - Price
    - Quantity
    - DefendScore
    - AttackScore
    - HealingScore
    - ManaScore
    - SingleUse
    - wearable
    - worn
    - BodyPart
    - Equipped
    - Character (many to 1 to character / Items)

Combat:
  - requirements:
    - \# of kills
    - KIA’s(Killed in action)
    - victories

  - fields:
    - BattleNo(pk)
    - BattleDate
    - Attacker(many to 1 -> characters)
    - Defender(many to 1 -> characters)
    - Weapon
    - Result
    - Damage