Changes between Version 4 and Version 5 of relational-schema

Timestamp:

02/13/25 19:41:40 (9 days ago)

Author:

181557

Comment:

--

relational-schema

@@ -15 +15 @@
 - `Character (*CharacterID, #PlayerID, Name, Health, EXP, Gold)`
 - `Faction (*FactionID, Name, Description)`
-- `Reputation (*#CharacterID, *#FactionID, ReputationPoints, Rank)`
+- `ReputationIn (*#CharacterID, *#FactionID, ReputationPoints, Rank)`  (tracks a character's reputation with a faction)
 - `Quest (*QuestID, Name, EXP_Required, EXP_Reward, Gold_Reward)`
 - `Item (*ItemID, Name, Type, Rarity, Craftable)`
@@ -21 +21 @@
 - `Trader (*TraderID, Name, Type)`
 - `Market (*MarketID, #ItemID, #SellerID, Price)`
-- `Guild (*GuildID, Name, #LeaderID)`
+- `Guild (*GuildID, Name, #LeaderID)` 
 - `Character_Quest (*#CharacterID, *#QuestID)`
-- `Character_Item (*#CharacterID, *#ItemID)`
-- `Enemy_Item (*#EnemyID, *#ItemID)`
-- `Trader_Item (*#TraderID, *#ItemID)`
-- `Character_Guild (*#CharacterID, *#GuildID)`
+- `Character_Item (*#CharacterID, *#ItemID, Quantity)`
+- `Enemy_Item (*#EnemyID, *#ItemID, Quantity)`
+- `Trader_Item (*#TraderID, *#ItemID, Quantity)`
+- `Character_Guild (*#CharacterID, *#GuildID)` 
+- `IsMember (*#CharacterID, *#GuildID, Role)` (defines whether a character is a member or a leader of a guild)
 
 == DDL Script ==