Portal:SWGANH Database Documentation

From SWGANH Wiki
Revision as of 13:56, 5 June 2007 by Snow (Talk | contribs)

Jump to: navigation, search

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