= Legends of the Balkans - Relational Design =

== Signs ==
Below are the annotations used in the relational schema:

- `*` (asterisk) → Denotes a **Primary Key**.
- `#` (hash) → Denotes a **Foreign Key**.
- `(A, B, C)` → Represents the attributes within a table.
- `[ ]` → Represents optional fields (nullable).

== Tables ==

Full list of tables:
- `Player (*PlayerID, Username, Email, Password)`
- `Character (*CharacterID, #PlayerID, Name, Health, EXP, Gold)`
- `Faction (*FactionID, Name, Description)`
- `Reputation (*#CharacterID, *#FactionID, ReputationPoints, Rank)`
- `Quest (*QuestID, Name, EXP_Required, EXP_Reward, Gold_Reward)`
- `Item (*ItemID, Name, Type, Rarity, Craftable)`
- `Enemy (*EnemyID, Name, Health, Damage, LootDrop)`
- `Trader (*TraderID, Name, Type)`
- `Market (*MarketID, #ItemID, #SellerID, Price)`
- `Guild (*GuildID, Name, #LeaderID)`
- `Character_Quest (*#CharacterID, *#QuestID)`
- `Character_Item (*#CharacterID, *#ItemID)`
- `Enemy_Item (*#EnemyID, *#ItemID)`
- `Trader_Item (*#TraderID, *#ItemID)`
- `Character_Guild (*#CharacterID, *#GuildID)`

== DDL Script ==
The **Data Definition Language (DDL) script** defines the database schema.

[[attachment:lotb_ddl.sql]]

== DML Script ==
The **Data Manipulation Language (DML) script** contains sample data insertions.

[[attachment:lotb_dml.sql]]

== Relational Diagram ==
The relational schema diagram will be placed here:

[[Image(lotb_rd.png, 1000px)]]