database_assignment

Tables (11)

admin (어드민)

  • admin_id (관리자 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Primary key — NOT NULL
  • email (관리자 이메일) — VARCHAR(100)
  • password (비밀번호) — VARCHAR(255)

admin_log (어드민 로그)

  • log_id (로그 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Primary key — NOT NULL
  • action_type (작업 유형) — VARCHAR(20)
  • target_id (대상 ID) — INT
  • target_type (대상 유형) — VARCHAR(20)
  • timestamp (작업 시간) — DATETIME
  • admin_id (관리자 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → admin.admin_id — NOT NULL

content (콘텐츠)

  • content_id (콘텐츠 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Primary key — NOT NULL
  • title (제목) — VARCHAR(200)
  • desctiption (줄거리) — TEXT
  • release_year (연도) — YEAR (INT)
  • country (국가) — VARCHAR(50)
  • rating (연령 등급) — VARCHAR(10)
  • poster_url (이미지) — VARCHAR(255)
  • trailer_url (예고편) — VARCHAR(255)

content_genre (콘텐츠 장르)

  • content_id (콘텐츠 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → content_type.content_id — NOT NULL
  • genre_id (장르 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → genre.genre_id — NOT NULL

content_type (콘텐츠 종류)

  • content_id (콘텐츠 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → content.content_id — NOT NULL
  • type_name (콘텐츠 유형) — VARCHAR(30)

favorite (즐겨찾기)

  • favorite_id (찜 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Primary key — NOT NULL
  • added_at (찜한 시점) — DATETIME
  • user_id (사용자 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → user.user_id — NOT NULL
  • content_id (콘텐츠 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → content.content_id — NOT NULL

genre (장르)

  • genre_id (장르 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Primary key — NOT NULL
  • gerne_name (장르명) — VARCHAR(30)

popular_content (인기 컨텐츠)

  • content_id (콘텐츠 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → content.content_id — NOT NULL
  • region (지역) — VARCHAR(30) (예: Korea, Global)
  • ranking (순위) — TINYINT
  • recorded_at (기준 날짜) — DATE

rating (평점)

  • rating_id (평가 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Primary key — NOT NULL
  • score (1 ~ 5 평점) — TINYINY
  • comment (코멘트) — TEXT
  • rated_at (평가 일자) — DATETIME
  • user_id (사용자 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → user.user_id — NOT NULL
  • content_id (콘텐츠 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → content.content_id — NOT NULL

user (유저 테이블)

  • user_id (사용자 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Primary key — NOT NULL
  • email (로그인 이메일) — VARCHAR(100)
  • password (비밀번호) — VARCHAR(255)
  • nickname (사용자 이름) — VARCHAR(50)
  • created_at (가입일) — DATETIME
  • last_login_at (마지막 로그인 시각) — DATETIME

viewing_history (시청 기록)

  • view_id (시청 기록 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Primary key — NOT NULL
  • watched_duration (마지막 시청 시간 (초 단위)) — INT
  • last_watched_at (마지막 시청 날짜) — DATETIME
  • user_id (사용자 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → user.user_id — NOT NULL
  • content_id (콘텐츠 ID) — INT (AUTO_INCREMENT, PRIMARY KEY) — Foreign key → content.content_id — NOT NULL