movie_resort

Tables (5)

movie

  • movie_id — NUMBER — Primary key
  • title — VARCHAR2(255) — NOT NULL
  • genre — VARCHAR2(50)
  • release_date — DATE
  • director — VARCHAR2(50)
  • reg_date — DATE — NOT NULL

movie_user

  • user_id — VARCHAR2(50) — Primary key
  • password — VARCHAR2(100) — NOT NULL
  • nickname — VARCHAR2(50) — NOT NULL
  • join_date — DATE — NOT NULL

review

  • review_id — NUMBER — Primary key
  • rating — NUMBER(1)
  • comment — CLOB — NOT NULL — LOB NOT NUL
  • review_date — DATE — NOT NULL
  • movie_id (movie_id2) — NUMBER — Foreign key → movie.movie_id
  • user_id (user_id2) — VARCHAR2(50) — Foreign key → movie_user.user_id

review_comment

  • comment_id — NUMBER — Primary key
  • content — CLOB — NOT NULL
  • comment_date — DATE — NOT NULL
  • user_id — VARCHAR2(50) — NOT NULL
  • review_id (review_id2) — NUMBER — Foreign key → review.review_id

review_like

  • like_id — NUMBER — Primary key
  • like_date — DATE — NOT NULL
  • user_id — VARCHAR2(50) — NOT NULL
  • review_id (review_id2) — NUMBER — Foreign key → review.review_id