Keyboard shortcuts

Press or to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

EFTable_VoyageCrew.db

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

Row count: 156

Download CSV Zipped

CREATE TABLE VoyageCrew (
  [ PrimaryKey ] INTEGER NOT NULL,
  [ SecondaryKey ] INTEGER NOT NULL,
  [ Icon ] TEXT NOT NULL,
  [ IconIndex ] INTEGER NOT NULL,
  [ Name ] TEXT NOT NULL,
  [ CrewGrade ] INTEGER NOT NULL,
  [ ShipTier ] INTEGER NOT NULL,
  [ AvailableShip ] INTEGER NOT NULL,
  [ SupplyForMove ] INTEGER NOT NULL,
  [ Luck ] INTEGER NOT NULL,
  [ CrewComment ] TEXT NOT NULL,
  [ CrewStory ] TEXT NOT NULL,
  [ CommonActionId1 ] INTEGER NOT NULL,
  [ CommonActionLevel1 ] INTEGER NOT NULL,
  [ CommonActionId2 ] INTEGER NOT NULL,
  [ CommonActionLevel2 ] INTEGER NOT NULL,
  [ CommonActionId3 ] INTEGER NOT NULL,
  [ CommonActionLevel3 ] INTEGER NOT NULL,
  [ BoardingSound ] TEXT NOT NULL,
  [ AlternativeRewardMoneyType ] INTEGER NOT NULL,
  [ AlternativeRewardMoneyAmount ] INTEGER NOT NULL,
  [ AlternativeRewardItemId ] INTEGER NOT NULL,
  [ AlternativeRewardItemCount ] INTEGER NOT NULL,
  [ Disposal ] INTEGER NOT NULL,
  [ DisposalRewardMoneyType ] INTEGER NOT NULL,
  [ DisposalRewardMoneyAmount ] INTEGER NOT NULL,
  [ DisposalRewardItemId ] INTEGER NOT NULL,
  [ DisposalRewardItemCount ] INTEGER NOT NULL,
  [ Tolerance_Sea_Weed ] INTEGER NOT NULL,
  [ Tolerance_Dead_Person ] INTEGER NOT NULL,
  [ Tolerance_Siren ] INTEGER NOT NULL,
  [ Tolerance_Storm ] INTEGER NOT NULL,
  [ Tolerance_Cold_Wave ] INTEGER NOT NULL,
  [ Tolerance_Sand_Storm ] INTEGER NOT NULL,
  [ MoveSpeed ] REAL NOT NULL,
  [ ClassifyType ] INTEGER NOT NULL,
  [ ClassifyIndex ] INTEGER NOT NULL,
  [ SourceRow ] INTEGER NOT NULL,
  [ Milestone ] TEXT NOT NULL,
  PRIMARY KEY ([ PrimaryKey ])
)