EFTable_Item.db
Generated on: 2025-07-23 11:55:31 UTC
Row count: 113458
CREATE TABLE Item (
[ PrimaryKey ] INTEGER NOT NULL,
[ SecondaryKey ] INTEGER NOT NULL,
[ Name ] TEXT NOT NULL,
[ Comment ] TEXT NOT NULL,
[ Icon ] TEXT NOT NULL,
[ IconIndex ] INTEGER NOT NULL,
[ IconSound ] TEXT NOT NULL,
[ Desc ] TEXT NOT NULL,
[ DropModel ] TEXT NOT NULL,
[ Model ] TEXT NOT NULL,
[ Type ] INTEGER NOT NULL,
[ Category ] INTEGER NOT NULL,
[ Grade ] INTEGER NOT NULL,
[ Trash ] INTEGER NOT NULL,
[ Level ] INTEGER NOT NULL,
[ BalanceLevel ] INTEGER NOT NULL,
[ Tier ] INTEGER NOT NULL,
[ Stack ] INTEGER NOT NULL,
[ BattleStack ] INTEGER NOT NULL,
[ Explosion ] INTEGER NOT NULL,
[ NoSell ] INTEGER NOT NULL,
[ NoStash ] INTEGER NOT NULL,
[ NoDestroy ] INTEGER NOT NULL,
[ PCRoomOnly ] INTEGER NOT NULL,
[ MedalQuestFailItem ] INTEGER NOT NULL,
[ EquipDenominator ] INTEGER NOT NULL,
[ EquipDenominatorType ] INTEGER NOT NULL,
[ BindType ] INTEGER NOT NULL,
[ BindTarget ] INTEGER NOT NULL,
[ UnbindMaxCount ] INTEGER NOT NULL,
[ BuyPriceType ] INTEGER NOT NULL,
[ BuyPrice ] INTEGER NOT NULL,
[ SellPrice ] INTEGER NOT NULL,
[ DisassemblyId ] INTEGER NOT NULL,
[ PrevSeasonDisassemblyId ] INTEGER NOT NULL,
[ Usable ] INTEGER NOT NULL,
[ UseInBattle ] INTEGER NOT NULL,
[ UseInOcean ] INTEGER NOT NULL,
[ UseCommonActionIndex ] INTEGER NOT NULL,
[ CommonActionDesc ] TEXT NOT NULL,
[ Cooltime ] INTEGER NOT NULL,
[ CooltimeGroup ] INTEGER NOT NULL,
[ UseTarget ] INTEGER NOT NULL,
[ UseTargetId ] INTEGER NOT NULL,
[ UseTargetMinRange ] INTEGER NOT NULL,
[ UseTargetRange ] INTEGER NOT NULL,
[ UseConditionId ] INTEGER NOT NULL,
[ UseActionId ] INTEGER NOT NULL,
[ UseSkillEffect ] INTEGER NOT NULL,
[ UseMusicId ] INTEGER NOT NULL,
[ UseCrewId ] INTEGER NOT NULL,
[ UseShipId ] INTEGER NOT NULL,
[ UseSailId ] INTEGER NOT NULL,
[ UseShipAvatar ] INTEGER NOT NULL,
[ UseTownActivityPoint ] INTEGER NOT NULL,
[ UseVoyageLuck ] INTEGER NOT NULL,
[ LearnCommonActionId ] INTEGER NOT NULL,
[ UseVehicleId ] INTEGER NOT NULL,
[ QuestIndex ] INTEGER NOT NULL,
[ UseCardId ] INTEGER NOT NULL,
[ UseCardWakeUp ] INTEGER NOT NULL,
[ UseTrophyId ] INTEGER NOT NULL,
[ UsePermanentAttrId ] INTEGER NOT NULL,
[ UseGainCount ] INTEGER NOT NULL,
[ UsePlacementPropId ] INTEGER NOT NULL,
[ UseTownCrewId ] INTEGER NOT NULL,
[ UseTownResearchId ] INTEGER NOT NULL,
[ UseRaidRestGauge ] INTEGER NOT NULL,
[ UseExpCombat ] INTEGER NOT NULL,
[ GainMoneyType ] INTEGER NOT NULL,
[ UseEmoticonIndex ] INTEGER NOT NULL,
[ UseGainExp ] INTEGER NOT NULL,
[ UseTownMusicId ] INTEGER NOT NULL,
[ UseSelfieItemId ] INTEGER NOT NULL,
[ UseSkillFeatureLevel ] INTEGER NOT NULL,
[ UseDialog ] INTEGER NOT NULL,
[ DialogTitleKey ] TEXT NOT NULL,
[ DialogStringKey ] TEXT NOT NULL,
[ UseCompleteStringKey ] TEXT NOT NULL,
[ UseMvpBackgroundId ] INTEGER NOT NULL,
[ Projection ] INTEGER NOT NULL,
[ ProjectionArea ] INTEGER NOT NULL,
[ ProjectionSkillEffectId ] INTEGER NOT NULL,
[ View ] INTEGER NOT NULL,
[ SkillMaxRangeProc ] INTEGER NOT NULL,
[ WeaponEffectIndex ] INTEGER NOT NULL,
[ UseEffect ] TEXT NOT NULL,
[ UseSound ] TEXT NOT NULL,
[ ApplyItemEffect ] TEXT NOT NULL,
[ ApplyItemSound ] TEXT NOT NULL,
[ ExpireNextTimeDayOfWeek ] INTEGER NOT NULL,
[ ExpireNextTimeHour ] INTEGER NOT NULL,
[ ExpireNextTimeMinute ] INTEGER NOT NULL,
[ ExpireType ] INTEGER NOT NULL,
[ ExpireTime ] INTEGER NOT NULL,
[ ExpireDeadline ] TEXT NOT NULL,
[ ExpireDeadlineMinute ] INTEGER NOT NULL,
[ ExpireResult ] INTEGER NOT NULL,
[ ExpireAbsScheduleType ] INTEGER NOT NULL,
[ SetIndex ] INTEGER NOT NULL,
[ SetLevel ] INTEGER NOT NULL,
[ ItemEquipUpgradeLevel ] INTEGER NOT NULL,
[ ReMinAttainedLevelForAbilityStone ] INTEGER NOT NULL,
[ ReMinLevel ] INTEGER NOT NULL,
[ ReMaxLevel ] INTEGER NOT NULL,
[ ReUseBalanceLevel ] INTEGER NOT NULL,
[ ClassCheckEnable ] INTEGER NOT NULL,
[ ForWarrior ] INTEGER NOT NULL,
[ ForWarriorFemale ] INTEGER NOT NULL,
[ ForBerserker ] INTEGER NOT NULL,
[ ForBerserkerFemale ] INTEGER NOT NULL,
[ ForDestroyer ] INTEGER NOT NULL,
[ ForWarlord ] INTEGER NOT NULL,
[ ForHolyKnight ] INTEGER NOT NULL,
[ ForHolyKnightFemale ] INTEGER NOT NULL,
[ ForMagician ] INTEGER NOT NULL,
[ ForArcana ] INTEGER NOT NULL,
[ ForSummoner ] INTEGER NOT NULL,
[ ForBard ] INTEGER NOT NULL,
[ ForFighter ] INTEGER NOT NULL,
[ ForFighterMale ] INTEGER NOT NULL,
[ ForBattleMaster ] INTEGER NOT NULL,
[ ForBattleMasterMale ] INTEGER NOT NULL,
[ ForInfighter ] INTEGER NOT NULL,
[ ForInfighterMale ] INTEGER NOT NULL,
[ ForForceMaster ] INTEGER NOT NULL,
[ ForLanceMaster ] INTEGER NOT NULL,
[ ForDelain ] INTEGER NOT NULL,
[ ForBlade ] INTEGER NOT NULL,
[ ForDemonic ] INTEGER NOT NULL,
[ ForReaper ] INTEGER NOT NULL,
[ ForSoulEater ] INTEGER NOT NULL,
[ ForHunter ] INTEGER NOT NULL,
[ ForHunterFemale ] INTEGER NOT NULL,
[ ForHawkEye ] INTEGER NOT NULL,
[ ForDevilHunter ] INTEGER NOT NULL,
[ ForDevilHunterFemale ] INTEGER NOT NULL,
[ ForBlaster ] INTEGER NOT NULL,
[ ForScouter ] INTEGER NOT NULL,
[ ForSpecialist ] INTEGER NOT NULL,
[ ForYinyangshi ] INTEGER NOT NULL,
[ ForWeatherArtist ] INTEGER NOT NULL,
[ ForAlchemist ] INTEGER NOT NULL,
[ ForElementalMaster ] INTEGER NOT NULL,
[ ReClass1 ] INTEGER NOT NULL,
[ ReClass2 ] INTEGER NOT NULL,
[ ReClass3 ] INTEGER NOT NULL,
[ ReClass4 ] INTEGER NOT NULL,
[ ReClass5 ] INTEGER NOT NULL,
[ ReClass6 ] INTEGER NOT NULL,
[ ReAmount ] INTEGER NOT NULL,
[ DurabilityType ] INTEGER NOT NULL,
[ MaxDurability ] INTEGER NOT NULL,
[ MaxDurabilityMinValue ] INTEGER NOT NULL,
[ MaxDurabilityDecreaseRate ] INTEGER NOT NULL,
[ ReqLifeLevel ] INTEGER NOT NULL,
[ LifeToolDurabilityBase ] INTEGER NOT NULL,
[ LifeToolDurabilityRate ] INTEGER NOT NULL,
[ FishingFloat_Normal ] INTEGER NOT NULL,
[ FishingFloat_Rare ] INTEGER NOT NULL,
[ FishingFloat_NoFish ] INTEGER NOT NULL,
[ FishingFloat_Unique ] INTEGER NOT NULL,
[ SDEntryMax ] INTEGER NOT NULL,
[ VictoryCrestId ] INTEGER NOT NULL,
[ ModItem ] INTEGER NOT NULL,
[ UseByPotionRule ] INTEGER NOT NULL,
[ PvpBattleItem ] INTEGER NOT NULL,
[ CategoryOverwrite ] TEXT NOT NULL,
[ AcquireCount ] INTEGER NOT NULL,
[ AcquireCycle ] INTEGER NOT NULL,
[ ShortenCastingTime ] INTEGER NOT NULL,
[ LifeProfessionTier ] INTEGER NOT NULL,
[ EnableMarket ] INTEGER NOT NULL,
[ EnableAuction ] INTEGER NOT NULL,
[ EnableNewWorld ] INTEGER NOT NULL,
[ TrophyAuctionPrice ] INTEGER NOT NULL,
[ CharacterTendencyIntellect ] INTEGER NOT NULL,
[ CharacterTendencyCourage ] INTEGER NOT NULL,
[ CharacterTendencyCharm ] INTEGER NOT NULL,
[ CharacterTendencyKindness ] INTEGER NOT NULL,
[ LifeToolTier ] INTEGER NOT NULL,
[ EnchantMaterialIndex ] INTEGER NOT NULL,
[ GiveHonorTitle ] INTEGER NOT NULL,
[ InnerAvatar ] INTEGER NOT NULL,
[ LightClientGroupId ] INTEGER NOT NULL,
[ AvatarReformComposite ] INTEGER NOT NULL,
[ AvatarReformDisassemble ] INTEGER NOT NULL,
[ AvatarEnchantRemove ] INTEGER NOT NULL,
[ ItemAddMaxCountId ] INTEGER NOT NULL,
[ CooldownType ] INTEGER NOT NULL,
[ MarketPackageUnit ] INTEGER NOT NULL,
[ TownResType1 ] INTEGER NOT NULL,
[ TownResCount1 ] INTEGER NOT NULL,
[ TownResType2 ] INTEGER NOT NULL,
[ TownResCount2 ] INTEGER NOT NULL,
[ TownResType3 ] INTEGER NOT NULL,
[ TownResCount3 ] INTEGER NOT NULL,
[ TownResType4 ] INTEGER NOT NULL,
[ TownResCount4 ] INTEGER NOT NULL,
[ TownResType5 ] INTEGER NOT NULL,
[ TownResCount5 ] INTEGER NOT NULL,
[ TownResType6 ] INTEGER NOT NULL,
[ TownResCount6 ] INTEGER NOT NULL,
[ TownResType7 ] INTEGER NOT NULL,
[ TownResCount7 ] INTEGER NOT NULL,
[ ReMinAttainedLevel ] INTEGER NOT NULL,
[ UsePetId ] INTEGER NOT NULL,
[ UseSkillRuneId ] INTEGER NOT NULL,
[ ItemLevelDisplay ] INTEGER NOT NULL,
[ ClassifyType ] INTEGER NOT NULL,
[ ClassifyIndex ] INTEGER NOT NULL,
[ AstraIndex ] INTEGER NOT NULL,
[ SealIndex ] INTEGER NOT NULL,
[ SealLimitEnabled ] INTEGER NOT NULL,
[ ClassifyType2 ] INTEGER NOT NULL,
[ ClassifyIndex2 ] INTEGER NOT NULL,
[ MagicScrollEnabled ] INTEGER NOT NULL,
[ BindId ] INTEGER NOT NULL,
[ StaticOptionId0 ] INTEGER NOT NULL,
[ StaticOptionId1 ] INTEGER NOT NULL,
[ RandomOptionId0 ] INTEGER NOT NULL,
[ RandomOptionId1 ] INTEGER NOT NULL,
[ SocketId ] INTEGER NOT NULL,
[ QualityOptionId ] INTEGER NOT NULL,
[ QualityInheritGrade ] INTEGER NOT NULL,
[ QualityInheritLevel ] INTEGER NOT NULL,
[ QualityInheritId ] INTEGER NOT NULL,
[ QualityTransferId ] INTEGER NOT NULL,
[ UpgradeBaseId ] INTEGER NOT NULL,
[ UpgradeTargetId ] INTEGER NOT NULL,
[ UpgradeMaterialId ] INTEGER NOT NULL,
[ EnhanceReplaceId ] INTEGER NOT NULL,
[ NextEquipId ] INTEGER NOT NULL,
[ ProximityInheritGroupId ] INTEGER NOT NULL,
[ CalibrateEnabled ] INTEGER NOT NULL,
[ OptionExtractEnabled ] INTEGER NOT NULL,
[ DestroyOnExtract ] INTEGER NOT NULL,
[ GemSlotCount ] INTEGER NOT NULL,
[ LifeToolRepairMoneyType ] INTEGER NOT NULL,
[ LifeToolRepairMoneyValue ] INTEGER NOT NULL,
[ RecoverTownMana ] INTEGER NOT NULL,
[ EngraveEnabled ] INTEGER NOT NULL,
[ QuestStartConditionItemGroupType ] INTEGER NOT NULL,
[ BrokenEquip ] INTEGER NOT NULL,
[ TradeChargeIndex ] INTEGER NOT NULL,
[ TradeLimitLevel ] INTEGER NOT NULL,
[ ReadjustCostId ] INTEGER NOT NULL,
[ InheritType ] INTEGER NOT NULL,
[ EnableTint ] INTEGER NOT NULL,
[ VolatilityZoneId ] INTEGER NOT NULL,
[ ExpBoostingPaidService ] INTEGER NOT NULL,
[ ExpBoostingTownResearch ] INTEGER NOT NULL,
[ ExpBoostingPcroom ] INTEGER NOT NULL,
[ ExpBoostingBeatrice ] INTEGER NOT NULL,
[ InstrumentModel ] TEXT NOT NULL,
[ PetIgnoreLootTerms ] INTEGER NOT NULL,
[ FirstSortEnabled ] INTEGER NOT NULL,
[ EnhanceEffectId ] INTEGER NOT NULL,
[ AchievementItemGroup ] INTEGER NOT NULL,
[ AchievementItemGroup2 ] INTEGER NOT NULL,
[ SetTransferGroupId ] INTEGER NOT NULL,
[ EngraveTooltip ] INTEGER NOT NULL,
[ UseExpPet ] INTEGER NOT NULL,
[ BraceletUpgradeId ] INTEGER NOT NULL,
[ AccessoryUpgradeId ] INTEGER NOT NULL,
[ CooltimeRvR ] INTEGER NOT NULL,
[ SecretMapPartyUseId ] INTEGER NOT NULL,
[ ModificationEnabled ] INTEGER NOT NULL,
[ OptionExtractId ] INTEGER NOT NULL,
[ ExceedTargetId ] INTEGER NOT NULL,
[ ExceedLevel ] INTEGER NOT NULL,
[ AosPassiveId ] INTEGER NOT NULL,
[ AosBuySkillEffectId ] INTEGER NOT NULL,
[ AosSellSkillEffectId ] INTEGER NOT NULL,
[ AosShopLimitType ] INTEGER NOT NULL,
[ AosShopLimitCount ] INTEGER NOT NULL,
[ AosItemCategory ] INTEGER NOT NULL,
[ TownGiftEnabled ] INTEGER NOT NULL,
[ ChangeFootStepAvatarFXId ] INTEGER NOT NULL,
[ UseTownMoodId ] INTEGER NOT NULL,
[ UseTownNpcDressId ] INTEGER NOT NULL,
[ ElixirEnchantEnabled ] INTEGER NOT NULL,
[ TranscendenceId ] INTEGER NOT NULL,
[ TranscendenceSetId ] INTEGER NOT NULL,
[ InstrumentId ] INTEGER NOT NULL,
[ InstrumentIndex ] INTEGER NOT NULL,
[ LuckyRewardType ] INTEGER NOT NULL,
[ AmplificationBaseId ] INTEGER NOT NULL,
[ SlotBorderType ] INTEGER NOT NULL,
[ CalibrateAdjustBonusId ] INTEGER NOT NULL,
[ UseEngraveUnlockGrade ] INTEGER NOT NULL,
[ UseEngraveUnlockProgress ] INTEGER NOT NULL,
[ LevelOptionId ] INTEGER NOT NULL,
[ ExpireAbsoluteScheduleId ] INTEGER NOT NULL,
[ SourceRow ] INTEGER NOT NULL,
[ Milestone ] TEXT NOT NULL,
PRIMARY KEY ([ PrimaryKey ])
)