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