39과제_steam
테이블 (25)
Achievement
- id — INT
- game_id — INT — 외래 키 → Game.id — NOT NULL
- name — VARCHAR(100)
- description — TEXT
- condition — TEXT
- icon — VARCHAR(255)
Bundle
- id — INT
- publisher_id — INT — 외래 키 → Publisher.id — NOT NULL
- bundle_name — VARCHAR(200)
- bundle_price — DECIMAL(10,2)
BundleGame
- bundle_id — INT — 외래 키 → Bundle.id — NOT NULL
- game_id — INT — 외래 키 → Game.id — NOT NULL
Cart
- user_id — INT — 외래 키 → User.id — NOT NULL
- game_id — INT — 외래 키 → Game.id — NOT NULL
- added_at — DATETIME
DLC
- id — INT
- game_id — INT — 외래 키 → Game.id — NOT NULL
- dlc_name — VARCHAR(200)
- description — TEXT
- price — DECIMAL(10,2)
- release_date — DATE
Developer
- id — INT
- user_id — INT — 외래 키 → User.id — NOT NULL
- company_name — VARCHAR(100)
- country — VARCHAR(50)
- email — VARCHAR(100)
Friendship
- user_id — INT — 외래 키 → User.id — NOT NULL
- friend_id — INT — 외래 키 → User.id — NOT NULL
- request_date — DATE
- accept_date — DATE
- status — VARCHAR(20)
Game
- id — INT
- developer_id — INT — 외래 키 → Developer.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- price — DECIMAL(10,2)
- release_date — DATE
- review_status — VARCHAR(20)
- system_requirements — TEXT
GameGenre
- game_id — INT — 외래 키 → Game.id — NOT NULL
- genre_id — INT — 외래 키 → Genre.id — NOT NULL
GameReview
- id — INT
- game_id — INT — 외래 키 → Game.id — NOT NULL
- admin_id — INT — 외래 키 → User.id — NOT NULL
- result — VARCHAR(20)
- rejection_reason — TEXT
- process_date — DATE
GameTag
- game_id — INT — 외래 키 → Game.id — NOT NULL
- tag_id — INT — 외래 키 → Tag.id — NOT NULL
Genre
- id — INT
- genre_name — VARCHAR(50) — NOT NULL
PlaySession
- id — INT
- user_id — INT — 외래 키 → User.id — NOT NULL
- game_id — INT — 외래 키 → Game.id — NOT NULL
- start_time — DATETIME
- end_time — DATETIME
Publisher
- id — INT
- user_id — INT — 외래 키 → User.id — NOT NULL
- company_name — VARCHAR(100)
- country — VARCHAR(50)
- email — VARCHAR(100)
PublishingContract
- id — INT
- developer_id — INT — 외래 키 → Developer.id — NOT NULL
- publisher_id — INT — 외래 키 → Publisher.id — NOT NULL
- game_id — INT — 외래 키 → Game.id — NOT NULL
- revenue_share — DECIMAL(5,2)
- start_date — DATE
- end_date — DATE
Purchase
- id — INT
- user_id — INT — 외래 키 → User.id — NOT NULL
- game_id — INT — 외래 키 → Game.id — NOT NULL
- amount — DECIMAL(10,2)
- payment_method — VARCHAR(50)
- purchased_at — DATETIME
Refund
- id — INT
- purchase_id — INT — 외래 키 → Purchase.id — NOT NULL
- admin_id — INT — 외래 키 → User.id — NOT NULL
- reason — TEXT
- request_date — DATE
- status — VARCHAR(20)
- process_date — DATE
Report
- id — INT
- reporter_id — INT — 외래 키 → User.id — NOT NULL
- target_type — VARCHAR(20)
- target_id — INT
- reason — TEXT
- report_date — DATE
- status — VARCHAR(20)
Review
- id — INT
- user_id — INT — 외래 키 → User.id — NOT NULL
- game_id — INT — 외래 키 → Game.id — NOT NULL
- recommended — BOOLEAN
- review_text — TEXT
- written_at — DATE
- playtime_at_review — INT
Sale
- id — INT
- game_id — INT — 외래 키 → Game.id — NOT NULL
- publisher_id — INT — 외래 키 → Publisher.id — NOT NULL
- discount_rate — DECIMAL(5,2)
- start_date — DATE
- end_date — DATE
Sanction
- id — INT
- user_id — INT — 외래 키 → User.id — NOT NULL
- admin_id — INT — 외래 키 → User.id — NOT NULL
- sanction_type — VARCHAR(20)
- reason — TEXT
- start_date — DATE
- end_date — DATE
Tag
- id — INT
- tag_name — VARCHAR(50) — NOT NULL
User
- id — INT
- account_name — VARCHAR(50) — NOT NULL
- email_address — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- country — VARCHAR(50)
- birth_date — DATE
- join_date — DATE
- account_status — VARCHAR(20)
UserAchievement
- user_id — INT — 외래 키 → User.id — NOT NULL
- achievement_id — INT — 외래 키 → Achievement.id — NOT NULL
- achieved_at — DATETIME
Wishlist
- user_id — INT — 외래 키 → User.id — NOT NULL
- game_id — INT — 외래 키 → Game.id — NOT NULL
- added_at — DATE