Database

This wiki is a list of all required tables and fields within. It is important for the tables and fields to exist well before coding functions that require them, so that the functions can be tested immediately. Designating table and field names is also important so that functions can call the right table and fields.

NOTE: Since changes in these names will require changes in the coding in the future, it is important to make sure that future possibilities are taken into account when making tables and fields. Therefore, fields that may be unused right now should still be added because they will soon be needed.

Example Table

• Field #1 Description (Field Name in Database)
• Field #2 Description (Field Name in Database)

empires

• ID (id)
• Name (name)
• Income (income)
• Colour on Map (color)

users

• ID (id)
• Empire (empire_id)
• Income Units (income_unit)
• Current Gold (gold)

armies

• ID (id)
• Location X (pos_x)
• Location Y (pos_y)
• User (user_id)

units

• ID (id)
• Army (army_id)
• Type (type)
• User (user_id)
• Size (size)
• Defensive Strength (defense)
• Offensive Strength (offense)
• Morale (morale)
• Experience (experience)

provinces

• ID (id)
• Empire (empire_id)
• Income (income)

cities

• ID (id)
• Province (province_id)
• Income (income)
• X coordinate (pos_x)
• Y coordinate (pos_y)

coordinates

• ID (id)
• Province (province_id)
• X coordinate (pos_x)
• Y coordinate (pos_y)

terrains

• ID (id)

battles

• ID (id)