Filmory
Tables (10)
COMMENT (한줄평)
- COMMENT_ID (한줄평 ID) — VARCHAR2 — Primary key — NOT NULL
- CONTENT (내용) — VARCHAR2
- CREATE_DATE (작성날짜) — DATE
- UPDATE_DATE (수정날짜) — DATE
- MOVIEW_ID (영화 ID) — VARCHAR2 — Foreign key → MOVIE.MOVIE_ID — NOT NULL
- USER_ID (사용자 ID) — VARCHAR2 — Foreign key → MEMBER.USER_ID — NOT NULL
- LIKE_COUNT (좋아요 개수) — NUMBER
COMMENT_LIKE (한줄평 좋아요)
- (COMMENT_ID , USER_ID) (Key) — Primary key — NOT NULL
- COMMENT_ID (한줄평 ID) — VARCHAR2 — Foreign key → COMMENT.COMMENT_ID — NOT NULL
- USER_ID (작성자 ID) — VARCHAR2
- LIKE_TYPE (좋아요) — boolean
MEMBER (사용자)
- USER_ID (사용자 ID) — VARCHAR2 — Primary key — NOT NULL
- USER_PWD (비밀번호) — VARCHAR2
- EMAIL (이메일) — VARCHAR2
- AGE (나이) — NUMBER
- GENDER (성별) — VARCHAR2
- NICKNAME (별명) — VARCHAR2
- FAVORITE_GENRE (좋아하는 장르) — VARCHAR2
- CREATE_DATE (생성날짜) — DATE
- UPDATE_DATE (수정날짜) — DATE
- PICTURE (프로필사진) — VARCHAR2
- STATUS (상태) — VARCHAR2
MOVIE (영화)
- MOVIE_ID (영화 ID) — NUMBER — Primary key — NOT NULL
- MOVIE_TITLE (영화 제목) — VARCHAR2
- CATEGORY (장르) — 장르
- DIRECTOR (감독) — VARCHAR2
- ADULT (연령) — VARCHAR2
- RELEASE_DATE (개봉일) — DATE
- POPULARITY (인기도) — NUMBER
- RATING_SCORE (평점) — NUMBER
- REIVEW_COUNT (감상문개수) — NUMBER
- LIKE_COUNT (좋아요 개수) — NUMBER
- DISLIKE_COUNT (싫어요 개수) — NUMBER
MOVIE_LIKE (영화 좋아요)
- (MOVIE_ID , USER_ID) (Key) — Primary key — NOT NULL
- MOVIE_ID (영화 ID) — VARCHAR2 — Foreign key → MOVIE.MOVIE_ID — NOT NULL
- USER_ID (사용자 ID) — VARCHAR2 — Foreign key → MEMBER.USER_ID — NOT NULL
- LIKE (좋아요/싫어요) — STRING
NOTE (쪽지)
- NOTE_NO (쪽지ID) — NUMBER — Primary key — NOT NULL
- SEND_ID (발송자' ID) — VARCHAR2 — Foreign key → MEMBER.USER_ID — NOT NULL
- RECEIVE_ID (수신자_ID) — VARCHAR2
- CONTENT (내용) — VARCHAR2
- CREATE_DATE (보낸 날짜) — SYSDATE
- STATUS (삭제여부) — CHAR(1)
RATING (개인 평점)
- RATING_ID (평점) — NUMBER — Primary key — NOT NULL
- COMMENT_ID (한줄평 ID) — VARCHAR2 — Foreign key → COMMENT.COMMENT_ID — NOT NULL
- MOVIE_ID (영화 ID) — VARCHAR2 — Foreign key → MOVIE.MOVIE_ID — NOT NULL
- USER_ID (사용자 ID) — VARCHAR2 — Foreign key → MEMBER.USER_ID — NOT NULL
- SCORE (점수) — NUMBER
- CREATE (생성날짜) — DATE
REVIEW (감상평)
- REVIEW_ID (Key) — VARCHAR2 — Primary key — NOT NULL
- CONTENT (내용) — VARCHAR2
- CREATE_DATE (작성날짜) — DATETIME
- UPDATE_DATE (수정날짜) — DATE
- VIEW_COUNT (조회수) — NUMBER
- LIKE_COUNT (좋아요개수) — NUMBER
- MOVIE_ID (영화ID) — VARCHAR2 — Foreign key → MOVIE.MOVIE_ID — NOT NULL
- USER_ID (사용자ID) — VARCHAR2 — Foreign key → MEMBER.USER_ID — NOT NULL
REVIEW_COMMENT (감상평 댓글)
- COMMENT_ID (댓글 ID) — VARCHAR2 — Primary key — NOT NULL
- CONTENT (내용) — VARCHAR2
- CREATE_DATE (작성날짜) — DATE
- UPDATE_DATE (수정날짜) — DATE
- REVIEW_ID (리뷰 ID) — VARCHAR2 — Foreign key → REVIEW.REVIEW_ID — NOT NULL
- USER_ID (사용자 ID) — VARCHAR2 — Foreign key → MEMBER.USER_ID — NOT NULL
REVIEW_LIKE (감상평 좋아요)
- (REVIEW_ID , USER_ID) (Key) — Primary key — NOT NULL
- REVIEW_ID (감상평 ID) — VARCHAR2 — Foreign key → REVIEW.REVIEW_ID — NOT NULL
- PICTURE (프로필사진) — VARCHAR2 — Foreign key
- LIKE_YN (좋아요) — boolean