Data Dictionary

Resource Data

• tResources - Each resource spawn and its primary data
• tResourcePlanet - History of planet availability for resources
• tResourceType - List of resource types
• tResourceGroup - List of resource groups
• tResourceTypeGroup - Correlation of the groups associated to each resource type
• tResourceGroupCategory - Correlation of the higher level groups associated to each resource group
• tResourceTypeCreature - List of creatures and what resource types they drop
• tResourceEvents - History of events related to resources
• tWaypoint - List of waypoint location entries for resources

Galaxy Data

• tPlanet - List of all planets
• tGalaxy - List of all galaxies (servers)
• tGalaxyPlanet - Association of planets to galaxies other than the base planets

Schematic Data

• tProfession - List of game professions
• tSkillGroup - List of skill groups related to professions that grant schematics
• tSchematic - List of crafting schematics
• tSchematicIngredients - Ingredient slots for each schematic
• tSchematicQualities - Quality groups for each schematic
• tSchematicResWeights - Resource stat weights for each quality
• tSchematicImages - List of locations of user sourced pictures of schematic items
• tSchematicEvents - History of server best resource spawn events related to schematics and custom schematic add/edit events.
• tObjectType - List of object types by crafting tab related to schematic items

User Data

• tUsers - List of site members
• tUserStats - Aggregated statistics of user activity by galaxy
• tUserWaypoints - Not implemented
• tUserFriends - List of users associations
• tUserEvents - History of user related events triggered by resource event activity
• tFavorites - User favorites/inventory (resources, types, schematics, despawn alerts, professions)
• tPayments - History of donation activity
• tFilters - User alert filters based on resource stat value minimums
• tAlerts - History of user alerts (site, email, mobile)
• tRecipe - Saved user crafting recipies
• tRecipeIngredients - Resource ingredient data for user recipies

Feedback Data

• tFeedback - Suggestions
• tFeedbackVotes - User votes on suggestions
• tFeedbackComments - Comments on suggestions