OTT Search ERD

Tables (10)

actor

  • actor_id — NUMBER — Primary key — NOT NULL
  • actor_name — VARCHAR2(100) — NOT NULL — 배우이름.

comments

  • comment_id — NUMBER — Primary key — NOT NULL
  • content_id — NUMBER — Foreign key → content.content_id — NOT NULL — 콘텐츠ID
  • user_id — NUMBER — Foreign key → users.user_id — NOT NULL — 회원ID
  • comment_text — VARCHAR2(1000) — NOT NULL — 댓글내용
  • comment_date — DATE — NOT NULL — 댓글작성일
  • is_deleted — CHAR(1) — NOT NULL — 삭제여부.

content

  • content_id — NUMBER — Primary key — NOT NULL
  • user_id — NUMBER — Foreign key → users.user_id — NOT NULL — 회원ID
  • title — VARCHAR2(255) — NOT NULL — 제목.
  • description — VARCHAR2(2000) — NOT NULL — 설명
  • release_date — DATE — NOT NULL — 공개일
  • running_time — NUMBER — NOT NULL — 러닝타임
  • director — VARCHAR2(100) — NOT NULL — 감독
  • rating — VARCHAR2(50) — NOT NULL — 등급
  • likes — NUMBER — NOT NULL — 좋아요
  • hits — NUMBER — NOT NULL — 조회수
  • image_url — VARCHAR2(1000) — NOT NULL — 이미지URL
  • is_deleted — CHAR(1) — NOT NULL — 삭제여부.
  • created_date — DATE — NOT NULL — 작성일

content_actor

  • content_id — NUMBER — Foreign key → content.content_id — NOT NULL
  • actor_id — NUMBER — Foreign key → actor.actor_id — NOT NULL — 배우ID.

content_genre

  • content_id — NUMBER — Foreign key → content.content_id — NOT NULL
  • genre_id — NUMBER — Foreign key → genre.genre_id — NOT NULL — 장르ID.

content_ott

  • content_id — NUMBER — Foreign key → content.content_id — NOT NULL
  • ott_id — NUMBER — Foreign key → ott.ott_id — NOT NULL — OTT_ID.

genre

  • genre_id — NUMBER — Primary key — NOT NULL
  • genre_name — VARCHAR2(100) — NOT NULL — 장르이름.

like_table

  • like_id — NUMBER — Primary key — NOT NULL
  • content_id — NUMBER — Foreign key → content.content_id — NOT NULL — 콘텐츠ID.
  • user_id — NUMBER — Foreign key → users.user_id — NOT NULL — 회원ID.

ott

  • ott_id — NUMBER — Primary key — NOT NULL
  • ott_name — VARCHAR2(100) — NOT NULL — OTT이름.

users

  • user_id — NUMBER — Primary key — NOT NULL
  • email — VARCHAR2(255) — NOT NULL — 이메일.
  • user_name — VARCHAR2(100) — NOT NULL — 이름
  • nickname — VARCHAR2(100) — NOT NULL — 닉네임.
  • password — VARCHAR2(255) — NOT NULL — 비밀번호
  • phone_number — VARCHAR2(20) — NOT NULL — 핸드폰번호.
  • birth_date — DATE — NOT NULL — 생년월일
  • signup_date — DATE — NOT NULL — 가입일
  • user_role — VARCHAR2(50) — NOT NULL — 회원권한.
  • is_deleted — CHAR(1) — NOT NULL — 탈퇴여부.