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