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_NpcFriendship.db

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

Row count: 101

Download CSV Zipped

CREATE TABLE NpcFriendship (
  [ PrimaryKey ] INTEGER NOT NULL,
  [ SecondaryKey ] INTEGER NOT NULL,
  [ Name ] TEXT NOT NULL,
  [ NpcName ] TEXT NOT NULL,
  [ Thumbnail_Grade0 ] TEXT NOT NULL,
  [ ThumbnailIndex_Grade0 ] INTEGER NOT NULL,
  [ Thumbnail_Grade1 ] TEXT NOT NULL,
  [ ThumbnailIndex_Grade1 ] INTEGER NOT NULL,
  [ Thumbnail_Grade3 ] TEXT NOT NULL,
  [ ThumbnailIndex_Grade3 ] INTEGER NOT NULL,
  [ Thumbnail_Grade6 ] TEXT NOT NULL,
  [ ThumbnailIndex_Grade6 ] INTEGER NOT NULL,
  [ Thumbnail_Grade9 ] TEXT NOT NULL,
  [ ThumbnailIndex_Grade9 ] INTEGER NOT NULL,
  [ ContinentType ] INTEGER NOT NULL,
  [ VoyageContientType ] INTEGER NOT NULL,
  [ Zone ] INTEGER NOT NULL,
  [ Area ] TEXT NOT NULL,
  [ Month ] INTEGER NOT NULL,
  [ Day ] INTEGER NOT NULL,
  [ Story ] TEXT NOT NULL,
  [ Tier ] INTEGER NOT NULL,
  [ MaxFatiguePoint ] INTEGER NOT NULL,
  [ Gender ] INTEGER NOT NULL,
  [ Tribe ] INTEGER NOT NULL,
  [ Age ] INTEGER NOT NULL,
  [ BodyType ] INTEGER NOT NULL,
  [ Tendency1 ] INTEGER NOT NULL,
  [ Tendency2 ] INTEGER NOT NULL,
  [ Tendency3 ] INTEGER NOT NULL,
  [ ActiveConditionQuest ] INTEGER NOT NULL,
  [ ActiveConditionQuestInfo ] TEXT NOT NULL,
  [ InteractionConditionIntellect ] INTEGER NOT NULL,
  [ InteractionConditionCourage ] INTEGER NOT NULL,
  [ InteractionConditionCharm ] INTEGER NOT NULL,
  [ InteractionConditionKindness ] INTEGER NOT NULL,
  [ StartSubGrade ] INTEGER NOT NULL,
  [ EventNPC ] INTEGER NOT NULL,
  [ UIShow ] INTEGER NOT NULL,
  [ ClassifyType ] INTEGER NOT NULL,
  [ ClassifyIndex ] INTEGER NOT NULL,
  [ AffectionateFriend ] INTEGER NOT NULL,
  [ LongingMessage ] TEXT NOT NULL,
  [ LongingRewardDropBase ] INTEGER NOT NULL,
  [ AffectionTalkRewardDisplayID ] INTEGER NOT NULL,
  [ MemorialRewardDisplayID ] INTEGER NOT NULL,
  [ NpcGradeForTown ] INTEGER NOT NULL,
  [ TownPlacementEnabled ] INTEGER NOT NULL,
  [ TownPlacementCost ] INTEGER NOT NULL,
  [ Tendency4 ] INTEGER NOT NULL,
  [ Tendency5 ] INTEGER NOT NULL,
  [ TownModelSize ] INTEGER NOT NULL,
  [ SortOrder ] INTEGER NOT NULL,
  [ NonSpoil ] INTEGER NOT NULL,
  [ FoundationBoost ] INTEGER NOT NULL,
  [ AdditionalStatusQuestId ] INTEGER NOT NULL,
  [ AdditionalStatusQuestStageIndex ] INTEGER NOT NULL,
  [ AdditionalStatusType ] INTEGER NOT NULL,
  [ AdditionalStatusImage ] TEXT NOT NULL,
  [ AdditionalStatusImageIndex ] INTEGER NOT NULL,
  [ AdditionalStatusStory ] TEXT NOT NULL,
  [ AdditionalStatusConfirmStory ] TEXT NOT NULL,
  [ AdvBookDisplayNpcId ] INTEGER NOT NULL,
  [ SourceRow ] INTEGER NOT NULL,
  [ Milestone ] TEXT NOT NULL,
  PRIMARY KEY ([ PrimaryKey ])
)