Portal:SWGANH Database Documentation

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. attributes Items This table holds all the attribute types. 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_bind 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 Character Table Relation NPC Table Relation Conversation Table Relation