Difference between revisions of "Portal:SWGANH Database Documentation"

From SWGANH Wiki
Jump to: navigation, search
(updated list)
 
(10 intermediate revisions by one other user not shown)
Line 13: Line 13:
 
||'''[[account (Database Table)|account]]'''||align="center"|'''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]]'''||align="center"|'''Main::NPC'''||This table holds all the ... information.
+
||'''[[attributes (Database Table)|attributes]]'''||align="center"|'''Items'''||This table holds all the attribute types.
 
|-
 
|-
 
||'''[[badge_categories (Database Table)|badge_categories]]'''||align="center"|'''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.
Line 33: Line 33:
 
||'''[[biography_wars (Database Table)|biography_wars]]'''||align="center"|'''Biography'''||(Table) -> Biography Generator
 
||'''[[biography_wars (Database Table)|biography_wars]]'''||align="center"|'''Biography'''||(Table) -> Biography Generator
 
|-
 
|-
||'''[[building_types (Database Table)|building_types]]'''||align="center"|''' '''||
+
||'''[[building_families (Database Table)|building_families]]'''||align="center"|'''Buildings'''||
 
|-
 
|-
||'''[[buildings (Database Table)|buildings]]'''||align="center"|''' '''||
+
||'''[[building_types (Database Table)|building_types]]'''||align="center"|'''Buildings'''||
 +
|-
 +
||'''[[buildings (Database Table)|buildings]]'''||align="center"|'''Buildings'''||
 
|-
 
|-
 
||'''[[cells (Database Table)|cells]]'''||align="center"|''' '''||
 
||'''[[cells (Database Table)|cells]]'''||align="center"|''' '''||
Line 44: Line 46:
 
|-
 
|-
 
||'''[[character_badges (Database Table)|character_badges]]'''||''' '''||
 
||'''[[character_badges (Database Table)|character_badges]]'''||''' '''||
 +
|-
 +
||'''[[character_bind (Database Table)|character_bind]]'''||''' '''||
 
|-
 
|-
 
||'''[[character_biography (Database Table)|character_biography]]'''||''' '''||
 
||'''[[character_biography (Database Table)|character_biography]]'''||''' '''||
 +
|-
 +
||'''[[character_buff_attributes (Database Table)|character_buff_attributes]]'''||''' '''||
 +
|-
 +
||'''[[character_buffs (Database Table)|character_buffs]]'''||''' '''||
 +
|-
 +
||'''[[character_clone (Database Table)|character_clone]]'''||''' '''||
 
|-
 
|-
 
||'''[[character_faction (Database Table)|character_faction]]'''||''' '''||
 
||'''[[character_faction (Database Table)|character_faction]]'''||''' '''||
 +
|-
 +
||'''[[character_holoemotes (Database Table)|character_holoemotes]]'''||''' '''||
 +
|-
 +
||'''[[character_matchmaking (Database Table)|character_matchmaking]]'''||''' '''||
 +
|-
 +
||'''[[character_movement (Database Table)|character_movement]]'''||''' '''||
 
|-
 
|-
 
||'''[[character_skills (Database Table)|character_skills]]'''||''' '''||
 
||'''[[character_skills (Database Table)|character_skills]]'''||''' '''||
 
|-
 
|-
||'''[[character_waypoints (Database Table)|character_waypoints]]'''||''' '''||
+
||'''[[character_stat_migration (Database Table)|character_stat_migration]]'''||''' '''||
 +
|-
 +
||'''[[character_tutorial (Database Table)|character_tutorial]]'''||''' '''||
 
|-
 
|-
 
||'''[[character_xp (Database Table)|character_xp]]'''||''' '''||
 
||'''[[character_xp (Database Table)|character_xp]]'''||''' '''||
Line 58: Line 76:
 
|-
 
|-
 
||'''[[chat_attachments (Database Table)|chat_attachments]]'''||''' '''||
 
||'''[[chat_attachments (Database Table)|chat_attachments]]'''||''' '''||
|-
 
||'''[[chat_categories (Database Table)|chat_categories]]'''||''' '''||
 
 
|-
 
|-
 
||'''[[chat_channels (Database Table)|chat_channels]]'''||''' '''||
 
||'''[[chat_channels (Database Table)|chat_channels]]'''||''' '''||
 
|-
 
|-
 
||'''[[chat_channels_banned (Database Table)|chat_channels_banned]]'''||''' '''||
 
||'''[[chat_channels_banned (Database Table)|chat_channels_banned]]'''||''' '''||
 +
|-
 +
||'''[[chat_channels_invited (Database Table)|chat_channels_invited]]'''||''' '''||
 
|-
 
|-
 
||'''[[chat_channels_moderators (Database Table)|chat_channels_moderators]]'''||''' '''||
 
||'''[[chat_channels_moderators (Database Table)|chat_channels_moderators]]'''||''' '''||
Line 80: Line 98:
 
|-
 
|-
 
||'''[[clienteffects (Database Table)|clienteffects]]'''||''' '''||
 
||'''[[clienteffects (Database Table)|clienteffects]]'''||''' '''||
 +
|-
 +
||'''[[command_table (Database Table)|command_table]]'''||''' '''||
 
|-
 
|-
 
||'''[[commerce_auction (Database Table)|commerce_auction]]'''||''' '''||
 
||'''[[commerce_auction (Database Table)|commerce_auction]]'''||''' '''||
 
|-
 
|-
 
||'''[[commerce_bazaar (Database Table)|commerce_bazaar]]'''||''' '''||
 
||'''[[commerce_bazaar (Database Table)|commerce_bazaar]]'''||''' '''||
 +
|-
 +
||'''[[commerce_bidhistory (Database Table)|commerce_bidhistory]]'''||''' '''||
 +
|-
 +
||'''[[commerce_category (Database Table)|commerce_category]]'''||''' '''||
 +
|-
 +
||'''[[commerce_item_types (Database Table)|commerce_item_types]]'''||''' '''||
 
|-
 
|-
 
||'''[[config_message_routes (Database Table)|config_message_routes]]'''||''' '''||
 
||'''[[config_message_routes (Database Table)|config_message_routes]]'''||''' '''||
 
|-
 
|-
 
||'''[[config_process_list (Database Table)|config_process_list]]'''||''' '''||
 
||'''[[config_process_list (Database Table)|config_process_list]]'''||''' '''||
 +
|-
 +
||'''[[config_server (Database Table)|config_server]]'''||''' '''||
 +
|-
 +
||'''[[config_server_attributes (Database Table)|config_server_attributes]]'''||''' '''||
 +
|-
 +
||'''[[config_zone_scripts (Database Table)|config_zone_scripts]]'''||''' '''||
 
|-
 
|-
 
||'''[[config_zones (Database Table)|config_zones]]'''||''' '''||
 
||'''[[config_zones (Database Table)|config_zones]]'''||''' '''||
Line 97: Line 129:
 
||'''[[containers (Database Table)|containers]]'''||''' '''||
 
||'''[[containers (Database Table)|containers]]'''||''' '''||
 
|-
 
|-
||'''[[crafting_station_types (Database Table)|crafting_station_types]]'''||''' '''||
+
||'''[[conversation_animations (Database Table)|conversation_animations]]'''||''' '''||
 
|-
 
|-
||'''[[crafting_stations (Database Table)|crafting_stations]]'''||''' '''||
+
||'''[[conversation_event_types (Database Table)|conversation_event_types]]'''||''' '''||
 
|-
 
|-
||'''[[crafting_tool_types (Database Table)|crafting_tool_types]]'''||''' '''||
+
||'''[[conversation_option_batches (Database Table)|conversation_option_batches]]'''||''' '''||
 
|-
 
|-
||'''[[crafting_tools (Database Table)|crafting_tools]]'''||''' '''||
+
||'''[[conversation_options (Database Table)|conversation_options]]'''||''' '''||
 +
|-
 +
||'''[[conversation_pages (Database Table)|conversation_pages]]'''||''' '''||
 +
|-
 +
||'''[[conversations (Database Table)|conversations]]'''||''' '''||
 +
|-
 +
||'''[[craft_types (Database Table)|craft_types]]'''||''' '''||
 +
|-
 +
||'''[[creature_groups (Database Table)|creature_groups]]'''||''' '''||
 +
|-
 +
||'''[[creature_species (Database Table)|creature_species]]'''||''' '''||
 +
|-
 +
||'''[[csr_categories (Database Table)|csr_categories]]'''||''' '''||
 +
|-
 +
||'''[[csr_comments (Database Table)|csr_comments]]'''||''' '''||
 +
|-
 +
||'''[[csr_knowledgebase (Database Table)|csr_knowledgebase]]'''||''' '''||
 +
|-
 +
||'''[[csr_subcategories (Database Table)|csr_subcategories]]'''||''' '''||
 +
|-
 +
||'''[[csr_tickets (Database Table)|csr_tickets]]'''||''' '''||
 
|-
 
|-
 
||'''[[datapad_types (Database Table)|datapad_types]]'''||''' '''||
 
||'''[[datapad_types (Database Table)|datapad_types]]'''||''' '''||
Line 112: Line 164:
 
|-
 
|-
 
||'''[[draft_assembly_lists (Database Table)|draft_assembly_lists]]'''||''' '''||
 
||'''[[draft_assembly_lists (Database Table)|draft_assembly_lists]]'''||''' '''||
 +
|-
 +
||'''[[draft_craft_attribute_weights (Database Table)|draft_craft_atribute_weights]]'''||''' '''||
 +
|-
 +
||'''[[draft_craft_batches (Database Table)|draft_craft_batches]]'''||''' '''||
 +
|-
 +
||'''[[draft_craft_item_attribute_link (Database Table)|draft_craft_item_attribute_link]]'''||''' '''||
 +
|-
 +
||'''[[draft_craft_lists (Database Table)|draft_craft_lists]]'''||''' '''||
 
|-
 
|-
 
||'''[[draft_experiment_batches (Database Table)|draft_experiment_batches]]'''||''' '''||
 
||'''[[draft_experiment_batches (Database Table)|draft_experiment_batches]]'''||''' '''||
 +
|-
 +
||'''[[draft_experiment_groups (Database Table)|draft_experiment_groups]]'''||''' '''||
 
|-
 
|-
 
||'''[[draft_experiment_lists (Database Table)|draft_experiment_lists]]'''||''' '''||
 
||'''[[draft_experiment_lists (Database Table)|draft_experiment_lists]]'''||''' '''||
Line 119: Line 181:
 
||'''[[draft_lists_datatypes (Database Table)|draft_lists_datatypes]]'''||''' '''||
 
||'''[[draft_lists_datatypes (Database Table)|draft_lists_datatypes]]'''||''' '''||
 
|-
 
|-
||'''[[draft_schematics (Database Table)|draft_schematics]]v
+
||'''[[draft_schematic_attribute_manipulation (Database Table)|draft_schematic_attribute_manipulation]]'''||''' '''||
 +
|-
 +
||'''[[draft_schematic_customization (Database Table)|draft_schematic_customization]]'''||''' '''||
 +
|-
 +
||'''[[draft_schematic_item_link (Database Table)|draft_schematic_item_link]]'''||''' '''||
 +
|-
 +
||'''[[draft_schematic_manufacture_defaults (Database Table)|draft_schematic_manufacture_defaults]]'''||''' '''||
 +
|-
 +
||'''[[draft_schematics (Database Table)|draft_schematics]]'''||''' '''||
 
|-
 
|-
 
||'''[[draft_schematics_slots (Database Table)|draft_schematics_slots]]'''||''' '''||
 
||'''[[draft_schematics_slots (Database Table)|draft_schematics_slots]]'''||''' '''||
Line 128: Line 198:
 
|-
 
|-
 
||'''[[draft_weights (Database Table)|draft_weights]]'''||''' '''||
 
||'''[[draft_weights (Database Table)|draft_weights]]'''||''' '''||
 +
|-
 +
||'''[[entertainer_deny_service (Database Table)|entertainer_deny_service]]'''||''' '''||
 +
|-
 +
||'''[[entertainer_performances (Database Table)|entertainer_performances]]'''||''' '''||
 
|-
 
|-
 
||'''[[faction (Database Table)|faction]]'''||''' '''||
 
||'''[[faction (Database Table)|faction]]'''||''' '''||
 
|-
 
|-
||'''[[filler_npc_types (Database Table)|filler_npc_types]]'''||''' '''||
+
||'''[[factories (Database Table)|factories]]'''||''' '''||
 
|-
 
|-
||'''[[filler_npcs (Database Table)|filler_npcs]]'''||''' '''||
+
||'''[[frog_items (Database Table)|frog_items]]'''||''' '''||
 
|-
 
|-
||'''[[food_types (Database Table)|food_types]]'''||''' '''||
+
||'''[[galaxy (Database Table)|galaxy]]'''||''' '''||
 
|-
 
|-
||'''[[foods (Database Table)|foods]]'''||''' '''||
+
||'''[[galaxy_account (Database Table)|galaxy_account]]'''||''' '''||
 
|-
 
|-
||'''[[furniture_types (Database Table)|furniture_types]]'''||''' '''||
+
||'''[[galaxy_account_types (Database Table)|galaxy_account_types]]'''||''' '''||
 
|-
 
|-
||'''[[furnitures (Database Table)|furnitures]]'''||''' '''||
+
||'''[[harvester_resources (Database Table)|harvester_resources]]'''||''' '''||
 
|-
 
|-
||'''[[galaxy (Database Table)|galaxy]]'''||''' '''||
+
||'''[[harvesters (Database Table)|harvesters]]'''||''' '''||
 +
|-
 +
||'''[[holoemote (Database Table)|holoemote]]'''||''' '''||
 +
|-
 +
||'''[[houses (Database Table)|houses]]'''||''' '''||
 +
|-
 +
||'''[[id_attributes (Database Table)|id_attributes]]'''||''' '''||
 +
|-
 +
||'''[[internal (Database Table)|internal]]'''||''' '''||
 
|-
 
|-
 
||'''[[inventories (Database Table)|inventories]]'''||''' '''||
 
||'''[[inventories (Database Table)|inventories]]'''||''' '''||
 
|-
 
|-
 
||'''[[inventory_types (Database Table)|inventory_types]]'''||''' '''||
 
||'''[[inventory_types (Database Table)|inventory_types]]'''||''' '''||
 +
|-
 +
||'''[[item_attributes (Database Table)|item_attributes]]'''||''' '''||
 +
|-
 +
||'''[[item_customization (Database Table)|item_customization]]'''||''' '''||
 +
|-
 +
||'''[[item_families (Database Table)|item_families]]'''||''' '''||
 +
|-
 +
||'''[[item_family_attribute_defaults (Database Table)|item_family_defaults]]'''||''' '''||
 +
|-
 +
||'''[[item_types (Database Table)|item_types]]'''||''' '''||
 +
|-
 +
||'''[[items (Database Table)|items]]'''||''' '''||
 +
|-
 +
||'''[[lair_attributes (Database Table)|lair_attributes]]'''||''' '''||
 +
|-
 +
||'''[[lair_templates (Database Table)|lair_templates]]'''||''' '''||
 +
|-
 +
||'''[[lairs (Database Table)|lairs]]'''||''' '''||
 +
|-
 +
||'''[[log_error (Database Table)|log_error]]'''||''' '''||
 +
|-
 +
||'''[[loot_groups (Database Table)|loot_groups]]'''||''' '''||
 +
|-
 +
||'''[[loot_templates (Database Table)|loot_templates]]'''||''' '''||
 +
|-
 +
||'''[[manschemcomponents (Database Table)|manschemcomponents]]'''||''' '''||
 +
|-
 +
||'''[[manschemresources (Database Table)|manschemresourcs]]'''||''' '''||
 +
|-
 +
||'''[[manufactureschematic (Database Table)|manufacturesschematic]]'''||''' '''||
 +
|-
 +
||'''[[mission_names (Database Table)|mission_names]]'''||''' '''||
 +
|-
 +
||'''[[mission_terminal_mission_types (Database Table)|mission_terminal_mission_types]]'''||''' '''||
 +
|-
 +
||'''[[mission_text (Database Table)|mission_text]]'''||''' '''||
 +
|-
 +
||'''[[mission_types (Database Table)|mission_types]]'''||''' '''||
 
|-
 
|-
 
||'''[[moods (Database Table)|moods]]'''||''' '''||
 
||'''[[moods (Database Table)|moods]]'''||''' '''||
Line 161: Line 281:
 
||'''[[namegen_lastname (Database Table)|namegen_lastname]]'''||''' '''||
 
||'''[[namegen_lastname (Database Table)|namegen_lastname]]'''||''' '''||
 
|-
 
|-
||'''[[npc (Database Table)|npc]]'''||''' '''||
+
||'''[[non_persistent_npc_attributes (Database Table)|non_persistent_npc_attributes]]'''||''' '''||
 
|-
 
|-
||'''[[npc_attributes (Database Table)|npc_attributes]]'''||''' '''||
+
||'''[[non_persistent_npcs (Database Table)|non_persistent_npcs]]'''||''' '''||
 
|-
 
|-
||'''[[npc_defence (Database Table)|npc_defence]]'''||''' '''||
+
||'''[[npc_chatter (Database Table)|npc_chatter]]'''||''' '''||
 
|-
 
|-
||'''[[npc_faction (Database Table)|npc_faction]]'''||''' '''||
+
||'''[[object_attributes (Database Table)|object_attributes]]'''||''' '''||
 
|-
 
|-
||'''[[npc_harvest (Database Table)|npc_harvest]]'''||''' '''||
+
||'''[[object_models (Database Table)|object_models]]'''||''' '''||
 
|-
 
|-
||'''[[npc_objects (Database Table)|npc_objects]]'''||''' '''||
+
||'''[[parking_garage (Database Table)|parking_garage]]'''||''' '''||
 
|-
 
|-
||'''[[npc_specials (Database Table)|npc_specials]]'''||''' '''||
+
||'''[[persistent_npc_attributes (Database Table)|persistent_npc_families]]'''||''' '''||
 
|-
 
|-
||'''[[npc_static_spawns (Database Table)|npc_static_spawns]]'''||''' '''||
+
||'''[[persistent_npcs (Database Table)|persistent_npcs]]'''||''' '''||
|-
+
||'''[[npc_template (Database Table)|npc_template]]'''||''' '''||
+
|-
+
||'''[[npc_type (Database Table)|npc_type]]'''||''' '''||
+
|-
+
||'''[[npc_xp (Database Table)|npc_xp]]'''||''' '''||
+
|-
+
||'''[[parking_garage (Database Table)|parking_garage]]'''||''' '''||
+
 
|-
 
|-
 
||'''[[planet (Database Table)|planet]]'''||''' '''||
 
||'''[[planet (Database Table)|planet]]'''||''' '''||
Line 210: Line 322:
 
|-
 
|-
 
||'''[[resources_spawn_config (Database Table)|resources_spawn_config]]'''||''' '''||
 
||'''[[resources_spawn_config (Database Table)|resources_spawn_config]]'''||''' '''||
 +
|-
 +
||'''[[schem_crc (Database Table)|schem_crc]]'''||''' '''||
 
|-
 
|-
 
||'''[[schematic_groups (Database Table)|schematic_groups]]'''||''' '''||
 
||'''[[schematic_groups (Database Table)|schematic_groups]]'''||''' '''||
 +
|-
 +
||'''[[server (Database Table)|server]]'''||''' '''||
 
|-
 
|-
 
||'''[[shuttle_types (Database Table)|shuttle_types]]'''||''' '''||
 
||'''[[shuttle_types (Database Table)|shuttle_types]]'''||''' '''||
Line 224: Line 340:
 
|-
 
|-
 
||'''[[skills_base_xp_groups (Database Table)|skills_base_xp_groups]]'''||''' '''||
 
||'''[[skills_base_xp_groups (Database Table)|skills_base_xp_groups]]'''||''' '''||
 +
|-
 +
||'''[[skills_description (Database Table)|skills_description]]'''||''' '''||
 
|-
 
|-
 
||'''[[skills_jedi_states (Database Table)|skills_jedi_states]]'''||''' '''||
 
||'''[[skills_jedi_states (Database Table)|skills_jedi_states]]'''||''' '''||
Line 244: Line 362:
 
|-
 
|-
 
||'''[[spawn_clone (Database Table)|spawn_clone]]'''||''' '''||
 
||'''[[spawn_clone (Database Table)|spawn_clone]]'''||''' '''||
 +
|-
 +
||'''[[spawn_groups (Database Table)|spawn_groups]]'''||''' '''||
 +
|-
 +
||'''[[spawn_regions (Database Table)|spawn_regions]]'''||''' '''||
 
|-
 
|-
 
||'''[[spawn_shuttle (Database Table)|spawn_shuttle]]'''||''' '''||
 
||'''[[spawn_shuttle (Database Table)|spawn_shuttle]]'''||''' '''||
 +
|-
 +
||'''[[spawns (Database Table)|spawns]]'''||''' '''||
 
|-
 
|-
 
||'''[[starting_attributes (Database Table)|starting_attributes]]'''||''' '''||
 
||'''[[starting_attributes (Database Table)|starting_attributes]]'''||''' '''||
 +
|-
 +
||'''[[starting_item_requirements (Database Table)|starting_item_requirements]]'''||''' '''||
 
|-
 
|-
 
||'''[[starting_items (Database Table)|starting_items]]'''||''' '''||
 
||'''[[starting_items (Database Table)|starting_items]]'''||''' '''||
Line 257: Line 383:
 
||'''[[static_types (Database Table)|static_types]]'''||''' '''||
 
||'''[[static_types (Database Table)|static_types]]'''||''' '''||
 
|-
 
|-
||'''[[survey_tool_types (Database Table)|survey_tool_types]]'''||''' '''||
+
||'''[[stf_files (Database Table)|stf_files]]'''||''' '''||
 
|-
 
|-
||'''[[survey_tools (Database Table)|survey_tools]]'''||''' '''||
+
||'''[[stf_variable (Database Table)|stf_variable]]'''||''' '''||
 
|-
 
|-
||'''[[terminal_elevator_data (Database Table)|terminal_elevator_data]]'''||''' '''||
+
||'''[[structure_admin_data (Database Table)|structure_admin_data]]'''||''' '''||
 
|-
 
|-
||'''[[terminal_types (Database Table)|terminal_types]]'''||''' '''||
+
||'''[[structure_attribute_defaults (Database Table)|structure_attribute_defaults]]'''||''' '''||
 
|-
 
|-
||'''[[terminals (Database Table)|terminals]]'''||''' '''||
+
||'''[[structure_attributes (Database Table)|structure_attributes]]'''||''' '''||
 
|-
 
|-
||'''[[ticket_collectors (Database Table)|ticket_collectors]]'''||''' '''||
+
||'''[[structure_deed_data (Database Table)|structure_deed_data]]'''||''' '''||
 
|-
 
|-
||'''[[trainer_types (Database Table)|trainer_types]]'''||''' '''||
+
||'''[[structure_item_templates (Database Table)|structure_item_templates]]'''||''' '''||
 
|-
 
|-
||'''[[trainers (Database Table)|trainers]]'''||''' '''||
+
||'''[[structure_terminal_link (Database Table)|structure_terminal_link]]'''||''' '''||
 
|-
 
|-
||'''[[travel_planet_routes (Database Table)|travel_planet_routes]]'''||''' '''||
+
||'''[[structure_type_data (Database Table)|structure_type_data]]'''||''' '''||
 
|-
 
|-
||'''[[travel_tickets (Database Table)|travel_tickets]]'''||''' '''||
+
||'''[[structures (Database Table)|structures]]'''||''' '''||
 
|-
 
|-
||'''[[v_planetmapcorellia (Database View)|v_planetmapcorellia]]'''||''' '''||(View) -> Planet Map For Corellia
+
||'''[[terminal_elevator_data (Database Table)|terminal_elevator_data]]'''||''' '''||
 
|-
 
|-
||'''[[v_planetmapdantooine (Database View)|v_planetmapdantooine]]'''||''' '''||(View) -> Planet Map For Dantooine
+
||'''[[terminal_types (Database Table)|terminal_types]]'''||''' '''||
 
|-
 
|-
||'''[[v_planetmapdathomir (Database View)|v_planetmapdathomir]]'''||''' '''||(View) -> Planet Map For Dathomir
+
||'''[[terminals (Database Table)|terminals]]'''||''' '''||
 
|-
 
|-
||'''[[v_planetmapdungeon1 (Database View)|v_planetmapdungeon1]]'''||''' '''||(View) -> Planet Map For Dungeon1
+
||'''[[ticket_collectors (Database Table)|ticket_collectors]]'''||''' '''||
 
|-
 
|-
||'''[[v_planetmapendor (Database View)|v_planetmapendor]]'''||''' '''||(View) -> Planet Map For Endor
+
||'''[[travel_planet_routes (Database Table)|travel_planet_routes]]'''||''' '''||
 
|-
 
|-
||'''[[v_planetmaplok (Database View)|v_planetmaplok]]'''||''' '''||(View) -> Planet Map For Lok
+
||'''[[vehicle_attributes (Database Table)|vehicle_attributes]]'''||''' '''||
 
|-
 
|-
||'''[[v_planetmapnaboo (Database View)|v_planetmapnaboo]]'''||''' '''||(View) -> Planet Map For Naboo
+
||'''[[vehicle_customization (Database Table)|vehicle_customization]]'''||''' '''||
 
|-
 
|-
||'''[[v_planetmaprori (Database View)|v_planetmaprori]]'''||''' '''||(View) -> Planet Map For Rori
+
||'''[[vehicle_families (Database Table)|vehicle_families]]'''||''' '''||
 
|-
 
|-
||'''[[v_planetmaptaanab (Database View)|v_planetmaptaanab]]'''||''' '''||(View) -> Planet Map For Taanab
+
||'''[[vehicle_type_attributes (Database Table)|vehicle_type_attributes]]'''||''' '''||
 
|-
 
|-
||'''[[v_planetmaptalus (Database View)|v_planetmaptalus]]'''||''' '''||(View) -> Planet Map For Talus
+
||'''[[vehicle_types (Database Table)|vehicle_types]]'''||''' '''||
 
|-
 
|-
||'''[[v_planetmaptatooine (Database View)|v_planetmaptatooine]]'''||''' '''||(View) -> Planet Map For Tatooine
+
||'''[[vehicles (Database Table)|vehicles]]'''||''' '''||
|-
+
||'''[[v_planetmaptutorial (Database View)|v_planetmaptutorial]]'''||''' '''||(View) -> Planet Map For Tutorial
+
|-
+
||'''[[v_planetmapyavin4 (Database View)|v_planetmapyavin4]]'''||''' '''||(View) -> Planet Map For Yavin IV
+
 
|-
 
|-
 
||'''[[waypoint (Database Table)|waypoint]]'''||''' '''||(Table) -> Datapad: Waypoints
 
||'''[[waypoint (Database Table)|waypoint]]'''||''' '''||(Table) -> Datapad: Waypoints
 
|-
 
|-
||'''[[weapon_types (Database Table)|weapon_types]]'''||''' '''||(Table) -> Weapon Type List
+
||'''[[weapon_groups (Database Table)|weapon_groups]]'''||''' '''||(Table) -> Weapon Type List
|-
+
||'''[[weapons (Database Table)|weapons]]'''||''' '''||(Table) -> Inventory: Weapons
+
|-
+
||'''[[wearable_types (Database Table)|wearable_types]]'''||''' '''||(Table) -> Wearables Type List
+
|-
+
||'''[[wearables (Database Table)|wearables]]'''||''' '''||(Table) -> Inventory: Wearables
+
 
|-
 
|-
 
||'''[[xp_types (Database Table)|xp_types]]'''||''' '''||(Table) -> XP Type List
 
||'''[[xp_types (Database Table)|xp_types]]'''||''' '''||(Table) -> XP Type List
 +
|-
 +
||'''[[zone_regions (Database Table)|zone_regions]]'''||''' '''||(Table) -> Server Zone Regions
 
|-
 
|-
 
|}
 
|}
Line 319: Line 437:
 
|valign=top|
 
|valign=top|
  
 +
 +
[[Image:db.jpg|thumb|250px|SWGANH Database Schema]]
  
 
[[Image:Schema.jpg|thumb|250px|SWGANH Database Schema]]
 
[[Image:Schema.jpg|thumb|250px|SWGANH Database Schema]]
  
 +
[[Image:SWGANH---(DB)-Character-Table-Relations.jpg|thumb|250px|Character Table Relation]]
 +
 +
[[Image:SWGANH---(DB)-NPCs-Table-Relations.jpg|thumb|250px|NPC Table Relation]]
 +
 +
[[Image:SWGANH - Table Structure - Conversations.jpg|thumb|250px|Conversation Table Relation]]
 
|}
 
|}

Latest revision as of 13:07, 13 March 2010

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