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_Trophy.db

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

Row count: 181

Download CSV Zipped

CREATE TABLE Trophy (
  [ PrimaryKey ] INTEGER NOT NULL,
  [ SecondaryKey ] INTEGER NOT NULL,
  [ Name ] TEXT NOT NULL,
  [ Order ] INTEGER NOT NULL,
  [ Desc ] TEXT NOT NULL,
  [ Icon ] TEXT NOT NULL,
  [ IconIndex ] INTEGER NOT NULL,
  [ BigIcon ] TEXT NOT NULL,
  [ BigIconIndex ] INTEGER NOT NULL,
  [ BigGrayIcon ] TEXT NOT NULL,
  [ BigGrayIconIndex ] INTEGER NOT NULL,
  [ TrophyPropId ] INTEGER NOT NULL,
  [ PreviewCam ] INTEGER NOT NULL,
  [ Category ] INTEGER NOT NULL,
  [ Type ] INTEGER NOT NULL,
  [ ConditionDesc ] TEXT NOT NULL,
  [ ConditionType ] INTEGER NOT NULL,
  [ ObjCount ] INTEGER NOT NULL,
  [ ObjLevel ] INTEGER NOT NULL,
  [ ObjAchievementId ] INTEGER NOT NULL,
  [ ObjAchievementlv ] INTEGER NOT NULL,
  [ ObjAchievementIndex ] INTEGER NOT NULL,
  [ ObjQuestId ] INTEGER NOT NULL,
  [ ObjQuestId2 ] INTEGER NOT NULL,
  [ ObjQuestId3 ] INTEGER NOT NULL,
  [ ObjQuestId4 ] INTEGER NOT NULL,
  [ ObjRaidId ] INTEGER NOT NULL,
  [ ObjPlayerClass ] INTEGER NOT NULL,
  [ ObjZoneId ] INTEGER NOT NULL,
  [ ObjZoneLevel ] INTEGER NOT NULL,
  [ ObjStageNo ] INTEGER NOT NULL,
  [ ObjMemoryMarbleMin ] INTEGER NOT NULL,
  [ ObjMemoryMarbleMax ] INTEGER NOT NULL,
  [ ObjCumulativePointType ] INTEGER NOT NULL,
  [ QuestNoteId ] INTEGER NOT NULL,
  [ PlayType ] INTEGER NOT NULL,
  [ PlayOffStayTime ] REAL NOT NULL,
  [ PlayOnStayTime ] REAL NOT NULL,
  [ Change_propid_1 ] INTEGER NOT NULL,
  [ Change_propid_2 ] INTEGER NOT NULL,
  [ Change_propid_3 ] INTEGER NOT NULL,
  [ Change_propid_4 ] INTEGER NOT NULL,
  [ Change_propid_5 ] INTEGER NOT NULL,
  [ Hidden ] INTEGER NOT NULL,
  [ NPCId ] INTEGER NOT NULL,
  [ NPCIdlename ] TEXT NOT NULL,
  [ NPCFx ] TEXT NOT NULL,
  [ NPCScale ] INTEGER NOT NULL,
  [ TrophyMask_Texture ] TEXT NOT NULL,
  [ ClassifyType ] INTEGER NOT NULL,
  [ ClassifyIndex ] INTEGER NOT NULL,
  [ ClassifyType2 ] INTEGER NOT NULL,
  [ ClassifyIndex2 ] INTEGER NOT NULL,
  [ SourceRow ] INTEGER NOT NULL,
  [ Milestone ] TEXT NOT NULL,
  PRIMARY KEY ([ PrimaryKey ])
)