indiegame
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
- game_id — INT — Foreign key → Game.game_id
- prompt_input — TEXT
Recommendation_Result
- result_id — INT — Primary key — NOT NULL
- log_id — INT — Foreign key
- game_id — INT — Foreign key
- reason — TEXT
- match_score — INT
SCREENSHOT
- screenshot_id — INT — Primary key — NOT NULL
- game_id — INT — Foreign key → Game.game_id
- 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