EFTable_TownDispatchMission.db
Generated on: 2025-07-23 11:56:11 UTC
Row count: 1378
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 ])
)