databaseEDR2

Tables (10)

Contents

  • content_id — bigint(20) — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • con_info — VARCHAR(255)
  • con_type — enum('movie', 'series') — NOT NULL
  • movie_playtime — bigint(20) — con_type이 movie일 경우

Episode

  • seasons_id — bigint(20) — Primary key — NOT NULL
  • episode_number — bigint(20) — NOT NULL
  • title — VARCHAR(20) — NOT NULL
  • epi_info — VARCHAR(255) — NOT NULL
  • playtime — bigint(20) — NOT NULL

Payment

  • payment_id — bigint(20) — Primary key — NOT NULL
  • payment — enum('card', 'debit', 'phone', 'kakaopay') — NOT NULL
  • payment_status — enum('pending', 'completed', 'failed') — NOT NULL
  • amount (Total) — bigint(20) — NOT NULL — 실제 결제된 금액
  • payment_date — datetime — NOT NULL — 결제 승인 시각

Plans

  • plan_id — enum('basic', 'standard', 'premium') — Primary key — NOT NULL
  • plan_name — enum('베이직', '스탠다드', '프리미엄') — NOT NULL
  • price — bigint(20) — NOT NULL
  • max_profile_count — int — NOT NULL — 요금제별 최대 프로필 생성 개수

Profiles

  • profile_id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → User.user_id — NOT NULL
  • profile_name — VARCHAR(20) — NOT NULL

Seasons

  • seasons_id — bigint(20) — Primary key — NOT NULL
  • content_id — bigint(20) — Foreign key → Contents.content_id — NOT NULL
  • season_number — bigint(20) — NOT NULL
  • title — VARCHAR(20) — NOT NULL
  • seas_info — VARCHAR(255) — NOT NULL

User

  • user_id — bigint(20) — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • passwd — VARCHAR(255) — NOT NULL

UserSubscription

  • subscription_id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → User.user_id — NOT NULL
  • plan_id — enum('basic', 'standard', 'premium') — Foreign key → Plans.plan_id — NOT NULL
  • payment_id — bigint(20) — Foreign key → Payment.payment_id — NOT NULL — 이 구독을 위한 결제 내역
  • start_date — datetime — NOT NULL
  • end_date — datetime — NOT NULL — 구독 종료(만료)일

Watch

  • history_id (Key) — bigint(20) — Primary key — NOT NULL
  • profile_id — bigint(20) — Foreign key → Profiles.profile_id — NOT NULL
  • content_id — bigint(20) — Foreign key → Contents.content_id — NOT NULL — 시리즈/영화 구분 없이 시청한 콘텐츠
  • episode_id — bigint(20) — Foreign key — 시리즈인 경우, 영화는 NULL
  • last_playtime — bigint(20) — NOT NULL
  • last_watched — datetime — NOT NULL

Wishlist

  • Key (Wish_id) — bigint(20) — Primary key — NOT NULL
  • content_id — bigint(20) — Foreign key → Contents.content_id — NOT NULL
  • profile_id — bigint(20) — Foreign key → Profiles.profile_id — NOT NULL