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 — 탈퇴여부.