ESRS

Tables (12)

Card

  • Key (card_id) — Long — Primary key — NOT NULL
  • Key (game_id) — Long — Foreign key → Game.Key — NOT NULL
  • suit — Json — NOT NULL
  • rank — VARCHAR(50) — NOT NULL

Deck

  • Key (deck_id) — Long — Primary key — NOT NULL
  • Key (game_id) — Long — Foreign key → Game.Key — NOT NULL
  • deck_id (deck_content) — Json

Friendship

  • Key (friendship_id) — Long — Primary key — NOT NULL
  • Key (user_id) — Long — Foreign key → User.Key — NOT NULL
  • friend_id — INT — NOT NULL
  • status — VARCHAR(50) — NOT NULL

Game

  • Key (game_id) — Long — Primary key — NOT NULL

Hand

  • Key (hand_id) — Long — Primary key — NOT NULL
  • rank — VARCHAR(50) — NOT NULL
  • Key (player_id) — Long — Foreign key → Player.Key — NOT NULL
  • Key (user_id) — Long — Foreign key → Player.Key — NOT NULL
  • Key (game_id) — Long — Foreign key → Game.Key — NOT NULL

Message

  • Key (message_id) — Long — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • timestamp — TIMESTAMP
  • Key (sender_id) — Long — Foreign key → User.Key — NOT NULL
  • Key (receiver_id) — Long — Foreign key → User.Key — NOT NULL

Notification

  • Key (notification_id) — Long — Primary key — NOT NULL
  • Key (game_id) — Long — Foreign key → Game.Key — NOT NULL
  • message — TEXT — NOT NULL

Player

  • Key (player_id) — Long — Primary key — NOT NULL
  • Key (user_id) — Long — Foreign key → User.Key — NOT NULL
  • Key (game_id) — Long — Foreign key → Game.Key — NOT NULL
  • position — VARCHAR(50) — NOT NULL

Pot

  • Key (pot_id) — Long — Primary key — NOT NULL
  • Key (game_id) — Long — Foreign key → Game.Key — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL

Profile

  • Key (profile_id) — LONG — Primary key — NOT NULL
  • Key (user_id) — Long — Foreign key → User.Key — NOT NULL
  • picture — VARCHAR(255)
  • privacy — VARCHAR(255)

Seat

  • Key (seat_id) — Long — Primary key — NOT NULL
  • Field (seat_number) — Long — NOT NULL
  • Key (player_id) — Long — Foreign key → Player.Key — NOT NULL
  • Key (user_id) — Long — Foreign key → Player.Key — NOT NULL
  • Key (game_id) — Long — Foreign key → Player.Key — NOT NULL

User

  • Key (user_id) — Long — Primary key — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL