Account Table: AccountID (Primary Key): A unique identifier for each account. Username: The unique name used to
Question:
Account Table:
AccountID (Primary Key): A unique identifier for each account.
Username: The unique name used to log in.
Password: Hashed and salted password for account security.
SubscriptionStatus: Indicates whether the account is active or blocked.
SubscriptionExpiryDate: Date when the subscription expires.
ErrorLogID (Foreign Key): Links to the Error Log table to track errors related to this account.
Character Table:
CharacterID (Primary Key): Unique identifier for each character.
AccountID (Foreign Key): Links to the associated account.
CharacterName: Name of the character.
Team: The team to which the character belongs.
SkillLevel: Skill level of the character.
Error Log Table:
ErrorLogID (Primary Key): Unique identifier for each error log entry.
AccountID (Foreign Key): Links to the associated account.
ErrorType: Indicates the type of error (e.g., login error, payment error, etc.).
ErrorMessage: Details of the error message.
Timestamp: Timestamp for when the error occurred.
Inventory Table:
InventoryID (Primary Key): Unique identifier for each inventory slot.
CharacterID (Foreign Key): Links to the character that owns the inventory.
ItemID (Foreign Key): Links to the item in the Items Table.
Quantity: Number of items of that type in the slot.
Items Table:
ItemID (Primary Key): Unique identifier for each item.
ItemName: Name of the item.
ItemType: Type or category of the item (e.g., weapons, armor, potions, etc.).
USE THIS INFORMATION TO CREATE DATABASE TABLES.
Accounting Information Systems The Crossroads of Accounting & IT
ISBN: 978-0132991322
2nd Edition
Authors: Donna Kay, Ali Ovlia