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