item_simul

Tables (5)

Accounts (Untitled2)

  • accounts_key (Key) — Primary key — NOT NULL
  • id (Field)
  • pw (Field2)
  • pw_check (Field3)
  • name (Field4)
  • signup_at (Field5)

Characters (Untitled3)

  • characters_id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → Accounts.accounts_key — NOT NULL
  • name (Field6)
  • hp (Field2)
  • mp (Field3)
  • pow (Field4)
  • money (Field5)
  • created_at (Field)

Equips (Untitled5)

  • characters_id (Key) — Foreign key → Characters.characters_id — NOT NULL
  • id (Key2) — Foreign key → Characters.id — NOT NULL

Inventory (Untitled4)

  • characters_id (Key) — Foreign key → Characters.characters_id — NOT NULL
  • id (Key2) — Foreign key → Characters.id — NOT NULL

Item (Untitled)

  • item_code (Key) — Primary key — NOT NULL
  • characters_id (Key2) — Foreign key → Characters.characters_id — NOT NULL
  • id (Key22) — Foreign key → Characters.id — NOT NULL
  • name (Field)
  • stats (Field2)
  • price (Field5)
  • count (Field8)
  • created_at (Field6)
  • updated_at (Field7)