EFTable_Shop.db

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

Row count: 3536

Download CSV Zipped

CREATE TABLE Shop (
  [ PrimaryKey ] INTEGER NOT NULL,
  [ SecondaryKey ] INTEGER NOT NULL,
  [ Name ] TEXT NOT NULL,
  [ SellMoneyType ] INTEGER NOT NULL,
  [ ItemIndex ] INTEGER NOT NULL,
  [ ItemQuality ] INTEGER NOT NULL,
  [ BundleAmount ] INTEGER NOT NULL,
  [ BarterType ] INTEGER NOT NULL,
  [ BarterItemIndex ] INTEGER NOT NULL,
  [ BarterQuantity ] INTEGER NOT NULL,
  [ TypeCount ] INTEGER NOT NULL,
  [ TypeTextIndex1 ] TEXT NOT NULL,
  [ TypeTextIndex2 ] TEXT NOT NULL,
  [ TypeTextIndex3 ] TEXT NOT NULL,
  [ TypeTextIndex4 ] TEXT NOT NULL,
  [ TypeTextIndex5 ] TEXT NOT NULL,
  [ LimitStockType ] INTEGER NOT NULL,
  [ LimitStockCountMin ] INTEGER NOT NULL,
  [ LimitStockCountMax ] INTEGER NOT NULL,
  [ LimitStockParam ] INTEGER NOT NULL,
  [ RestockCountMin ] INTEGER NOT NULL,
  [ RestockCountMax ] INTEGER NOT NULL,
  [ LimitCount ] INTEGER NOT NULL,
  [ LimitReleaseType ] INTEGER NOT NULL,
  [ LimitReleaseValue ] INTEGER NOT NULL,
  [ ConditionType ] INTEGER NOT NULL,
  [ ConditionValue1 ] INTEGER NOT NULL,
  [ ConditionValue2 ] INTEGER NOT NULL,
  [ ConditionType_1 ] INTEGER NOT NULL,
  [ ConditionValue1_1 ] INTEGER NOT NULL,
  [ ConditionValue2_1 ] INTEGER NOT NULL,
  [ ConditionIntellect ] INTEGER NOT NULL,
  [ ConditionCourage ] INTEGER NOT NULL,
  [ ConditionCharm ] INTEGER NOT NULL,
  [ ConditionKindness ] INTEGER NOT NULL,
  [ CheckTargetType ] INTEGER NOT NULL,
  [ CheckTargetId ] INTEGER NOT NULL,
  [ TownOwnerLimitCount ] INTEGER NOT NULL,
  [ TownGuestLimitCount ] INTEGER NOT NULL,
  [ TownGuestEnabled ] INTEGER NOT NULL,
  [ ClassifyType ] INTEGER NOT NULL,
  [ ClassifyIndex ] INTEGER NOT NULL,
  [ ShopLimitIndex ] INTEGER NOT NULL,
  [ ConstantAdd ] INTEGER NOT NULL,
  [ ConstantMulti ] REAL NOT NULL,
  [ RightValue ] INTEGER NOT NULL,
  [ ConstantType ] INTEGER NOT NULL,
  [ ClassifyType2 ] INTEGER NOT NULL,
  [ ClassifyIndex2 ] INTEGER NOT NULL,
  [ LimitCountBindTarget ] INTEGER NOT NULL,
  [ Dummy ] INTEGER NOT NULL,
  [ GameConditionId ] INTEGER NOT NULL,
  [ ConditionMsgString ] TEXT NOT NULL,
  [ ConditionToolTipString ] TEXT NOT NULL,
  [ ConditionYear ] INTEGER NOT NULL,
  [ ConditionMonth ] INTEGER NOT NULL,
  [ ConditionDay ] INTEGER NOT NULL,
  [ ShopItemLevelGrade ] INTEGER NOT NULL,
  [ ShowItemLevelMin ] INTEGER NOT NULL,
  [ ShowItemLevelMax ] INTEGER NOT NULL,
  [ ShowItemLevelId ] INTEGER NOT NULL,
  [ UseImmediately ] INTEGER NOT NULL,
  [ TradeMaxCount ] INTEGER NOT NULL,
  [ SourceRow ] INTEGER NOT NULL,
  [ Milestone ] TEXT NOT NULL,
  PRIMARY KEY ([ PrimaryKey ], [ SecondaryKey ])
)