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