HK_server
Tables (4)
pick_result
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → room.id — NOT NULL
- player_id — BIGINT — Foreign key → player.id — NOT NULL
- item_id — VARCHAR(255) — NOT NULL
- item_name — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
player
- id — BIGINT — Primary key — NOT NULL
- player_id — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- profile_image_key — VARCHAR(255)
- room_id — BIGINT — Foreign key → room.id — NOT NULL
- created_at — DATETIME — NOT NULL
room
- id — BIGINT — Primary key — NOT NULL
- room_code — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- message_sequence — BIGINT — NOT NULL
room_message
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → room.id — NOT NULL
- player_id — BIGINT — Foreign key → player.id — NOT NULL
- sequence — BIGINT — NOT NULL
- content — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL