Table mangos.quest_template
Quest System

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
entry mediumint unsigned 8 0
characters.character_queststatus.quest Defined in XML R
characters.character_queststatus_daily.quest Defined in XML R
areatrigger_involvedrelation.quest Defined in XML R
areatrigger_teleport.required_quest_done Defined in XML R
creature_involvedrelation.quest Defined in XML R
creature_questrelation.quest Defined in XML R
game_event_creature_quest.quest Defined in XML R
gameobject_involvedrelation.quest Defined in XML R
gameobject_questrelation.quest Defined in XML R
item_template.startquest Defined in XML R
locales_quest.entry Defined in XML R
npc_spellclick_spells.quest_end Defined in XML R
npc_spellclick_spells.quest_start Defined in XML R
npc_spellclick_spells.quest_start_active Defined in XML R
spell_area.quest_end Defined in XML R
spell_area.quest_start Defined in XML R
Method tinyint unsigned 3 2
ZoneOrSort smallint 5 0
SkillOrClass smallint 5 0
MinLevel tinyint unsigned 3 0
QuestLevel smallint 5 0
Type smallint unsigned 5 0
RequiredRaces smallint unsigned 5 0
RequiredSkillValue smallint unsigned 5 0
RepObjectiveFaction smallint unsigned 5 0
RepObjectiveValue mediumint 7 0
RequiredMinRepFaction smallint unsigned 5 0
RequiredMinRepValue mediumint 7 0
RequiredMaxRepFaction smallint unsigned 5 0
RequiredMaxRepValue mediumint 7 0
SuggestedPlayers tinyint unsigned 3 0
LimitTime int unsigned 10 0
QuestFlags mediumint unsigned 8 0
SpecialFlags tinyint unsigned 3 0
CharTitleId tinyint unsigned 3 0
PlayersSlain tinyint unsigned 3 0
BonusTalents tinyint unsigned 3 0
PrevQuestId mediumint 7 0
NextQuestId mediumint 7 0
ExclusiveGroup mediumint 7 0
NextQuestInChain mediumint unsigned 8 0
RewXPId tinyint unsigned 3 0
SrcItemId mediumint unsigned 8 0
SrcItemCount tinyint unsigned 3 0
SrcSpell mediumint unsigned 8 0
Title text 65535  √  null
Details text 65535  √  null
Objectives text 65535  √  null
OfferRewardText text 65535  √  null
RequestItemsText text 65535  √  null
EndText text 65535  √  null
CompletedText text 65535  √  null
ObjectiveText1 text 65535  √  null
ObjectiveText2 text 65535  √  null
ObjectiveText3 text 65535  √  null
ObjectiveText4 text 65535  √  null
ReqItemId1 mediumint unsigned 8 0
ReqItemId2 mediumint unsigned 8 0
ReqItemId3 mediumint unsigned 8 0
ReqItemId4 mediumint unsigned 8 0
ReqItemId5 mediumint unsigned 8 0
ReqItemId6 mediumint unsigned 8 0
ReqItemCount1 smallint unsigned 5 0
ReqItemCount2 smallint unsigned 5 0
ReqItemCount3 smallint unsigned 5 0
ReqItemCount4 smallint unsigned 5 0
ReqItemCount5 smallint unsigned 5 0
ReqItemCount6 smallint unsigned 5 0
ReqSourceId1 mediumint unsigned 8 0
ReqSourceId2 mediumint unsigned 8 0
ReqSourceId3 mediumint unsigned 8 0
ReqSourceId4 mediumint unsigned 8 0
ReqSourceCount1 smallint unsigned 5 0
ReqSourceCount2 smallint unsigned 5 0
ReqSourceCount3 smallint unsigned 5 0
ReqSourceCount4 smallint unsigned 5 0
ReqCreatureOrGOId1 mediumint 7 0
ReqCreatureOrGOId2 mediumint 7 0
ReqCreatureOrGOId3 mediumint 7 0
ReqCreatureOrGOId4 mediumint 7 0
ReqCreatureOrGOCount1 smallint unsigned 5 0
ReqCreatureOrGOCount2 smallint unsigned 5 0
ReqCreatureOrGOCount3 smallint unsigned 5 0
ReqCreatureOrGOCount4 smallint unsigned 5 0
ReqSpellCast1 mediumint unsigned 8 0
ReqSpellCast2 mediumint unsigned 8 0
ReqSpellCast3 mediumint unsigned 8 0
ReqSpellCast4 mediumint unsigned 8 0
RewChoiceItemId1 mediumint unsigned 8 0
RewChoiceItemId2 mediumint unsigned 8 0
RewChoiceItemId3 mediumint unsigned 8 0
RewChoiceItemId4 mediumint unsigned 8 0
RewChoiceItemId5 mediumint unsigned 8 0
RewChoiceItemId6 mediumint unsigned 8 0
RewChoiceItemCount1 smallint unsigned 5 0
RewChoiceItemCount2 smallint unsigned 5 0
RewChoiceItemCount3 smallint unsigned 5 0
RewChoiceItemCount4 smallint unsigned 5 0
RewChoiceItemCount5 smallint unsigned 5 0
RewChoiceItemCount6 smallint unsigned 5 0
RewItemId1 mediumint unsigned 8 0
RewItemId2 mediumint unsigned 8 0
RewItemId3 mediumint unsigned 8 0
RewItemId4 mediumint unsigned 8 0
RewItemCount1 smallint unsigned 5 0
RewItemCount2 smallint unsigned 5 0
RewItemCount3 smallint unsigned 5 0
RewItemCount4 smallint unsigned 5 0
RewRepFaction1 smallint unsigned 5 0 faction id from Faction.dbc in this case
RewRepFaction2 smallint unsigned 5 0 faction id from Faction.dbc in this case
RewRepFaction3 smallint unsigned 5 0 faction id from Faction.dbc in this case
RewRepFaction4 smallint unsigned 5 0 faction id from Faction.dbc in this case
RewRepFaction5 smallint unsigned 5 0 faction id from Faction.dbc in this case
RewRepValueId1 tinyint 3 0
RewRepValueId2 tinyint 3 0
RewRepValueId3 tinyint 3 0
RewRepValueId4 tinyint 3 0
RewRepValueId5 tinyint 3 0
RewRepValue1 mediumint 7 0
RewRepValue2 mediumint 7 0
RewRepValue3 mediumint 7 0
RewRepValue4 mediumint 7 0
RewRepValue5 mediumint 7 0
RewHonorAddition int unsigned 10 0
RewHonorMultiplier float 12 0
RewOrReqMoney int 10 0
RewMoneyMaxLevel int unsigned 10 0
RewSpell mediumint unsigned 8 0
RewSpellCast mediumint unsigned 8 0
RewMailTemplateId mediumint unsigned 8 0
RewMailDelaySecs int unsigned 10 0
PointMapId smallint unsigned 5 0
PointX float 12 0
PointY float 12 0
PointOpt mediumint unsigned 8 0
DetailsEmote1 smallint unsigned 5 0
DetailsEmote2 smallint unsigned 5 0
DetailsEmote3 smallint unsigned 5 0
DetailsEmote4 smallint unsigned 5 0
DetailsEmoteDelay1 int unsigned 10 0
DetailsEmoteDelay2 int unsigned 10 0
DetailsEmoteDelay3 int unsigned 10 0
DetailsEmoteDelay4 int unsigned 10 0
IncompleteEmote smallint unsigned 5 0
CompleteEmote smallint unsigned 5 0
OfferRewardEmote1 smallint unsigned 5 0
OfferRewardEmote2 smallint unsigned 5 0
OfferRewardEmote3 smallint unsigned 5 0
OfferRewardEmote4 smallint unsigned 5 0
OfferRewardEmoteDelay1 int unsigned 10 0
OfferRewardEmoteDelay2 int unsigned 10 0
OfferRewardEmoteDelay3 int unsigned 10 0
OfferRewardEmoteDelay4 int unsigned 10 0
StartScript mediumint unsigned 8 0
CompleteScript mediumint unsigned 8 0

Table contained 9,063 rows at Fri Feb 11 23:15 MST 2011

Indexes:
Column(s) Type Sort Constraint Name
entry Primary key Asc PRIMARY

Close relationships  within of separation: