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