Game

Tables (7)

character (Untitled4)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • name (Field3) — NOT NULL
  • health (Field) — NOT NULL
  • stamina (Field2) — NOT NULL

item (Untitled2)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • name (Field) — NOT NULL
  • description (Field2) — NOT NULL
  • limit (Field3) — NOT NULL

member (Untitled)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • email (Field) — NOT NULL
  • password (Field2) — NOT NULL

member_character (Untitled5)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • member_id (Key2) — NOT NULL — Foreign key → member.id — NOT NULL
  • character_id (Key3) — NOT NULL — Foreign key → character.id — NOT NULL
  • health_level (Field) — NOT NULL
  • stamina_level (Field2) — NOT NULL
  • is_open (Field3) — NOT NULL

member_item (Untitled3)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • member_id (Key2) — NOT NULL — Foreign key → member.id — NOT NULL
  • item_id (Key3) — NOT NULL — Foreign key → item.id — NOT NULL
  • count (Field) — NOT NULL

member_stage (Untitled7)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • member_id (Key2) — NOT NULL — Foreign key → member.id — NOT NULL
  • stage_id (Key3) — NOT NULL — Foreign key → stage.id — NOT NULL
  • best_score (Field2) — NOT NULL
  • is_clear (Field) — NOT NULL
  • is_open (Field3) — NOT NULL

stage (Untitled6)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • next_id (Field2) — NOT NULL
  • name (Field) — NOT NULL
  • level (Field3) — NOT NULL