Better Explaination of the Database Schema

I've had some questions about my database schema and how to use it. Since this might be something that some others have questions with I'll post the answers here for help to others.


1). How do you know what damage a monster does?

HP MP and KP are calculated based on monster stats that are generated from monsters based on Stat Mod's and Monster Level.

A=10
B=8
C=6
D=4
E=2

These are the mod base.


2). There is no entry for armor defense or for item damage.

For armor this is linked though the Armor Params.

ParamID ArcaneID Value
5 NULL 350

Kinda like this.

For items, healing and damage are stored in Potency and Variance. Potency being a healing or damaging percentage. Variance being the number value of the damage or healing amount.


I tried to consolidate a lot of flexibility into a table.


3). Monster party should have an entry for how many monsters in the party.

Monster Party's FK Monster#ID is the party slots. A party can have upto seven slots. (The first slot got deleted from the schema it seems.) The position of the monster will be according to the battle fields formation placing for the 7 slots.


4). Have you started coding yet or are you in the planning stage?


I'm planing/prototyping. Nearing the end of these stages actually. The last thing i need to work on is a prototype using all the prototypes in one functional demo. One city and one map/one dungeon. Also maybe one Event scene using MLS scripting.



Feel free to post more questions. This helps me and everyone as well. This will help find missing tables fields and etc.


Schema:
Click Here