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