Futurama Worlds of Tomorrow Wiki:Schema

This page is for planning out the Cargo database tables and fields.

(___) are references to another tables. Wiki markup should be allowed for descriptions.

Characters
Infobox Game_name //in-game for character since WoT doesn't use full names Image Class District Building Limited_time //true or false Premium_cost Event Goal Goal_part Additional (Actions) //list of Actions Outfit_for (Unlock_Materials) //list of Materials Unlock_cost //for outfits. assume nixonbucks. events may have own currency Unlock_time //for outfits Quote

Actions
Table. autogen key in lowercase: character_action_name Event //leave blank if not applicable Icon Name Time Nixonbucks Experience Requirements_building Requirements_character Requirements_level

Outfits
They are essentially a character so it's doesn't make sense to create a new table.

Maybe create a template that auto-generates a gallery of outfits for the character?

Unlock_Materials
Table? Quantity Name Rarity Buildings //List
 * (Action_keys) //List

Buildings
Infobox ?Name //not sure if needed. same as pagename Image Event Initial_cost //assume nixonbucks. events may have own currency Successive_cost //some prices change after first buy Build_time Drop_currency Drop_xp Drop_time Additional Description ?some aren't available immediately but there doesn't seem to be any consistent requirements as to when building are unlocked and become available to build

Decorations
Infobox. DO DECOS DROP MONEY/XP?!! ?Name //not sure if needed. same as pagename Image Event Drop_currency Drop_xp Drop_time Additional Description

Districts
WIP.Does this really need an infobox? ?Name //not sure if needed. same as pagename ?Image

Planets
Infobox ?Name //not sure if needed. same as pagename Image Number_of_missions Additional (Missions) //list of Missions

Artifacts
Infobox ?Name //not sure if needed. same as pagename Image_artifact Image_silhouette Artifact_next Artifact_previous Unlocks_district Unlocks_planet

Missions
Infobox ?Name //not sure if needed. same as pagename Image //icon should be from mission list Planet Event Required_character Number_of_paths //could pull from list of paths Fuel_per_path Xp_per_path Additional Objective Rewards_first_time Rewards_repeat Rewards_100_percent (Enemies) //list of Enemies (Bosses) //list of Bosses Map (Paths) //list of paths Currency_per_battle Xp_per_battle

Paths
Mission Path_number //determined left to right, top too bottom Required_character Fuel_required Number_of_battles Number_of_interactions (Interactions) //WIP.list of interactions

Interactions
WIP. seems too complicated. answer set may change based on answer. Name (Answer_1) (Answer_2) (Answer_3)

Answers
WIP Interaction Answer_set_number //which set of answers does this one belong to Requirement Answer Reward

Career Chips
Name Class Exp

Events
Infobox Name Image Start Date End Date These should be pulled by checking the "Event" field in the respective tables. Characters Buildings Decorations Goals Missions Character Actions