EFTable_TownDispatchMission.db

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

Row count: 1365

Download CSV Zipped

CREATE TABLE TownDispatchMission (
  [ PrimaryKey ] INTEGER NOT NULL,
  [ SecondaryKey ] INTEGER NOT NULL,
  [ Name ] TEXT NOT NULL,
  [ SubName ] TEXT NOT NULL,
  [ Desc ] TEXT NOT NULL,
  [ SubDesc ] TEXT NOT NULL,
  [ Hide ] INTEGER NOT NULL,
  [ Grade ] INTEGER NOT NULL,
  [ MissionTimeSec ] INTEGER NOT NULL,
  [ OceanArea ] INTEGER NOT NULL,
  [ Type ] INTEGER NOT NULL,
  [ Hardship_Main ] INTEGER NOT NULL,
  [ Hardship_Main_Count ] INTEGER NOT NULL,
  [ Hardship_Sub ] INTEGER NOT NULL,
  [ Hardship_Sub_Count ] INTEGER NOT NULL,
  [ RequireResearchId ] INTEGER NOT NULL,
  [ Open_Building_Grade ] INTEGER NOT NULL,
  [ AchievementId ] INTEGER NOT NULL,
  [ AchievementLevel ] INTEGER NOT NULL,
  [ AchievementIndex ] INTEGER NOT NULL,
  [ WeightGroup ] INTEGER NOT NULL,
  [ ContentsTimeId ] INTEGER NOT NULL,
  [ SpecialMissionType ] INTEGER NOT NULL,
  [ SpecialMissionValue ] INTEGER NOT NULL,
  [ SpecialMissionValue2 ] INTEGER NOT NULL,
  [ ContentsRequirementId ] INTEGER NOT NULL,
  [ ContentsType ] INTEGER NOT NULL,
  [ RecommendLevel ] INTEGER NOT NULL,
  [ CostActivityPoint ] INTEGER NOT NULL,
  [ CostShipHP ] INTEGER NOT NULL,
  [ CostMoneyType ] INTEGER NOT NULL,
  [ CostMoneyCount ] INTEGER NOT NULL,
  [ ShipmentId ] INTEGER NOT NULL,
  [ TownExp ] INTEGER NOT NULL,
  [ DropReward ] INTEGER NOT NULL,
  [ DropAddSS ] INTEGER NOT NULL,
  [ DropAddS ] INTEGER NOT NULL,
  [ Drop1 ] INTEGER NOT NULL,
  [ Drop1_Weight ] INTEGER NOT NULL,
  [ Drop2 ] INTEGER NOT NULL,
  [ Drop2_Weight ] INTEGER NOT NULL,
  [ DropLucky1 ] INTEGER NOT NULL,
  [ DropLucky1_Weight ] INTEGER NOT NULL,
  [ DropLucky2 ] INTEGER NOT NULL,
  [ DropLucky2_Weight ] INTEGER NOT NULL,
  [ DropBm ] INTEGER NOT NULL,
  [ ContentsRewardDisplayId ] INTEGER NOT NULL,
  [ ListInfo_ItemId ] INTEGER NOT NULL,
  [ ListInfo_ItemCountMin ] INTEGER NOT NULL,
  [ ListInfo_ItemCountMax ] INTEGER NOT NULL,
  [ HerbalismExp ] INTEGER NOT NULL,
  [ LumberingExp ] INTEGER NOT NULL,
  [ MiningExp ] INTEGER NOT NULL,
  [ HuntingExp ] INTEGER NOT NULL,
  [ FishingExp ] INTEGER NOT NULL,
  [ ArchaeologyExp ] 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 ])
)