Difference between revisions of "Portal:SWGANH Database Documentation"

From SWGANH Wiki
Jump to: navigation, search
Line 11: Line 11:
 
|width="200px"|'''Table Name'''||width="150px"|'''Category'''||width="450px"|'''Table Description'''
 
|width="200px"|'''Table Name'''||width="150px"|'''Category'''||width="450px"|'''Table Description'''
 
|-
 
|-
||'''[[account (Database Table)|account]]'''||'''Main::Account'''||This table holds all the user account information.
+
||'''[[account (Database Table)|account]]'''||align="center"|'''Main::Account'''||This table holds all the user account information.
 
|-
 
|-
||'''[[attacks (Database Table)|attacks]]'''||'''Main::NPC'''||This table holds all the ... information.
+
||'''[[attacks (Database Table)|attacks]]'''||align="center"|'''Main::NPC'''||This table holds all the ... information.
 
|-
 
|-
||'''[[badge_categories (Database Table)|badge_categories]]'''||'''Badges'''||This table holds all the badge category information.
+
||'''[[badge_categories (Database Table)|badge_categories]]'''||align="center"|'''Badges'''||This table holds all the badge category information.
 
|-
 
|-
||'''[[badge_regions (Database Table)|badge_regions]]'''||'''Badges'''||This table holds all the badge regions information.
+
||'''[[badge_regions (Database Table)|badge_regions]]'''||align="center"|'''Badges'''||This table holds all the badge regions information.
 
|-
 
|-
||'''[[badges (Database Table)|badges]]'''||'''Badges'''||(Table) -> Player Badges
+
||'''[[badges (Database Table)|badges]]'''||align="center"|'''Badges'''||(Table) -> Player Badges
 
|-
 
|-
||'''[[banks (Database Table)|banks]]'''||'''Player'''||(Table) -> Player Banks
+
||'''[[banks (Database Table)|banks]]'''||align="center"|'''Player'''||(Table) -> Player Banks
 
|-
 
|-
||'''[[biography_faction (Database Table)|biography_faction]]'''||'''Biography'''||(Table) -> Biography Generator
+
||'''[[biography_faction (Database Table)|biography_faction]]'''||align="center"|'''Biography'''||(Table) -> Biography Generator
 
|-
 
|-
||'''[[biography_planet (Database Table)|biography_planet]]'''||'''Biography'''||(Table) -> Biography Generator
+
||'''[[biography_planet (Database Table)|biography_planet]]'''||align="center"|'''Biography'''||(Table) -> Biography Generator
 
|-
 
|-
||'''[[biography_profession (Database Table)|biography_profession]]'''||'''Biography'''||(Table) -> Biography Generator
+
||'''[[biography_profession (Database Table)|biography_profession]]'''||align="center"|'''Biography'''||(Table) -> Biography Generator
 
|-
 
|-
||'''[[biography_templates (Database Table)|biography_templates]]'''||'''Biography'''||(Table) -> Biography Generator
+
||'''[[biography_templates (Database Table)|biography_templates]]'''||align="center"|'''Biography'''||(Table) -> Biography Generator
 
|-
 
|-
||'''[[biography_wars (Database Table)|biography_wars]]'''||'''Biography'''||(Table) -> Biography Generator
+
||'''[[biography_wars (Database Table)|biography_wars]]'''||align="center"|'''Biography'''||(Table) -> Biography Generator
 
|-
 
|-
||'''[[building_types (Database Table)|building_types]]'''||''' '''||
+
||'''[[building_types (Database Table)|building_types]]'''||align="center"|''' '''||
 
|-
 
|-
||'''[[buildings (Database Table)|buildings]]'''||''' '''||
+
||'''[[buildings (Database Table)|buildings]]'''||align="center"|''' '''||
 
|-
 
|-
||'''[[cells (Database Table)|cells]]'''||''' '''||
+
||'''[[cells (Database Table)|cells]]'''||align="center"|''' '''||
 
|-
 
|-
 
||'''[[character_appearance (Database Table)|character_appearance]]'''||''' '''||
 
||'''[[character_appearance (Database Table)|character_appearance]]'''||''' '''||

Revision as of 13:59, 5 June 2007

Architecture - Database Documentation

SWGANH Wiki is a repository of Star Wars Galaxies Developer information. This site is only meant to be used by SWGANH Developer team.


Table Listing Build 75
Table Name Category Table Description
account Main::Account This table holds all the user account information.
attacks Main::NPC This table holds all the ... information.
badge_categories Badges This table holds all the badge category information.
badge_regions Badges This table holds all the badge regions information.
badges Badges (Table) -> Player Badges
banks Player (Table) -> Player Banks
biography_faction Biography (Table) -> Biography Generator
biography_planet Biography (Table) -> Biography Generator
biography_profession Biography (Table) -> Biography Generator
biography_templates Biography (Table) -> Biography Generator
biography_wars Biography (Table) -> Biography Generator
building_types
buildings
cells
character_appearance
character_attributes
character_badges
character_biography
character_faction
character_skills
character_waypoints
character_xp
characters
chat_attachments
chat_categories
chat_channels
chat_channels_banned
chat_channels_moderators
chat_char_channels
chat_friendlist
chat_ignorelist
chat_mail
chat_mail_attachments
cities
clienteffects
commerce_auction
commerce_bazaar
config_message_routes
config_process_list
config_zones
container_item
container_types
containers
crafting_station_types
crafting_stations
crafting_tool_types
crafting_tools
datapad_types
datapads
draft_assembly_batches
draft_assembly_lists
draft_experiment_batches
draft_experiment_lists
draft_lists_datatypes
draft_schematicsv
draft_schematics_slots
draft_slot_types
draft_slots
draft_weights
faction
filler_npc_types
filler_npcs
food_types
foods
furniture_types
furnitures
galaxy
inventories
inventory_types
moods
name_developer
name_profane
name_reserved
namegen_firstname
namegen_lastname
npc
npc_attributes
npc_defence
npc_faction
npc_harvest
npc_objects
npc_specials
npc_static_spawns
npc_template
npc_type
npc_xp
parking_garage
planet
planet_regions
planetmap
planetmapcategory
quests
race
resource_categories
resource_containers
resource_name_begin
resource_name_end
resource_template
resources
resources_spawn_config
schematic_groups
shuttle_types
shuttles
skillcommands
skillmods
skills
skills_base_xp_groups
skills_jedi_states
skills_preclusions
skills_schematicsgranted
skills_skill_skillparent
skills_skill_skillsrequired
skills_skillcommands
skills_skillmods
skills_species_required
sounds
spawn_clone
spawn_shuttle
starting_attributes
starting_items
starting_location
static_objects
static_types
survey_tool_types
survey_tools
terminal_elevator_data
terminal_types
terminals
ticket_collectors
trainer_types
trainers
travel_planet_routes
travel_tickets
v_planetmapcorellia (View) -> Planet Map For Corellia
v_planetmapdantooine (View) -> Planet Map For Dantooine
v_planetmapdathomir (View) -> Planet Map For Dathomir
v_planetmapdungeon1 (View) -> Planet Map For Dungeon1
v_planetmapendor (View) -> Planet Map For Endor
v_planetmaplok (View) -> Planet Map For Lok
v_planetmapnaboo (View) -> Planet Map For Naboo
v_planetmaprori (View) -> Planet Map For Rori
v_planetmaptaanab (View) -> Planet Map For Taanab
v_planetmaptalus (View) -> Planet Map For Talus
v_planetmaptatooine (View) -> Planet Map For Tatooine
v_planetmaptutorial (View) -> Planet Map For Tutorial
v_planetmapyavin4 (View) -> Planet Map For Yavin IV
waypoint (Table) -> Datapad: Waypoints
weapon_types (Table) -> Weapon Type List
weapons (Table) -> Inventory: Weapons
wearable_types (Table) -> Wearables Type List
wearables (Table) -> Inventory: Wearables
xp_types (Table) -> XP Type List


SWGANH Database Schema