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_families Buildings building_types Buildings buildings Buildings cells character_appearance character_attributes character_badges character_bind character_biography character_buff_attributes character_buffs character_clone character_faction character_holoemotes character_matchmaking character_movement character_skills character_stat_migration character_tutorial character_xp characters chat_attachments chat_channels chat_channels_banned chat_channels_invited chat_channels_moderators chat_char_channels chat_friendlist chat_ignorelist chat_mail chat_mail_attachments cities clienteffects command_table commerce_auction commerce_bazaar commerce_bidhistory commerce_category commerce_item_types config_message_routes config_process_list config_server config_server_attributes config_zone_scripts config_zones container_item container_types containers conversation_animations conversation_event_types conversation_option_batches conversation_options conversation_pages conversations craft_types creature_groups creature_species csr_categories csr_comments csr_knowledgebase csr_subcategories csr_tickets datapad_types datapads draft_assembly_batches draft_assembly_lists draft_craft_atribute_weights draft_craft_batches draft_craft_item_attribute_link draft_craft_lists draft_experiment_batches draft_experiment_groups draft_experiment_lists draft_lists_datatypes draft_schematic_attribute_manipulation draft_schematic_customization draft_schematic_item_link draft_schematic_manufacture_defaults draft_schematics draft_schematics_slots draft_slot_types draft_slots draft_weights entertainer_deny_service entertainer_performances faction factories frog_items galaxy galaxy_account galaxy_account_types harvester_resources harvesters holoemote houses id_attributes internal inventories inventory_types item_attributes item_customization item_families item_family_defaults item_types items lair_attributes lair_templates lairs log_error loot_groups loot_templates manschemcomponents manschemresourcs manufacturesschematic mission_names mission_terminal_mission_types mission_text mission_types moods name_developer name_profane name_reserved namegen_firstname namegen_lastname non_persistent_npc_attributes non_persistent_npcs npc_chatter object_attributes object_models parking_garage persistent_npc_families persistent_npcs planet planet_regions planetmap planetmapcategory quests race resource_categories resource_containers resource_name_begin resource_name_end resource_template resources resources_spawn_config schem_crc schematic_groups server shuttle_types shuttles skillcommands skillmods skills skills_base_xp_groups skills_description skills_jedi_states skills_preclusions skills_schematicsgranted skills_skill_skillparent skills_skill_skillsrequired skills_skillcommands skills_skillmods skills_species_required sounds spawn_clone spawn_groups spawn_regions spawn_shuttle spawns starting_attributes starting_item_requirements starting_items starting_location static_objects static_types stf_files stf_variable structure_admin_data structure_attribute_defaults structure_attributes structure_deed_data structure_item_templates structure_terminal_link structure_type_data structures terminal_elevator_data terminal_types terminals ticket_collectors travel_planet_routes vehicle_attributes vehicle_customization vehicle_families vehicle_type_attributes vehicle_types vehicles waypoint (Table) -> Datapad: Waypoints weapon_groups (Table) -> Weapon Type List xp_types (Table) -> XP Type List zone_regions (Table) -> Server Zone Regions

SWGANH Database Schema SWGANH Database Schema Character Table Relation NPC Table Relation Conversation Table Relation