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

Generated on: 2025-07-23 11:55:57 UTC

Row count: 27753

Download CSV Zipped

CREATE TABLE Prop (
  [ PrimaryKey ] INTEGER NOT NULL,
  [ SecondaryKey ] INTEGER NOT NULL,
  [ Name ] TEXT NOT NULL,
  [ Comment ] TEXT NOT NULL,
  [ NameTag ] INTEGER NOT NULL,
  [ ShowGauge ] INTEGER NOT NULL,
  [ Type ] INTEGER NOT NULL,
  [ TouchType ] INTEGER NOT NULL,
  [ VolumeType ] INTEGER NOT NULL,
  [ PickupType ] INTEGER NOT NULL,
  [ ContentType ] INTEGER NOT NULL,
  [ FilterId ] INTEGER NOT NULL,
  [ ZoneObject ] INTEGER NOT NULL,
  [ ZoneObjectType ] INTEGER NOT NULL,
  [ FallDownType ] INTEGER NOT NULL,
  [ FallDownByWalk ] INTEGER NOT NULL,
  [ FallDownTime ] REAL NOT NULL,
  [ FallDownBuffId ] INTEGER NOT NULL,
  [ FallDownCameraType ] INTEGER NOT NULL,
  [ FallDownTriggerSignal ] INTEGER NOT NULL,
  [ PushOffPC ] INTEGER NOT NULL,
  [ ActorClass ] INTEGER NOT NULL,
  [ ActorClass2 ] INTEGER NOT NULL,
  [ Level ] INTEGER NOT NULL,
  [ BalanceLevel ] INTEGER NOT NULL,
  [ Desc ] TEXT NOT NULL,
  [ Model ] TEXT NOT NULL,
  [ Scale ] INTEGER NOT NULL,
  [ Debris ] INTEGER NOT NULL,
  [ BlockProjectile ] INTEGER NOT NULL,
  [ SightCheck ] INTEGER NOT NULL,
  [ HitType ] INTEGER NOT NULL,
  [ HitAmount ] INTEGER NOT NULL,
  [ HitStep1 ] INTEGER NOT NULL,
  [ HitStep2 ] INTEGER NOT NULL,
  [ HitStep3 ] INTEGER NOT NULL,
  [ TouchAmount ] INTEGER NOT NULL,
  [ TouchOffStayTime ] INTEGER NOT NULL,
  [ RestoreDelay ] INTEGER NOT NULL,
  [ TouchOnTime ] INTEGER NOT NULL,
  [ TouchOffTime ] INTEGER NOT NULL,
  [ OnStayTime ] INTEGER NOT NULL,
  [ JointHP ] INTEGER NOT NULL,
  [ DoorOffEnable ] INTEGER NOT NULL,
  [ InteractionRange ] INTEGER NOT NULL,
  [ PickupDuration ] INTEGER NOT NULL,
  [ PickupDropLifetime ] INTEGER NOT NULL,
  [ PickupUseActionId ] INTEGER NOT NULL,
  [ PickupMoveMotion ] INTEGER NOT NULL,
  [ PickupHitCount ] INTEGER NOT NULL,
  [ PickupDropOnDie ] INTEGER NOT NULL,
  [ PickupPropChangeEnabled ] INTEGER NOT NULL,
  [ CommonActionIndex ] INTEGER NOT NULL,
  [ CommonActionTime ] INTEGER NOT NULL,
  [ CommonActionDesc ] TEXT NOT NULL,
  [ Blocking ] INTEGER NOT NULL,
  [ StayBlockOnOff ] INTEGER NOT NULL,
  [ ClickIcon ] TEXT NOT NULL,
  [ ConditionId ] INTEGER NOT NULL,
  [ ExecuteActionId ] INTEGER NOT NULL,
  [ StateOnActionId ] INTEGER NOT NULL,
  [ StateOn2ActionId ] INTEGER NOT NULL,
  [ StateOn3ActionId ] INTEGER NOT NULL,
  [ StateOn2ActionIdExact ] INTEGER NOT NULL,
  [ StateOffActionId ] INTEGER NOT NULL,
  [ UsageActionId ] INTEGER NOT NULL,
  [ SpawnActionId ] INTEGER NOT NULL,
  [ AssembleWaitTime ] INTEGER NOT NULL,
  [ AssembleOnTrasit ] INTEGER NOT NULL,
  [ AssembleGoOffString ] TEXT NOT NULL,
  [ AssembleOffString ] TEXT NOT NULL,
  [ QuestId ] INTEGER NOT NULL,
  [ DefaultAction ] INTEGER NOT NULL,
  [ DefaultSkillId ] INTEGER NOT NULL,
  [ MoveSkillId ] INTEGER NOT NULL,
  [ MoveSkillEnable ] INTEGER NOT NULL,
  [ GetupSkillEnable ] INTEGER NOT NULL,
  [ SkillId0 ] INTEGER NOT NULL,
  [ SkillCount0 ] INTEGER NOT NULL,
  [ SkillId1 ] INTEGER NOT NULL,
  [ SkillCount1 ] INTEGER NOT NULL,
  [ SkillId2 ] INTEGER NOT NULL,
  [ SkillCount2 ] INTEGER NOT NULL,
  [ SkillId3 ] INTEGER NOT NULL,
  [ SkillCount3 ] INTEGER NOT NULL,
  [ ChainSkillId ] INTEGER NOT NULL,
  [ GaugeRechargable ] INTEGER NOT NULL,
  [ GaugeStart ] INTEGER NOT NULL,
  [ GaugeMax ] INTEGER NOT NULL,
  [ CommonActionId0 ] INTEGER NOT NULL,
  [ CommonActionId1 ] INTEGER NOT NULL,
  [ CommonActionId2 ] INTEGER NOT NULL,
  [ CommonActionId3 ] INTEGER NOT NULL,
  [ MapIcon ] TEXT NOT NULL,
  [ MapSymbolIndex ] INTEGER NOT NULL,
  [ MapSymbolGadgetIndex ] INTEGER NOT NULL,
  [ InteractionKeyIcon ] TEXT NOT NULL,
  [ InteractionKeyString ] TEXT NOT NULL,
  [ SquareHoleContinent ] INTEGER NOT NULL,
  [ SquareHoleMapIndex ] INTEGER NOT NULL,
  [ SquareHoleLevel ] INTEGER NOT NULL,
  [ SquareHoleUseLevel ] INTEGER NOT NULL,
  [ SquareHoleCostMoney ] INTEGER NOT NULL,
  [ SquareHoleCostItemIndex ] INTEGER NOT NULL,
  [ SquareHole_UI_Xlocation ] INTEGER NOT NULL,
  [ SquareHole_UI_Ylocation ] INTEGER NOT NULL,
  [ SpawnActionTime ] INTEGER NOT NULL,
  [ DespawnActionTime ] INTEGER NOT NULL,
  [ SpawnAnnounceMsg ] TEXT NOT NULL,
  [ CommonActionDesc_Variation ] INTEGER NOT NULL,
  [ SortOrder ] INTEGER NOT NULL,
  [ InteractionMatineeShow ] INTEGER NOT NULL,
  [ OceanAreaLevel ] INTEGER NOT NULL,
  [ OceanAreaType ] INTEGER NOT NULL,
  [ OceanAreaFloatingMatterLevel ] INTEGER NOT NULL,
  [ VoyageLuck ] INTEGER NOT NULL,
  [ FloatingMotion ] INTEGER NOT NULL,
  [ OpenDialog ] INTEGER NOT NULL,
  [ DialogTitle ] TEXT NOT NULL,
  [ DialogDesc ] TEXT NOT NULL,
  [ DialogValue ] INTEGER NOT NULL,
  [ HideInteractionMark ] INTEGER NOT NULL,
  [ StatReplaceId ] INTEGER NOT NULL,
  [ StatReplaceHard ] INTEGER NOT NULL,
  [ StatReplaceHellChaos ] INTEGER NOT NULL,
  [ StatReplaceChallenge ] INTEGER NOT NULL,
  [ StatReplaceSpecial ] INTEGER NOT NULL,
  [ StatReplaceExtreme ] INTEGER NOT NULL,
  [ LifeGatherIndex ] INTEGER NOT NULL,
  [ StandOnLand ] INTEGER NOT NULL,
  [ VolumeExtentX ] INTEGER NOT NULL,
  [ VolumeExtentY ] INTEGER NOT NULL,
  [ VolumeExtentZ ] INTEGER NOT NULL,
  [ PostCheckCondition ] INTEGER NOT NULL,
  [ LifePropTier ] INTEGER NOT NULL,
  [ ClassifyType ] INTEGER NOT NULL,
  [ ClassifyIndex ] INTEGER NOT NULL,
  [ ShowAcquisitionRoute ] INTEGER NOT NULL,
  [ StationVolumeCountString ] TEXT NOT NULL,
  [ ContentsRequirementId ] INTEGER NOT NULL,
  [ HitMeshType ] INTEGER NOT NULL,
  [ VolumeShapeType ] INTEGER NOT NULL,
  [ StrongholdOccupationTime ] INTEGER NOT NULL,
  [ RedStateOffActionId ] INTEGER NOT NULL,
  [ BlueStateOffActionId ] INTEGER NOT NULL,
  [ PickupDropOnAbnormalEvent ] INTEGER NOT NULL,
  [ SummonCount ] INTEGER NOT NULL,
  [ AchievementVolumePropGroupId ] INTEGER NOT NULL,
  [ RandomResultMin ] INTEGER NOT NULL,
  [ RandomResultMax ] INTEGER NOT NULL,
  [ OnlyKeyInteraction ] INTEGER NOT NULL,
  [ SquareHoleExpedition ] INTEGER NOT NULL,
  [ SquareHoleConditionZondId ] INTEGER NOT NULL,
  [ SquareHoleConditionQuestId ] INTEGER NOT NULL,
  [ SquareHoleConditionQuestStageIndex ] INTEGER NOT NULL,
  [ ObstacleContext ] INTEGER NOT NULL,
  [ InstrumentId ] INTEGER NOT NULL,
  [ InstrumentIndex ] INTEGER NOT NULL,
  [ UseSmallObstacleOffset ] INTEGER NOT NULL,
  [ SourceRow ] INTEGER NOT NULL,
  [ Milestone ] TEXT NOT NULL,
  PRIMARY KEY ([ PrimaryKey ])
)