11
Tables (14)
CharacterDATA (CopyOfCharater)
- CharaterID — VarChar[10] — Primary key — NOT NULL
- job — Int — 0=warrior 1=archer 2=magician 3=supporter
- MaxHealth (MAXHP) — Int
- MaxMana (MaxMP) — Int
- AtkPower (ATKPW) — Int
CharaterSkilldata (CSkill)
- cSkillID — VarChar[30] — Primary key — NOT NULL
- SkillName (Sname) — VarChar[10]
- IsBUFF — TinyInt — 0= attack skill 1=Buff skill
- Power — Int
- UseMana — Int
- LimitLevel — int
- job (int) — int
EnemySkill
- EskillID — VarChar[10] — Primary key — NOT NULL
- EnemyID (EID) — VarChar[10] — Foreign key → Enemy_Data.EnemyID — NOT NULL
- SkilName (Sname) — VarChar[10]
- Power (PW) — Int
Enemy_Data (Enemy)
- EnemyID (EID) — VarChar[10] — Primary key — NOT NULL
- Health (HP) — Int
- MaxHealth (MaxHP) — Int
- ATKPower (ATKPW) — Int
Item (Untitled3)
- ItemID — VarChar[10] — Primary key — NOT NULL
- explanation (explain) — varchar(100)
User (Untitled)
- UserID — VarChar[10] — Primary key — NOT NULL
- AVG_PW — float
- Email — varchar(100)
- PassWord (PW) — varchar(100)
- rank — int
- gold — int
User_Charater (Charater)
- userCharacterID (ucID) — VarChar[30] — Primary key — NOT NULL
- UserID — VarChar[10] — Foreign key → User.UserID — NOT NULL
- CharaterID — VarChar[10] — Foreign key → CharacterDATA.CharaterID — NOT NULL
- WeaponID (wpID) — VarChar[10] — Foreign key → Weapon.WeaponID — NOT NULL
- Name — VarChar[10]
- Health (HP) — Int
- Mana (MP) — Int
- Level — int
Weapon (Untitled2)
- WeaponID (wpID) — VarChar[10] — Primary key — NOT NULL
- WeaponPower (wpPW) — Int
- job — Int — 0=warrior 1=archer 2=magician 3=supporter
- LimitLevel — int
attackReport (Untitled8)
- SkillLogID — Varchar(10) — Primary key — NOT NULL
- Caster — Varchar(10)
- Target — Varchar(10)
- Damage — int
characterSkill (Untitled7)
- SkillNum — varchar(10) — Primary key — NOT NULL
- userCharacterID (ucID) — VarChar[30] — Foreign key → User_Charater.userCharacterID — NOT NULL
- cSkillID — VarChar[30] — Foreign key → CharaterSkilldata.cSkillID — NOT NULL
inventory (Untitled5)
- slotID — VarChar[10] — Primary key — NOT NULL
- UserID — VarChar[10] — Foreign key → User.UserID — NOT NULL
- ItemID — VarChar[10] — Foreign key → Item.ItemID — NOT NULL
- quantity — int
order (Untitled6)
- transition — VarChar[10] — Primary key — NOT NULL
- shopItemID — VarChar[10] — Foreign key → shop.shopItemID — NOT NULL
- UserID — VarChar[10] — Foreign key → User.UserID — NOT NULL
- totalCost
- amount (amout)
shop (Untitled4)
- shopItemID — VarChar[10] — Primary key — NOT NULL
- ItemID — VarChar[10] — Foreign key → Item.ItemID — NOT NULL
- Remainning (Remaining) — int
- cost — int
skillReport (Untitled9)
- AttackID — Varchar(10) — Primary key — NOT NULL
- Attacker — Varchar(10)
- Target — Varchar(10)
- Damrge (Damage) — int