Prac_191221

Tables (14)

CapInfo

  • fdCapID — int — Primary key — NOT NULL
  • fdCategoryNum — int — Foreign key → ItemInfo.fdCategoryNum — NOT NULL
  • fdName — string — NOT NULL
  • fdCapGage — int
  • fdGetCountCap — int
  • fdGachaID — int — Foreign key → GachaInfo.fdGachaID — NOT NULL

CardInfo

  • fdCardID — int — Primary key — NOT NULL
  • fdItemID — int — Foreign key → ItemInfo.fdItemID — NOT NULL
  • fdCardGrade — int — NOT NULL
  • fdCardGetLevel — int — NOT NULL
  • fdResourcePoint — int — NOT NULL
  • fdReturnResourcePoint — int — NOT NULL
  • fdPosition — int — NOT NULL
  • fdAttackType — string — NOT NULL
  • fdTowerAttackType — string — NOT NULL
  • fdSpawnType — string — NOT NULL
  • fdbulletPrefabName — string
  • fdbulletThrowPosition — string
  • fdSpawnEffect — string
  • fdAttackEffect — string
  • fdHitEffect — string
  • fdDieEffect — string
  • fdSpawnSound — string
  • fdAttackSound — string
  • fdHitSound — string
  • fdDieSound — string

CardLevelInfo

  • fdCardLevel — int — Primary key — NOT NULL
  • fdCardID — int — Foreign key → CardInfo.fdCardID — NOT NULL
  • fdPrefebName — string — NOT NULL
  • fdmaxHP — int — NOT NULL
  • fdminAttack — int — NOT NULL
  • fdmaxAttack — int — NOT NULL
  • fdcriticalProbability — int — NOT NULL
  • fdcriticalDamage — int — NOT NULL
  • fdAttackDistance — int — NOT NULL
  • fdAttackDelay — int — NOT NULL
  • fdHitAreaDistance — int — NOT NULL
  • fdMoveSpeed — int — NOT NULL

Copy Of UserSPInfo (UserCapInfo)

  • fdUserID — int — Foreign key → UserInfo.fdUserID
  • fdItemID — int — Foreign key → ItemInfo.fdItemID — NOT NULL
  • fdCount — int — NOT NULL

GachaInfo

  • fdGachaID — int — Primary key — NOT NULL
  • fdEctRewardCount — int
  • fdNormalPerCount — int
  • fdRarePerCount — int
  • fdHeroPerCount — int
  • fdGoldMin — int
  • fdGlodMax — int
  • fdSlotCountID — int — Foreign key → GrpSlotCountPer.fdSlotCountID — NOT NULL
  • fdSPCountID — int — Foreign key → GrpSPCountPer.fdSPCountID — NOT NULL

GrpSPCountPer

  • fdSPCountID — int — Primary key — NOT NULL
  • fdSPCountPerID — int — Foreign key → SPCountPerInfo.fdSPCountPerID — NOT NULL

GrpSlotCountPer

  • fdSlotCountID — int — Primary key — NOT NULL
  • fdSlotCountPerID — int — Foreign key → SlotCountPerInfo.fdSlotCountPerID — NOT NULL

ItemInfo

  • fdItemID — int — Primary key — NOT NULL
  • fdCategoryNum — int — Primary key — NOT NULL

SPCountPerInfo

  • fdSPCountPerID — int — Primary key — NOT NULL
  • fdRewardCount — int — NOT NULL
  • fdPerCount — int — NOT NULL

SPInfo

  • fdSPID — int — Primary key — NOT NULL
  • fdItemID — int — Foreign key → ItemInfo.fdItemID — NOT NULL
  • fdName — String — NOT NULL
  • fdLimitCount — int — NOT NULL
  • fdCardID — int — Foreign key → CardInfo.fdCardID — NOT NULL

SlotCountPerInfo

  • fdSlotCountPerID — int — Primary key — NOT NULL
  • fdSlotCount — int — NOT NULL
  • fdPerCount — int — NOT NULL

UserCardInfo

  • fdUserID — int — Foreign key → UserInfo.fdUserID
  • fdItemID — int — Foreign key → ItemInfo.fdItemID — NOT NULL
  • fdLevel — int

UserInfo

  • fdUserID — int — Primary key
  • fdName — string
  • fdUserLevel — int
  • fdUserExp — int
  • fdGold — int
  • fdDia — int

UserSPInfo

  • fdUserID — int — Foreign key → UserInfo.fdUserID
  • fdItemID — int — Foreign key → ItemInfo.fdItemID — NOT NULL
  • fdCount — int — NOT NULL