Legends of the Balkans - Database Design

Short Description

"Legends of the Balkans" is a multiplayer RPG set in a historical-fantasy version of the Balkans, where players create and control characters to embark on quests, join factions, gain reputation, collect items, trade in a market, and fight enemies.

• Players create accounts, allowing them to manage multiple characters.
• Each character belongs to a faction and can gain or lose reputation based on their actions.
• Quests provide experience and rewards.
• Items can be found, crafted, or bought/sold on a player-driven market.
• Enemies drop items and serve as a source of loot.
• Guilds allow players to form groups and collaborate in the game.

The database is structured to support expansions such as PvP battles, new enemy types, and advanced crafting mechanics.

Long Description

Legends of the Balkans is an immersive MMORPG experience where players explore a historical-fantasy version of the Balkans. Players begin by creating an account and designing a hero, selecting their faction, and embarking on quests to gain experience, gold, and reputation.

Factions play a key role in the game, with players earning reputation points that determine their standing within different groups. Reputation can be positive or negative, affecting a character’s rank and the way NPCs and other factions interact with them.

The game economy is player-driven, allowing users to trade items on a marketplace where they set their own prices. Items are obtained from enemies, crafting, and quest rewards.

A guild system allows players to form alliances, strategize, and grow their influence. This database is designed to facilitate all aspects of player progression and interactions while remaining scalable for future expansions.

Database Purpose and Questions

1. Who is the database and project intended for?

The primary owner of the database and application would likely be a game development company or an independent game developer working on an online RPG.

• The game could be developed by a small indie studio looking to launch an MMORPG or multiplayer RPG.
• Alternatively, a larger company could own it as part of a game-as-a-service model.

Their needs include:

• Scalable player data storage.
• A secure authentication system.
• A structured way to track character progress.
• A dynamic economy system with item trading.

2. What problems will this database solve for the company?

• Managing player accounts securely.
• Tracking character progression (level, experience, reputation).
• Faction and reputation system for dynamic world-building.
• Market economy that allows player-to-player item sales.
• Quest and enemy management to control game progression.
• Scalability for future updates (PvP, crafting, events).

This database ensures smooth game operations by reducing manual tracking and improving automation.

3. What types of users will the application have?

• Game Players (End-Users)
  • Register and create characters.
  • Take quests, fight enemies, gain items.
  • Trade in the market, join guilds, and build reputation.

• Game Administrators / Developers
  • Maintain game balance (e.g., adjusting loot drop rates).
  • Monitor player economy (to prevent exploits).
  • Manage quests, factions, and updates.

• Game Moderators
  • Detect fraud (e.g., market price manipulation).
  • Ban players for cheating or abusing mechanics.
  • Moderate player behaviour

4. How is this project different from other similar solutions?

There are many MMORPGs with database-driven backends, but this project is different because:

• Historical Balkan Setting
  • Unlike generic fantasy MMOs, this game is rooted in Balkan history.
  • Factions, quests, and items are inspired by real folklore.

• Faction-Based Reputation System
  • Most games have static faction systems.
  • Here, players can shift allegiances dynamically based on reputation.

• Player-Driven Market
  • Some RPGs restrict trade (e.g., NPC stores).
  • This system allows players to set their own prices.

---