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