ff

Tables (8)

COMMENTS

  • comment_id — NUMBER(10)
  • content_id — NUMBER(10) — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • comment_text — VARCHAR2(2000) — NOT NULL
  • creation_date — DATE

CONTENTS

  • content_id — NUMBER(10)
  • content_type — VARCHAR2(10) — NOT NULL — 컨텐츠
  • title — VARCHAR2(255) — NOT NULL — 제목
  • description — CLOB — 설명
  • release_date — DATE — 개봉일
  • genre — VARCHAR2(50) — 장르
  • director — VARCHAR2(100) — 감독
  • cast_actors — VARCHAR2(1000) — 출연진

CONTENT_CREDITS

  • credit_id — NUMBER(10)
  • content_id — NUMBER(10) — NOT NULL
  • person_id — NUMBER(10) — NOT NULL
  • role_type — VARCHAR2(20) — NOT NULL
  • role_name — VARCHAR2(100) — 배역

NOTICES

  • notice_id — NUMBER(10)
  • admin_id — NUMBER(10) — NOT NULL
  • title — VARCHAR2(255) — NOT NULL
  • content — CLOB — NOT NULL
  • creation_date — DATE
  • view_count — NUMBER(10)

PERSONS

  • person_id — NUMBER(10)
  • name — VARCHAR2(100) — NOT NULL — 인물
  • birth_date — DATE — 출생일
  • biography — CLOB — 인물
  • profile_image_url — VARCHAR2(1000) — 프로필

REVIEWS

  • review_id — NUMBER(10)
  • content_id — NUMBER(10) — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • rating — NUMBER(2,1) — NOT NULL
  • review_text — VARCHAR2(4000)
  • creation_date — DATE

USERS

  • user_id — NUMBER(10)
  • username — VARCHAR2(50) — NOT NULL — 로그인
  • password — VARCHAR2(255) — NOT NULL — 암호화된
  • email — VARCHAR2(100) — NOT NULL — 이메일
  • user_role — VARCHAR2(20) — NOT NULL — 사용자
  • registration_date — DATE — 가입일

WISHLIST

  • wishlist_id — NUMBER(10)
  • user_id — NUMBER(10) — NOT NULL
  • content_id — NUMBER(10) — NOT NULL
  • added_date — DATE