Keyboard shortcuts

Press or to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

EFTable_QuestItem.db

Generated on: 2025-07-23 11:55:59 UTC

Row count: 2861

Download CSV Zipped

CREATE TABLE QuestItem (
  [ PrimaryKey ] INTEGER NOT NULL,
  [ SecondaryKey ] INTEGER NOT NULL,
  [ ClassifyType ] INTEGER NOT NULL,
  [ ClassifyIndex ] INTEGER NOT NULL,
  [ Name ] TEXT NOT NULL,
  [ Comment ] TEXT NOT NULL,
  [ Icon ] TEXT NOT NULL,
  [ IconIndex ] INTEGER NOT NULL,
  [ IconSound ] TEXT NOT NULL,
  [ Desc ] TEXT NOT NULL,
  [ Category ] INTEGER NOT NULL,
  [ Usable ] INTEGER NOT NULL,
  [ Stack ] INTEGER NOT NULL,
  [ UseTarget ] INTEGER NOT NULL,
  [ UseTargetId ] INTEGER NOT NULL,
  [ UseTargetMinRange ] INTEGER NOT NULL,
  [ UseTargetRange ] INTEGER NOT NULL,
  [ UseCommonActionIndex ] INTEGER NOT NULL,
  [ CommonActionDesc ] TEXT NOT NULL,
  [ UseConditionId ] INTEGER NOT NULL,
  [ UseActionId ] INTEGER NOT NULL,
  [ UseSkillEffect ] INTEGER NOT NULL,
  [ UseMusicId ] INTEGER NOT NULL,
  [ Projection ] INTEGER NOT NULL,
  [ ProjectionArea ] INTEGER NOT NULL,
  [ ProjectionSkillEffectId ] INTEGER NOT NULL,
  [ SkillMaxRangeProc ] INTEGER NOT NULL,
  [ View ] INTEGER NOT NULL,
  [ UseEffect ] TEXT NOT NULL,
  [ UseSound ] TEXT NOT NULL,
  [ ApplyItemEffect ] TEXT NOT NULL,
  [ ApplyItemSound ] TEXT NOT NULL,
  [ QuestNoteID ] INTEGER NOT NULL,
  [ PerfectZoneEnabled ] INTEGER NOT NULL,
  [ SourceRow ] INTEGER NOT NULL,
  [ Milestone ] TEXT NOT NULL,
  PRIMARY KEY ([ PrimaryKey ])
)