EFTable_TownResearch.db

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

Row count: 546

Download CSV Zipped

CREATE TABLE TownResearch (
  [ PrimaryKey ] INTEGER NOT NULL,
  [ SecondaryKey ] INTEGER NOT NULL,
  [ Name ] TEXT NOT NULL,
  [ Comment ] TEXT NOT NULL,
  [ Category ] INTEGER NOT NULL,
  [ Desc ] TEXT NOT NULL,
  [ Seconds ] INTEGER NOT NULL,
  [ NeedActivityPoint ] INTEGER NOT NULL,
  [ CostMoneyType ] INTEGER NOT NULL,
  [ CostMoneyCount ] INTEGER NOT NULL,
  [ CostItemId1 ] INTEGER NOT NULL,
  [ CostItemCount1 ] INTEGER NOT NULL,
  [ CostItemId2 ] INTEGER NOT NULL,
  [ CostItemCount2 ] INTEGER NOT NULL,
  [ CostItemId3 ] INTEGER NOT NULL,
  [ CostItemCount3 ] INTEGER NOT NULL,
  [ CostItemId4 ] INTEGER NOT NULL,
  [ CostItemCount4 ] INTEGER NOT NULL,
  [ CostItemId5 ] INTEGER NOT NULL,
  [ CostItemCount5 ] INTEGER NOT NULL,
  [ OutputTownExp ] INTEGER NOT NULL,
  [ Effect ] INTEGER NOT NULL,
  [ RequiredType1 ] INTEGER NOT NULL,
  [ RequiredValue1 ] INTEGER NOT NULL,
  [ RequiredSecondValue1 ] INTEGER NOT NULL,
  [ RequiredCount1 ] INTEGER NOT NULL,
  [ RequiredType2 ] INTEGER NOT NULL,
  [ RequiredValue2 ] INTEGER NOT NULL,
  [ RequiredSecondValue2 ] INTEGER NOT NULL,
  [ RequiredCount2 ] INTEGER NOT NULL,
  [ RequiredType3 ] INTEGER NOT NULL,
  [ RequiredValue3 ] INTEGER NOT NULL,
  [ RequiredSecondValue3 ] INTEGER NOT NULL,
  [ RequiredCount3 ] INTEGER NOT NULL,
  [ Open_Building_Grade ] INTEGER NOT NULL,
  [ Show ] INTEGER NOT NULL,
  [ AlternativeRewardMoneyType ] INTEGER NOT NULL,
  [ AlternativeRewardItemId ] INTEGER NOT NULL,
  [ AlternativeRewardCount ] 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,
  PRIMARY KEY ([ PrimaryKey ])
)