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