EFTable_ItemAssembly.db

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

Row count: 8082

Download CSV Zipped

CREATE TABLE ItemAssembly (
  [ PrimaryKey ] INTEGER NOT NULL,
  [ SecondaryKey ] INTEGER NOT NULL,
  [ Comment ] TEXT NOT NULL,
  [ Type ] INTEGER NOT NULL,
  [ Grade ] INTEGER NOT NULL,
  [ ItemId ] INTEGER NOT NULL,
  [ MaxCount ] INTEGER NOT NULL,
  [ StackQty ] INTEGER NOT NULL,
  [ Level ] INTEGER NOT NULL,
  [ CostType ] INTEGER NOT NULL,
  [ Cost ] INTEGER NOT NULL,
  [ CostMultiplier ] INTEGER NOT NULL,
  [ Time ] INTEGER NOT NULL,
  [ TimeMultiplier ] INTEGER NOT NULL,
  [ TypeName ] TEXT NOT NULL,
  [ FinishCost ] INTEGER NOT NULL,
  [ ReceiveCost ] INTEGER NOT NULL,
  [ RootItemId ] INTEGER NOT NULL,
  [ MaterialId_00 ] INTEGER NOT NULL,
  [ MaterialCount_00 ] INTEGER NOT NULL,
  [ MaterialId_01 ] INTEGER NOT NULL,
  [ MaterialCount_01 ] INTEGER NOT NULL,
  [ MaterialId_02 ] INTEGER NOT NULL,
  [ MaterialCount_02 ] INTEGER NOT NULL,
  [ MaterialId_03 ] INTEGER NOT NULL,
  [ MaterialCount_03 ] INTEGER NOT NULL,
  [ MaterialId_04 ] INTEGER NOT NULL,
  [ MaterialCount_04 ] INTEGER NOT NULL,
  [ MaterialId_05 ] INTEGER NOT NULL,
  [ MaterialCount_05 ] INTEGER NOT NULL,
  [ MaterialId_06 ] INTEGER NOT NULL,
  [ MaterialCount_06 ] INTEGER NOT NULL,
  [ MaterialId_07 ] INTEGER NOT NULL,
  [ MaterialCount_07 ] INTEGER NOT NULL,
  [ MaterialId_08 ] INTEGER NOT NULL,
  [ MaterialCount_08 ] INTEGER NOT NULL,
  [ MaterialId_09 ] INTEGER NOT NULL,
  [ MaterialCount_09 ] INTEGER NOT NULL,
  [ NormalId ] INTEGER NOT NULL,
  [ NormalDeviation ] INTEGER NOT NULL,
  [ NormalDistribution ] INTEGER NOT NULL,
  [ GoodRatio ] INTEGER NOT NULL,
  [ GoodId ] INTEGER NOT NULL,
  [ GoodDeviation ] INTEGER NOT NULL,
  [ GoodDistribution ] INTEGER NOT NULL,
  [ GoodMinExtraCount ] INTEGER NOT NULL,
  [ GoodMaxExtraCount ] INTEGER NOT NULL,
  [ ByproductId ] INTEGER NOT NULL,
  [ AchievementId ] INTEGER NOT NULL,
  [ AchievementLevel ] INTEGER NOT NULL,
  [ AchievementIndex ] INTEGER NOT NULL,
  [ ItemSetName ] TEXT NOT NULL,
  [ ClassifyType ] INTEGER NOT NULL,
  [ ClassifyIndex ] INTEGER NOT NULL,
  [ CashCost ] INTEGER NOT NULL,
  [ CashCostMultiplier ] INTEGER NOT NULL,
  [ ClassifyType2 ] INTEGER NOT NULL,
  [ ClassifyIndex2 ] INTEGER NOT NULL,
  [ QuestId ] INTEGER NOT NULL,
  [ WelcomeBoostId ] INTEGER NOT NULL,
  [ LimitIndex ] INTEGER NOT NULL,
  [ IgnoreUnion ] INTEGER NOT NULL,
  [ SourceRow ] INTEGER NOT NULL,
  [ Milestone ] TEXT NOT NULL,
  PRIMARY KEY ([ PrimaryKey ])
)