chess
Tables (24)
achievement (Untitled19)
- id (Key) — Primary key — NOT NULL
- title (Field)
- description (Field2)
- image_url (Field3)
- created_at (Field4)
- updated_at (Field5)
chatting_room (Untitled12)
- id (Key) — Primary key — NOT NULL
- title (Field)
- created_at (Field3)
- updated_at (Field4)
- is_deleted (Field5)
club (Untitled15)
- id (Key) — Primary key — NOT NULL
- name (Field)
- description (Field2)
- owner_id (Field3)
- image_url (Field5)
- created_at (Field4)
- updated_at (Field6)
- is_deleted (Field7)
club_member (Untitled17)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.id — NOT NULL
- club_id (Key3) — Foreign key → club.id — NOT NULL
- role (Field3)
- status (Field4)
- created_at (Field)
- updated_at (Field2)
- is_deleted (Field5)
content (Untitled14)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.id — NOT NULL
- type (Field)
- title (Field2)
- content_text (Field4)
- image_url (Field5)
- created_at (Field3)
- updated_at (Field6)
- is_deleted (Field7)
daily_puzzle (Untitled7)
- id (Key) — Primary key — NOT NULL
- puzzle_id (Key2) — Foreign key → puzzle.id — NOT NULL
- daily_date (Field2)
friend (Untitled6)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.id — NOT NULL
- friend_id (Key3) — Foreign key → user.id — NOT NULL
- created_at (Field)
- is_deleted (Field3)
friend_request (Untitled23)
- id (Key) — Primary key — NOT NULL
- sender_id (Key2) — Foreign key → user.id — NOT NULL
- receiver_id (Key3) — Foreign key → user.id — NOT NULL
- status (Field)
- created_at (Field2)
- updated_at (Field3)
game_history (Untitled4)
- id (Key) — Primary key — NOT NULL
- winner_id (Field)
- mode (Field5)
- start_at (Field2)
- end_at (Field3)
- duration_sec (Field4)
- user1_accuracy (Field6)
- user2_accuracy (Field7)
- fen (Field8)
- end_reason (Field9)
game_info (Untitled16)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.id — NOT NULL
- game_history_id (Key3) — Foreign key → game_history.id — NOT NULL
- updated_rate (Field3)
- created_at (Field)
- updated_at (Field2)
game_rating (game__rating)
- id — Primary key — NOT NULL
- user_id — Foreign key → user.id — NOT NULL
- mode
- rate
- created_at
- updated_at
- is_deleted
league (Untitled8)
- Id (Key) — Primary key — NOT NULL
- group_code (Field3)
- year (Field4)
- week (Field5)
- created_at (Field6)
- updated_at (Field7)
- is_deleted (Field8)
message (Untitled22)
- id (Key) — Primary key — NOT NULL
- user_chatting_room_id (Key2) — Foreign key → user_chatting_room.id — NOT NULL
- sender_id (Key22) — Foreign key → user_chatting_room.user_id — NOT NULL
- content (Field)
- created_at (Field2)
- updated_at (Field3)
- is_deleted (Field4)
puzzle (Untitled3)
- id (Key) — Primary key — NOT NULL
- fen (Field)
- difficulty_rate (Field2)
- theme (Field3)
- created_at (Field4)
- updated_at (Field5)
- is_deleted (Field6)
puzzle_attempt (Untitled13)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → puzzle.id — NOT NULL
- puzzle_id (Key3) — Foreign key → user.id — NOT NULL
- is_solved (Field)
- rating_change (Field2)
- start_at (Field5)
- end_at (Field6)
- created_at (Field3)
- updated_at (Field4)
puzzle_rush (Untitled10)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.id — NOT NULL
- mode (Field)
- start_at (Field2)
- end_at (Field3)
- best_streak (Field4)
- total_solved (Field5)
- created_at (Field6)
- is_deleted (Field7)
puzzle_solution (Untitled5)
- id (Key) — Primary key — NOT NULL
- puzzle_id (Key2) — Foreign key → puzzle.id — NOT NULL
- step_number (Field)
- move_san (Field2)
- description (Field3)
tv_schedule (Untitled18)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.id — NOT NULL
- title (Field)
- start_at (Field3)
- end_at (Field4)
- description (Field5)
- image_url (Field6)
- language (Field7)
- created_at (Field8)
- updated_at (Field9)
- is_deleted (Field10)
user
- id — bigint — Primary key — NOT NULL
- username — varchar(100)
- first_name — varchar(100)
- last_name — varchar(100)
- location — varchar(100)
- country — varchar(100)
- image_url — varchar(255)
- created_at — datetime(6)
- updated_at — datetime(6)
- is_deleted — boolean
user_achievement (Untitled20)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.id — NOT NULL
- achievement_id (Key3) — Foreign key → achievement.id — NOT NULL
- created_at (Field2)
- updated_at (Field)
user_block (Untitled24)
- id (Key) — Primary key — NOT NULL
- blocker_id (Key2) — Foreign key → user.id — NOT NULL
- blocked_id (Key3) — Foreign key → user.id — NOT NULL
- created_at (Field3)
- updated_at (Field4)
user_chatting_room (Untitled11)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.id — NOT NULL
- chatting_room_id (Key3) — Foreign key → chatting_room.id — NOT NULL
- is_archieved (Field)
user_league (Untitled9)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.id — NOT NULL
- league_id (Key3) — Foreign key → league.Id — NOT NULL
- rank (Field)
- trophy (Field2)
- mode (Field3)
- games_played (Field4)
user_puzzle_stats (Untitled21)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.id — NOT NULL
- puzzle_rating (Field2)
- puzzle_rank (Field3)
- total_solved (Field4)
- correct_rate (Field5)
- updated_at (Field)