Difference between revisions of "Portal:SWGANH Database Documentation"

From SWGANH Wiki
Jump to: navigation, search
Line 33: Line 33:
 
||'''[[biography_wars (Database Table)|biography_wars]]'''||'''Biography'''||(Table) -> Biography Generator
 
||'''[[biography_wars (Database Table)|biography_wars]]'''||'''Biography'''||(Table) -> Biography Generator
 
|-
 
|-
−
||'''[[building_types (Database Table)|building_types]]''|''' '''||
+
||'''[[building_types (Database Table)|building_types]]'''||''' '''||
 
|-
 
|-
−
||'''[[buildings (Database Table)|buildings]]''|''' '''||
+
||'''[[buildings (Database Table)|buildings]]'''||''' '''||
 
|-
 
|-
−
||'''[[cells (Database Table)|cells]]''|''' '''||
+
||'''[[cells (Database Table)|cells]]'''||''' '''||
 
|-
 
|-
−
||'''[[character_appearance (Database Table)|character_appearance]]''|''' '''||
+
||'''[[character_appearance (Database Table)|character_appearance]]'''||''' '''||
 
|-
 
|-
−
||'''[[character_attributes (Database Table)|character_attributes]]''|''' '''||
+
||'''[[character_attributes (Database Table)|character_attributes]]'''||''' '''||
 
|-
 
|-
−
||'''[[character_badges (Database Table)|character_badges]]''|''' '''||
+
||'''[[character_badges (Database Table)|character_badges]]'''||''' '''||
 
|-
 
|-
−
||'''[[character_biography (Database Table)|character_biography]]''|''' '''||
+
||'''[[character_biography (Database Table)|character_biography]]'''||''' '''||
 
|-
 
|-
−
||'''[[character_faction (Database Table)|character_faction]]''|''' '''||
+
||'''[[character_faction (Database Table)|character_faction]]'''||''' '''||
 
|-
 
|-
−
||'''[[character_skills (Database Table)|character_skills]]''|''' '''||
+
||'''[[character_skills (Database Table)|character_skills]]'''||''' '''||
 
|-
 
|-
−
||'''[[character_waypoints (Database Table)|character_waypoints]]''|''' '''||
+
||'''[[character_waypoints (Database Table)|character_waypoints]]'''||''' '''||
 
|-
 
|-
−
||'''[[character_xp (Database Table)|character_xp]]''|''' '''||
+
||'''[[character_xp (Database Table)|character_xp]]'''||''' '''||
 
|-
 
|-
−
||'''[[characters (Database Table)|characters]]''|''' '''||
+
||'''[[characters (Database Table)|characters]]'''||''' '''||
 
|-
 
|-
−
||'''[[chat_attachments (Database Table)|chat_attachments]]''|''' '''||
+
||'''[[chat_attachments (Database Table)|chat_attachments]]'''||''' '''||
 
|-
 
|-
−
||'''[[chat_categories (Database Table)|chat_categories]]''|''' '''||
+
||'''[[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_moderators (Database Table)|chat_channels_moderators]]''|''' '''||
+
||'''[[chat_channels_moderators (Database Table)|chat_channels_moderators]]'''||''' '''||
 
|-
 
|-
−
||'''[[chat_char_channels (Database Table)|chat_char_channels]]''|''' '''||
+
||'''[[chat_char_channels (Database Table)|chat_char_channels]]'''||''' '''||
 
|-
 
|-
−
||'''[[chat_friendlist (Database Table)|chat_friendlist]]''|''' '''||
+
||'''[[chat_friendlist (Database Table)|chat_friendlist]]'''||''' '''||
 
|-
 
|-
−
||'''[[chat_ignorelist (Database Table)|chat_ignorelist]]''|''' '''||
+
||'''[[chat_ignorelist (Database Table)|chat_ignorelist]]'''||''' '''||
 
|-
 
|-
−
||'''[[chat_mail (Database Table)|chat_mail]]''|''' '''||
+
||'''[[chat_mail (Database Table)|chat_mail]]'''||''' '''||
 
|-
 
|-
−
||'''[[chat_mail_attachments (Database Table)|chat_mail_attachments]]''|''' '''||
+
||'''[[chat_mail_attachments (Database Table)|chat_mail_attachments]]'''||''' '''||
 
|-
 
|-
−
||'''[[cities (Database Table)|cities]]''|''' '''||
+
||'''[[cities (Database Table)|cities]]'''||''' '''||
 
|-
 
|-
−
||'''[[clienteffects (Database Table)|clienteffects]]''|''' '''||
+
||'''[[clienteffects (Database Table)|clienteffects]]'''||''' '''||
 
|-
 
|-
−
||'''[[commerce_auction (Database Table)|commerce_auction]]''|''' '''||
+
||'''[[commerce_auction (Database Table)|commerce_auction]]'''||''' '''||
 
|-
 
|-
−
||'''[[commerce_bazaar (Database Table)|commerce_bazaar]]''|''' '''||
+
||'''[[commerce_bazaar (Database Table)|commerce_bazaar]]'''||''' '''||
 
|-
 
|-
−
||'''[[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_zones (Database Table)|config_zones]]''|''' '''||
+
||'''[[config_zones (Database Table)|config_zones]]'''||''' '''||
 
|-
 
|-
−
||'''[[container_item (Database Table)|container_item]]''|''' '''||
+
||'''[[container_item (Database Table)|container_item]]'''||''' '''||
 
|-
 
|-
−
||'''[[container_types (Database Table)|container_types]]''|''' '''||
+
||'''[[container_types (Database Table)|container_types]]'''||''' '''||
 
|-
 
|-
−
||'''[[containers (Database Table)|containers]]''|''' '''||
+
||'''[[containers (Database Table)|containers]]'''||''' '''||
 
|-
 
|-
−
||'''[[crafting_station_types (Database Table)|crafting_station_types]]''|''' '''||
+
||'''[[crafting_station_types (Database Table)|crafting_station_types]]'''||''' '''||
 
|-
 
|-
−
||'''[[crafting_stations (Database Table)|crafting_stations]]''|''' '''||
+
||'''[[crafting_stations (Database Table)|crafting_stations]]'''||''' '''||
 
|-
 
|-
−
||'''[[crafting_tool_types (Database Table)|crafting_tool_types]]''|''' '''||
+
||'''[[crafting_tool_types (Database Table)|crafting_tool_types]]'''||''' '''||
 
|-
 
|-
−
||'''[[crafting_tools (Database Table)|crafting_tools]]''|''' '''||
+
||'''[[crafting_tools (Database Table)|crafting_tools]]'''||''' '''||
 
|-
 
|-
−
||'''[[datapad_types (Database Table)|datapad_types]]''|''' '''||
+
||'''[[datapad_types (Database Table)|datapad_types]]'''||''' '''||
 
|-
 
|-
−
||'''[[datapads (Database Table)|datapads]]''|''' '''||
+
||'''[[datapads (Database Table)|datapads]]'''||''' '''||
 
|-
 
|-
−
||'''[[draft_assembly_batches (Database Table)|draft_assembly_batches]]''|''' '''||
+
||'''[[draft_assembly_batches (Database Table)|draft_assembly_batches]]'''||''' '''||
 
|-
 
|-
−
||'''[[draft_assembly_lists (Database Table)|draft_assembly_lists]]''|''' '''||
+
||'''[[draft_assembly_lists (Database Table)|draft_assembly_lists]]'''||''' '''||
 
|-
 
|-
−
||'''[[draft_experiment_batches (Database Table)|draft_experiment_batches]]''|''' '''||
+
||'''[[draft_experiment_batches (Database Table)|draft_experiment_batches]]'''||''' '''||
 
|-
 
|-
−
||'''[[draft_experiment_lists (Database Table)|draft_experiment_lists]]''|''' '''||
+
||'''[[draft_experiment_lists (Database Table)|draft_experiment_lists]]'''||''' '''||
 
|-
 
|-
−
||'''[[draft_lists_datatypes (Database Table)|draft_lists_datatypes]]''|''' '''||
+
||'''[[draft_lists_datatypes (Database Table)|draft_lists_datatypes]]'''||''' '''||
 
|-
 
|-
 
||'''[[draft_schematics (Database Table)|draft_schematics]]v
 
||'''[[draft_schematics (Database Table)|draft_schematics]]v
 
|-
 
|-
−
||'''[[draft_schematics_slots (Database Table)|draft_schematics_slots]]''|''' '''||
+
||'''[[draft_schematics_slots (Database Table)|draft_schematics_slots]]'''||''' '''||
 
|-
 
|-
−
||'''[[draft_slot_types (Database Table)|draft_slot_types]]''|''' '''||
+
||'''[[draft_slot_types (Database Table)|draft_slot_types]]'''||''' '''||
 
|-
 
|-
−
||'''[[draft_slots (Database Table)|draft_slots]]''|''' '''||
+
||'''[[draft_slots (Database Table)|draft_slots]]'''||''' '''||
 
|-
 
|-
−
||'''[[draft_weights (Database Table)|draft_weights]]''|''' '''||
+
||'''[[draft_weights (Database Table)|draft_weights]]'''||''' '''||
 
|-
 
|-
−
||'''[[faction (Database Table)|faction]]''|''' '''||
+
||'''[[faction (Database Table)|faction]]'''||''' '''||
 
|-
 
|-
−
||'''[[filler_npc_types (Database Table)|filler_npc_types]]''|''' '''||
+
||'''[[filler_npc_types (Database Table)|filler_npc_types]]'''||''' '''||
 
|-
 
|-
−
||'''[[filler_npcs (Database Table)|filler_npcs]]''|''' '''||
+
||'''[[filler_npcs (Database Table)|filler_npcs]]'''||''' '''||
 
|-
 
|-
−
||'''[[food_types (Database Table)|food_types]]''|''' '''||
+
||'''[[food_types (Database Table)|food_types]]'''||''' '''||
 
|-
 
|-
−
||'''[[foods (Database Table)|foods]]''|''' '''||
+
||'''[[foods (Database Table)|foods]]'''||''' '''||
 
|-
 
|-
−
||'''[[furniture_types (Database Table)|furniture_types]]''|''' '''||
+
||'''[[furniture_types (Database Table)|furniture_types]]'''||''' '''||
 
|-
 
|-
−
||'''[[furnitures (Database Table)|furnitures]]''|''' '''||
+
||'''[[furnitures (Database Table)|furnitures]]'''||''' '''||
 
|-
 
|-
−
||'''[[galaxy (Database Table)|galaxy]]''|''' '''||
+
||'''[[galaxy (Database Table)|galaxy]]'''||''' '''||
 
|-
 
|-
−
||'''[[inventories (Database Table)|inventories]]''|''' '''||
+
||'''[[inventories (Database Table)|inventories]]'''||''' '''||
 
|-
 
|-
−
||'''[[inventory_types (Database Table)|inventory_types]]''|''' '''||
+
||'''[[inventory_types (Database Table)|inventory_types]]'''||''' '''||
 
|-
 
|-
−
||'''[[moods (Database Table)|moods]]''|''' '''||
+
||'''[[moods (Database Table)|moods]]'''||''' '''||
 
|-
 
|-
−
||'''[[name_developer (Database Table)|name_developer]]''|''' '''||
+
||'''[[name_developer (Database Table)|name_developer]]'''||''' '''||
 
|-
 
|-
−
||'''[[name_profane (Database Table)|name_profane]]''|''' '''||
+
||'''[[name_profane (Database Table)|name_profane]]'''||''' '''||
 
|-
 
|-
−
||'''[[name_reserved (Database Table)|name_reserved]]''|''' '''||
+
||'''[[name_reserved (Database Table)|name_reserved]]'''||''' '''||
 
|-
 
|-
−
||'''[[namegen_firstname (Database Table)|namegen_firstname]]''|''' '''||
+
||'''[[namegen_firstname (Database Table)|namegen_firstname]]'''||''' '''||
 
|-
 
|-
−
||'''[[namegen_lastname (Database Table)|namegen_lastname]]''|''' '''||
+
||'''[[namegen_lastname (Database Table)|namegen_lastname]]'''||''' '''||
 
|-
 
|-
−
||'''[[npc (Database Table)|npc]]''|''' '''||
+
||'''[[npc (Database Table)|npc]]'''||''' '''||
 
|-
 
|-
−
||'''[[npc_attributes (Database Table)|npc_attributes]]''|''' '''||
+
||'''[[npc_attributes (Database Table)|npc_attributes]]'''||''' '''||
 
|-
 
|-
−
||'''[[npc_defence (Database Table)|npc_defence]]''|''' '''||
+
||'''[[npc_defence (Database Table)|npc_defence]]'''||''' '''||
 
|-
 
|-
−
||'''[[npc_faction (Database Table)|npc_faction]]''|''' '''||
+
||'''[[npc_faction (Database Table)|npc_faction]]'''||''' '''||
 
|-
 
|-
−
||'''[[npc_harvest (Database Table)|npc_harvest]]''|''' '''||
+
||'''[[npc_harvest (Database Table)|npc_harvest]]'''||''' '''||
 
|-
 
|-
−
||'''[[npc_objects (Database Table)|npc_objects]]''|''' '''||
+
||'''[[npc_objects (Database Table)|npc_objects]]'''||''' '''||
 
|-
 
|-
−
||'''[[npc_specials (Database Table)|npc_specials]]''|''' '''||
+
||'''[[npc_specials (Database Table)|npc_specials]]'''||''' '''||
 
|-
 
|-
−
||'''[[npc_static_spawns (Database Table)|npc_static_spawns]]''|''' '''||
+
||'''[[npc_static_spawns (Database Table)|npc_static_spawns]]'''||''' '''||
 
|-
 
|-
−
||'''[[npc_template (Database Table)|npc_template]]''|''' '''||
+
||'''[[npc_template (Database Table)|npc_template]]'''||''' '''||
 
|-
 
|-
−
||'''[[npc_type (Database Table)|npc_type]]''|''' '''||
+
||'''[[npc_type (Database Table)|npc_type]]'''||''' '''||
 
|-
 
|-
−
||'''[[npc_xp (Database Table)|npc_xp]]''|''' '''||
+
||'''[[npc_xp (Database Table)|npc_xp]]'''||''' '''||
 
|-
 
|-
−
||'''[[parking_garage (Database Table)|parking_garage]]''|''' '''||
+
||'''[[parking_garage (Database Table)|parking_garage]]'''||''' '''||
 
|-
 
|-
−
||'''[[planet (Database Table)|planet]]''|''' '''||
+
||'''[[planet (Database Table)|planet]]'''||''' '''||
 
|-
 
|-
−
||'''[[planet_regions (Database Table)|planet_regions]]''|''' '''||
+
||'''[[planet_regions (Database Table)|planet_regions]]'''||''' '''||
 
|-
 
|-
−
||'''[[planetmap (Database Table)|planetmap]]''|''' '''||
+
||'''[[planetmap (Database Table)|planetmap]]'''||''' '''||
 
|-
 
|-
−
||'''[[planetmapcategory (Database Table)|planetmapcategory]]''|''' '''||
+
||'''[[planetmapcategory (Database Table)|planetmapcategory]]'''||''' '''||
 
|-
 
|-
−
||'''[[quests (Database Table)|quests]]''|''' '''||
+
||'''[[quests (Database Table)|quests]]'''||''' '''||
 
|-
 
|-
−
||'''[[race (Database Table)|race]]''|''' '''||
+
||'''[[race (Database Table)|race]]'''||''' '''||
 
|-
 
|-
−
||'''[[resource_categories (Database Table)|resource_categories]]''|''' '''||
+
||'''[[resource_categories (Database Table)|resource_categories]]'''||''' '''||
 
|-
 
|-
−
||'''[[resource_containers (Database Table)|resource_containers]]''|''' '''||
+
||'''[[resource_containers (Database Table)|resource_containers]]'''||''' '''||
 
|-
 
|-
−
||'''[[resource_name_begin (Database Table)|resource_name_begin]]''|''' '''||
+
||'''[[resource_name_begin (Database Table)|resource_name_begin]]'''||''' '''||
 
|-
 
|-
−
||'''[[resource_name_end (Database Table)|resource_name_end]]''|''' '''||
+
||'''[[resource_name_end (Database Table)|resource_name_end]]'''||''' '''||
 
|-
 
|-
−
||'''[[resource_template (Database Table)|resource_template]]''|''' '''||
+
||'''[[resource_template (Database Table)|resource_template]]'''||''' '''||
 
|-
 
|-
−
||'''[[resources (Database Table)|resources]]''|''' '''||
+
||'''[[resources (Database Table)|resources]]'''||''' '''||
 
|-
 
|-
−
||'''[[resources_spawn_config (Database Table)|resources_spawn_config]]''|''' '''||
+
||'''[[resources_spawn_config (Database Table)|resources_spawn_config]]'''||''' '''||
 
|-
 
|-
−
||'''[[schematic_groups (Database Table)|schematic_groups]]''|''' '''||
+
||'''[[schematic_groups (Database Table)|schematic_groups]]'''||''' '''||
 
|-
 
|-
−
||'''[[shuttle_types (Database Table)|shuttle_types]]''|''' '''||
+
||'''[[shuttle_types (Database Table)|shuttle_types]]'''||''' '''||
 
|-
 
|-
−
||'''[[shuttles (Database Table)|shuttles]]''|''' '''||
+
||'''[[shuttles (Database Table)|shuttles]]'''||''' '''||
 
|-
 
|-
−
||'''[[skillcommands (Database Table)|skillcommands]]''|''' '''||
+
||'''[[skillcommands (Database Table)|skillcommands]]'''||''' '''||
 
|-
 
|-
−
||'''[[skillmods (Database Table)|skillmods]]''|''' '''||
+
||'''[[skillmods (Database Table)|skillmods]]'''||''' '''||
 
|-
 
|-
−
||'''[[skills (Database Table)|skills]]''|''' '''||
+
||'''[[skills (Database Table)|skills]]'''||''' '''||
 
|-
 
|-
−
||'''[[skills_base_xp_groups (Database Table)|skills_base_xp_groups]]''|''' '''||
+
||'''[[skills_base_xp_groups (Database Table)|skills_base_xp_groups]]'''||''' '''||
 
|-
 
|-
−
||'''[[skills_jedi_states (Database Table)|skills_jedi_states]]''|''' '''||
+
||'''[[skills_jedi_states (Database Table)|skills_jedi_states]]'''||''' '''||
 
|-
 
|-
−
||'''[[skills_preclusions (Database Table)|skills_preclusions]]''|''' '''||
+
||'''[[skills_preclusions (Database Table)|skills_preclusions]]'''||''' '''||
 
|-
 
|-
−
||'''[[skills_schematicsgranted (Database Table)|skills_schematicsgranted]]''|''' '''||
+
||'''[[skills_schematicsgranted (Database Table)|skills_schematicsgranted]]'''||''' '''||
 
|-
 
|-
−
||'''[[skills_skill_skillparent (Database Table)|skills_skill_skillparent]]''|''' '''||
+
||'''[[skills_skill_skillparent (Database Table)|skills_skill_skillparent]]'''||''' '''||
 
|-
 
|-
−
||'''[[skills_skill_skillsrequired (Database Table)|skills_skill_skillsrequired]]''|''' '''||
+
||'''[[skills_skill_skillsrequired (Database Table)|skills_skill_skillsrequired]]'''||''' '''||
 
|-
 
|-
−
||'''[[skills_skillcommands (Database Table)|skills_skillcommands]]''|''' '''||
+
||'''[[skills_skillcommands (Database Table)|skills_skillcommands]]'''||''' '''||
 
|-
 
|-
−
||'''[[skills_skillmods (Database Table)|skills_skillmods]]''|''' '''||
+
||'''[[skills_skillmods (Database Table)|skills_skillmods]]'''||''' '''||
 
|-
 
|-
−
||'''[[skills_species_required (Database Table)|skills_species_required]]''|''' '''||
+
||'''[[skills_species_required (Database Table)|skills_species_required]]'''||''' '''||
 
|-
 
|-
−
||'''[[sounds (Database Table)|sounds]]''|''' '''||
+
||'''[[sounds (Database Table)|sounds]]'''||''' '''||
 
|-
 
|-
−
||'''[[spawn_clone (Database Table)|spawn_clone]]''|''' '''||
+
||'''[[spawn_clone (Database Table)|spawn_clone]]'''||''' '''||
 
|-
 
|-
−
||'''[[spawn_shuttle (Database Table)|spawn_shuttle]]''|''' '''||
+
||'''[[spawn_shuttle (Database Table)|spawn_shuttle]]'''||''' '''||
 
|-
 
|-
−
||'''[[starting_attributes (Database Table)|starting_attributes]]''|''' '''||
+
||'''[[starting_attributes (Database Table)|starting_attributes]]'''||''' '''||
 
|-
 
|-
−
||'''[[starting_items (Database Table)|starting_items]]''|''' '''||
+
||'''[[starting_items (Database Table)|starting_items]]'''||''' '''||
 
|-
 
|-
−
||'''[[starting_location (Database Table)|starting_location]]''|''' '''||
+
||'''[[starting_location (Database Table)|starting_location]]'''||''' '''||
 
|-
 
|-
−
||'''[[static_objects (Database Table)|static_objects]]''|''' '''||
+
||'''[[static_objects (Database Table)|static_objects]]'''||''' '''||
 
|-
 
|-
−
||'''[[static_types (Database Table)|static_types]]''|''' '''||
+
||'''[[static_types (Database Table)|static_types]]'''||''' '''||
 
|-
 
|-
−
||'''[[survey_tool_types (Database Table)|survey_tool_types]]''|''' '''||
+
||'''[[survey_tool_types (Database Table)|survey_tool_types]]'''||''' '''||
 
|-
 
|-
−
||'''[[survey_tools (Database Table)|survey_tools]]''|''' '''||
+
||'''[[survey_tools (Database Table)|survey_tools]]'''||''' '''||
 
|-
 
|-
−
||'''[[terminal_elevator_data (Database Table)|terminal_elevator_data]]''|''' '''||
+
||'''[[terminal_elevator_data (Database Table)|terminal_elevator_data]]'''||''' '''||
 
|-
 
|-
−
||'''[[terminal_types (Database Table)|terminal_types]]''|''' '''||
+
||'''[[terminal_types (Database Table)|terminal_types]]'''||''' '''||
 
|-
 
|-
−
||'''[[terminals (Database Table)|terminals]]''|''' '''||
+
||'''[[terminals (Database Table)|terminals]]'''||''' '''||
 
|-
 
|-
−
||'''[[ticket_collectors (Database Table)|ticket_collectors]]''|''' '''||
+
||'''[[ticket_collectors (Database Table)|ticket_collectors]]'''||''' '''||
 
|-
 
|-
−
||'''[[trainer_types (Database Table)|trainer_types]]''|''' '''||
+
||'''[[trainer_types (Database Table)|trainer_types]]'''||''' '''||
 
|-
 
|-
−
||'''[[trainers (Database Table)|trainers]]''|''' '''||
+
||'''[[trainers (Database Table)|trainers]]'''||''' '''||
 
|-
 
|-
−
||'''[[travel_planet_routes (Database Table)|travel_planet_routes]]''|''' '''||
+
||'''[[travel_planet_routes (Database Table)|travel_planet_routes]]'''||''' '''||
 
|-
 
|-
−
||'''[[travel_tickets (Database Table)|travel_tickets]]''|''' '''||
+
||'''[[travel_tickets (Database Table)|travel_tickets]]'''||''' '''||
 
|-
 
|-
−
||'''[[v_planetmapcorellia (Database View)|v_planetmapcorellia]]''|''' '''||(View) -> Planet Map For Corellia
+
||'''[[v_planetmapcorellia (Database View)|v_planetmapcorellia]]'''||''' '''||(View) -> Planet Map For Corellia
 
|-
 
|-
−
||'''[[v_planetmapdantooine (Database View)|v_planetmapdantooine]]''|''' '''||(View) -> Planet Map For Dantooine
+
||'''[[v_planetmapdantooine (Database View)|v_planetmapdantooine]]'''||''' '''||(View) -> Planet Map For Dantooine
 
|-
 
|-
−
||'''[[v_planetmapdathomir (Database View)|v_planetmapdathomir]]''|''' '''||(View) -> Planet Map For Dathomir
+
||'''[[v_planetmapdathomir (Database View)|v_planetmapdathomir]]'''||''' '''||(View) -> Planet Map For Dathomir
 
|-
 
|-
−
||'''[[v_planetmapdungeon1 (Database View)|v_planetmapdungeon1]]''|''' '''||(View) -> Planet Map For Dungeon1
+
||'''[[v_planetmapdungeon1 (Database View)|v_planetmapdungeon1]]'''||''' '''||(View) -> Planet Map For Dungeon1
 
|-
 
|-
−
||'''[[v_planetmapendor (Database View)|v_planetmapendor]]''|''' '''||(View) -> Planet Map For Endor
+
||'''[[v_planetmapendor (Database View)|v_planetmapendor]]'''||''' '''||(View) -> Planet Map For Endor
 
|-
 
|-
−
||'''[[v_planetmaplok (Database View)|v_planetmaplok]]''|''' '''||(View) -> Planet Map For Lok
+
||'''[[v_planetmaplok (Database View)|v_planetmaplok]]'''||''' '''||(View) -> Planet Map For Lok
 
|-
 
|-
−
||'''[[v_planetmapnaboo (Database View)|v_planetmapnaboo]]''|''' '''||(View) -> Planet Map For Naboo
+
||'''[[v_planetmapnaboo (Database View)|v_planetmapnaboo]]'''||''' '''||(View) -> Planet Map For Naboo
 
|-
 
|-
−
||'''[[v_planetmaprori (Database View)|v_planetmaprori]]''|''' '''||(View) -> Planet Map For Rori
+
||'''[[v_planetmaprori (Database View)|v_planetmaprori]]'''||''' '''||(View) -> Planet Map For Rori
 
|-
 
|-
−
||'''[[v_planetmaptaanab (Database View)|v_planetmaptaanab]]''|''' '''||(View) -> Planet Map For Taanab
+
||'''[[v_planetmaptaanab (Database View)|v_planetmaptaanab]]'''||''' '''||(View) -> Planet Map For Taanab
 
|-
 
|-
−
||'''[[v_planetmaptalus (Database View)|v_planetmaptalus]]''|''' '''||(View) -> Planet Map For Talus
+
||'''[[v_planetmaptalus (Database View)|v_planetmaptalus]]'''||''' '''||(View) -> Planet Map For Talus
 
|-
 
|-
−
||'''[[v_planetmaptatooine (Database View)|v_planetmaptatooine]]''|''' '''||(View) -> Planet Map For Tatooine
+
||'''[[v_planetmaptatooine (Database View)|v_planetmaptatooine]]'''||''' '''||(View) -> Planet Map For Tatooine
 
|-
 
|-
−
||'''[[v_planetmaptutorial (Database View)|v_planetmaptutorial]]''|''' '''||(View) -> Planet Map For Tutorial
+
||'''[[v_planetmaptutorial (Database View)|v_planetmaptutorial]]'''||''' '''||(View) -> Planet Map For Tutorial
 
|-
 
|-
−
||'''[[v_planetmapyavin4 (Database View)|v_planetmapyavin4]]''|''' '''||(View) -> Planet Map For Yavin IV
+
||'''[[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_types (Database Table)|weapon_types]]'''||''' '''||(Table) -> Weapon Type List
 
|-
 
|-
−
||'''[[weapons (Database Table)|weapons]]''|''' '''||(Table) -> Inventory: Weapons
+
||'''[[weapons (Database Table)|weapons]]'''||''' '''||(Table) -> Inventory: Weapons
 
|-
 
|-
−
||'''[[wearable_types (Database Table)|wearable_types]]''|''' '''||(Table) -> Wearables Type List
+
||'''[[wearable_types (Database Table)|wearable_types]]'''||''' '''||(Table) -> Wearables Type List
 
|-
 
|-
−
||'''[[wearables (Database Table)|wearables]]''|''' '''||(Table) -> Inventory: Wearables
+
||'''[[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
 
|-
 
|-
 
|}
 
|}

Revision as of 14:57, 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
Retrieved from "http://wiki.swganh.org/index.php?title=Portal:SWGANH_Database_Documentation&oldid=9267"