EFTable_QuestReward.db

Generated on: 2025-07-23 11:56:29 UTC

Row count: 3176

Download CSV Zipped

CREATE TABLE QuestReward (
  [ PrimaryKey ] INTEGER NOT NULL,
  [ SecondaryKey ] INTEGER NOT NULL,
  [ RewardMoneyType ] INTEGER NOT NULL,
  [ RewardMoneyValue ] INTEGER NOT NULL,
  [ Exp ] INTEGER NOT NULL,
  [ DefaultItem1 ] INTEGER NOT NULL,
  [ DefaultItem1Amount ] INTEGER NOT NULL,
  [ DefaultItem2 ] INTEGER NOT NULL,
  [ DefaultItem2Amount ] INTEGER NOT NULL,
  [ DefaultItem3 ] INTEGER NOT NULL,
  [ DefaultItem3Amount ] INTEGER NOT NULL,
  [ DefaultItem4 ] INTEGER NOT NULL,
  [ DefaultItem4Amount ] INTEGER NOT NULL,
  [ ChoiceItem1 ] INTEGER NOT NULL,
  [ ChoiceItem1Amount ] INTEGER NOT NULL,
  [ ChoiceItem2 ] INTEGER NOT NULL,
  [ ChoiceItem2Amount ] INTEGER NOT NULL,
  [ ChoiceItem3 ] INTEGER NOT NULL,
  [ ChoiceItem3Amount ] INTEGER NOT NULL,
  [ ChoiceItem4 ] INTEGER NOT NULL,
  [ ChoiceItem4Amount ] INTEGER NOT NULL,
  [ ChoiceItem5 ] INTEGER NOT NULL,
  [ ChoiceItem5Amount ] INTEGER NOT NULL,
  [ ChoiceItem6 ] INTEGER NOT NULL,
  [ ChoiceItem6Amount ] INTEGER NOT NULL,
  [ GroupItem1 ] INTEGER NOT NULL,
  [ GroupItem1Amount ] INTEGER NOT NULL,
  [ RepeatItem ] INTEGER NOT NULL,
  [ RepeatItemAmount ] INTEGER NOT NULL,
  [ ExpeditionExp ] INTEGER NOT NULL,
  [ SpecialRewardType ] INTEGER NOT NULL,
  [ SpecialRewardIndex ] INTEGER NOT NULL,
  [ SpecialRewardValue ] INTEGER NOT NULL,
  [ SpecialRewardIcon ] TEXT NOT NULL,
  [ SpecialRewardIconIndex ] INTEGER NOT NULL,
  [ SpecialRewardName ] TEXT NOT NULL,
  [ SpecialRewardDesc ] TEXT NOT NULL,
  [ AdditionalMoneyType ] INTEGER NOT NULL,
  [ AdditionalMoneyCount ] INTEGER NOT NULL,
  [ CharacterTendencyIntellect ] INTEGER NOT NULL,
  [ CharacterTendencyCourage ] INTEGER NOT NULL,
  [ CharacterTendencyCharm ] INTEGER NOT NULL,
  [ CharacterTendencyKindness ] INTEGER NOT NULL,
  [ TownExp ] INTEGER NOT NULL,
  [ TownZoneId ] INTEGER NOT NULL,
  [ RewardQuestPointId ] INTEGER NOT NULL,
  [ RewardQuestPoint ] INTEGER NOT NULL,
  [ RewardFriendshipNpcId ] INTEGER NOT NULL,
  [ RewardFriendshipNpcPoint ] INTEGER NOT NULL,
  [ RewardItemDropIndex ] INTEGER NOT NULL,
  [ RewardItemDropIndex2 ] INTEGER NOT NULL,
  [ RewardItemDropIndex3 ] INTEGER NOT NULL,
  [ RewardItemDropIndex4 ] INTEGER NOT NULL,
  [ ClassItemWarrior ] INTEGER NOT NULL,
  [ ClassItemWarriorFemale ] INTEGER NOT NULL,
  [ ClassItemMagician ] INTEGER NOT NULL,
  [ ClassItemFighter ] INTEGER NOT NULL,
  [ ClassItemFighterMale ] INTEGER NOT NULL,
  [ ClassItemDelain ] INTEGER NOT NULL,
  [ ClassItemHunter ] INTEGER NOT NULL,
  [ ClassItemHunterFemale ] INTEGER NOT NULL,
  [ ClassItemSpecialist ] INTEGER NOT NULL,
  [ ClassItemBerserker ] INTEGER NOT NULL,
  [ ClassItemBerserkerFemale ] INTEGER NOT NULL,
  [ ClassItemDestroyer ] INTEGER NOT NULL,
  [ ClassItemWarlord ] INTEGER NOT NULL,
  [ ClassItemHolyKnight ] INTEGER NOT NULL,
  [ ClassItemHolyKnightFemale ] INTEGER NOT NULL,
  [ ClassItemArcana ] INTEGER NOT NULL,
  [ ClassItemSummoner ] INTEGER NOT NULL,
  [ ClassItemBard ] INTEGER NOT NULL,
  [ ClassItemBattle_master ] INTEGER NOT NULL,
  [ ClassItemBattle_masterMale ] INTEGER NOT NULL,
  [ ClassItemInfighter ] INTEGER NOT NULL,
  [ ClassItemInfighterMale ] INTEGER NOT NULL,
  [ ClassItemForce_master ] INTEGER NOT NULL,
  [ ClassItemBlade ] INTEGER NOT NULL,
  [ ClassItemDemonic ] INTEGER NOT NULL,
  [ ClassItemReaper ] INTEGER NOT NULL,
  [ ClassItemSoulEater ] INTEGER NOT NULL,
  [ ClassItemHawk_eye ] INTEGER NOT NULL,
  [ ClassItemDevil_hunter ] INTEGER NOT NULL,
  [ ClassItemDevil_hunterFemale ] INTEGER NOT NULL,
  [ ClassItemBlaster ] INTEGER NOT NULL,
  [ ClassItemYinyangshi ] INTEGER NOT NULL,
  [ ClassItemWeatherArtist ] INTEGER NOT NULL,
  [ ClassItemAlchemist ] INTEGER NOT NULL,
  [ ClassItemScouter ] INTEGER NOT NULL,
  [ ClassItemLance_master ] INTEGER NOT NULL,
  [ ClassItemElemental_master ] INTEGER NOT NULL,
  [ PVPPoint ] INTEGER NOT NULL,
  [ ClassifyType ] INTEGER NOT NULL,
  [ ClassifyIndex ] INTEGER NOT NULL,
  [ ClassifyType2 ] INTEGER NOT NULL,
  [ ClassifyIndex2 ] INTEGER NOT NULL,
  [ PCRoomItemId ] INTEGER NOT NULL,
  [ PCRoomItemCount ] INTEGER NOT NULL,
  [ PCRoomDropIndex ] INTEGER NOT NULL,
  [ GuildFirstDropIndex1 ] INTEGER NOT NULL,
  [ GuildFirstDropIndex2 ] INTEGER NOT NULL,
  [ GuildWeekObjectiveId ] INTEGER NOT NULL,
  [ GuildWeekObjectivePoint ] INTEGER NOT NULL,
  [ GuildWeekContribution ] INTEGER NOT NULL,
  [ HerbalismExp ] INTEGER NOT NULL,
  [ LumberingExp ] INTEGER NOT NULL,
  [ MiningExp ] INTEGER NOT NULL,
  [ HuntingExp ] INTEGER NOT NULL,
  [ FishingExp ] INTEGER NOT NULL,
  [ ArchaeologyExp ] INTEGER NOT NULL,
  [ RealmExp ] INTEGER NOT NULL,
  [ PeriodRewardId ] INTEGER NOT NULL,
  [ SourceRow ] INTEGER NOT NULL,
  [ Milestone ] TEXT NOT NULL
)