EFTable_TownChef.db

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

Row count: 47

Download CSV Zipped

CREATE TABLE TownChef (
  [ PrimaryKey ] INTEGER NOT NULL,
  [ SecondaryKey ] INTEGER NOT NULL,
  [ Type ] INTEGER NOT NULL,
  [ SortOrder ] INTEGER NOT NULL,
  [ Name ] TEXT NOT NULL,
  [ Comment ] TEXT NOT NULL,
  [ Desc ] TEXT NOT NULL,
  [ Icon ] TEXT NOT NULL,
  [ IconIndex ] INTEGER NOT NULL,
  [ Grade ] INTEGER NOT NULL,
  [ MenuNo ] 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,
  [ CostType ] INTEGER NOT NULL,
  [ Cost ] INTEGER NOT NULL,
  [ NeedActivityPoint ] INTEGER NOT NULL,
  [ TownExp ] INTEGER NOT NULL,
  [ NeedResearchId ] INTEGER NOT NULL,
  [ ResultPropId ] INTEGER NOT NULL,
  [ ResultItemId ] INTEGER NOT NULL,
  [ ResultTriggerId ] INTEGER NOT NULL,
  [ GoodResultPropId ] INTEGER NOT NULL,
  [ GoodResultTriggerId ] INTEGER NOT NULL,
  [ ResultAction1 ] INTEGER NOT NULL,
  [ ResultAction2 ] INTEGER NOT NULL,
  [ ResultAction3 ] INTEGER NOT NULL,
  [ GoodResultAction1 ] INTEGER NOT NULL,
  [ GoodResultAction2 ] INTEGER NOT NULL,
  [ GoodResultAction3 ] INTEGER NOT NULL,
  [ BuffName1 ] TEXT NOT NULL,
  [ BuffName2 ] TEXT NOT NULL,
  [ BuffName3 ] TEXT NOT NULL,
  [ ShowPCRoomSymbol ] INTEGER 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
)