diamondGame

Tables (8)

Friends (Untitled7)

  • user_id (Key2) — NOT NULL — Foreign key → User.id — NOT NULL
  • friend_id (Field)

Game (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • room_id (Field)
  • player_count (Field2)
  • turn_num (Field3)

Inventory (Untitled2)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • chosen_id (Field2)
  • user_id (Key2) — NOT NULL — Foreign key → User.id — NOT NULL

Item (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • type (Field)
  • design (Field2)
  • price (Field3)

Marker (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • player_num (Field)
  • pos (Field2)
  • game_id (Key2) — Foreign key → Game.id — NOT NULL

Move (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • from_pos (Field)
  • to_pos (Field2)
  • turn_num (Field3)
  • game_id (Key2) — Foreign key → Game.id — NOT NULL

Timer (Untitled8)

  • id (Key) — Primary key — NOT NULL

User (Untitled)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • email — NOT NULL
  • password — NOT NULL
  • credit — NOT NULL
  • name (Field)
  • rating (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • my_inventory (Field5)
  • game_id (Key2) — Foreign key → Game.id — NOT NULL
  • user_id (Key22) — NOT NULL — Foreign key → Friends.user_id — NOT NULL