query dsl practice

Tables (4)

game (게임)

  • game_code (Key) — bigint — Primary key — NOT NULL
  • game_name (Field) — varchar
  • game_info (Field2) — varchar
  • game_order (Field3) — bigint

team (팀)

  • team_code (Key) — bigint — Primary key — NOT NULL
  • team_name (Field) — varchar
  • team_info (Field2) — varchar
  • created_at (Field3) — dateTime
  • deleted_at (Field4) — dateTime

team_game (팀_게임)

  • team_game_code (Key) — bigint — Primary key — NOT NULL
  • game_code (Key2) — bigint — Foreign key → game.game_code — NOT NULL
  • team_code (Key3) — bigint — Foreign key → team.team_code — NOT NULL

user (유저)

  • user_code (Key) — bigint — Primary key — NOT NULL
  • user_name (Field) — varchar
  • user_info (Field2) — varchar
  • created_at (Field3) — dateTime
  • created_at (Field4) — dateTime
  • team_code (Key2) — bigint — Foreign key → team.team_code — NOT NULL