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)