indiegame2

Tables (13)

Follow

  • follow_id — INT — Primary key — NOT NULL
  • follower_id — INT — Foreign key → User.user_id
  • following_id — INT — Foreign key → User.user_id

Game

  • game_id — INT — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • initial_price — DECIMAL(10, 2)
  • final_price — DECIMAL(10, 2)
  • capsule_url — VARCHAR(255)
  • metacritic_score — INT
  • release_date — DATE
  • is_korean — BOOLEAN
  • required_age — INT
  • platform — VARCHAR(100)
  • offline — BOOLEAN
  • rawg_id — INT
  • steam_id — INT

Game_Tag

  • game_id — INT — Foreign key → Game.game_id — NOT NULL
  • tag_id — INT — Foreign key → Genre.tag_id — NOT NULL

Game_Video

  • video_id — INT — Primary key — NOT NULL
  • game_id — INT — Foreign key → Game.game_id
  • title — VARCHAR(200)
  • video_url — VARCHAR(255)
  • thumbnail — VARCHAR(255)

Genre

  • tag_id — INT — Primary key — NOT NULL
  • genre_name — VARCHAR(50) — NOT NULL

Medal

  • medal_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.user_id
  • medal_name — VARCHAR(100) — NOT NULL

Post

  • post_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.user_id
  • game_id — INT — Foreign key → Game.game_id
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • category — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Post_Comment

  • comment_id — INT — Primary key — NOT NULL
  • post_id — INT — Foreign key → Post.post_id
  • user_id — INT — Foreign key → User.user_id
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Recommendation_Log

  • log_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.user_id
  • prompt_input — TEXT

Recommendation_Result

  • result_id — INT — Primary key — NOT NULL
  • log_id — INT — Foreign key → Recommendation_Log.log_id
  • game_id — INT — Foreign key → Game.game_id
  • reason — TEXT
  • match_score — INT

SCREENSHOT

  • screenshot_id — INT — Primary key — NOT NULL
  • game_id — INT — Foreign key → Game.game_id — NOT NULL
  • image_url — VARCHAR(255)

User

  • user_id — INT — Primary key — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • birth_date — DATE
  • profile_img — VARCHAR(255)

Wishlist

  • wishlist_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.user_id
  • game_id — INT — Foreign key → Game.game_id