MovieApp

Tables (6)

Genre (Untitled5)

  • GenreId (장르아이디) — NOT NULL — Primary key — NOT NULL
  • Name (장르 이름) — NOT NULL

Like (Untitled4)

  • LikedId (좋아요아이디) — NOT NULL — Primary key — NOT NULL
  • UserId (사용자아이디) — NOT NULL — Foreign key → User.UserId — NOT NULL
  • NoteId (게시물아이디) — NOT NULL — Foreign key → MovieNote.NoteId — NOT NULL
  • CreateAt (생성일자)

Movie (Untitled3)

  • MovieId (영화아이디) — NOT NULL — Primary key — NOT NULL
  • ApiKey (영화 Api) — NOT NULL
  • Title (영화 제목) — NOT NULL
  • Overview (영화 소개)
  • Poster (영화 포스터URL)
  • ReleaseDate (영화개봉날짜)
  • CreatedAt (생성일자) — NOT NULL

MovieGenre (Untitled6)

  • MovieId (영화아이디) — NOT NULL — Foreign key → Movie.MovieId — NOT NULL
  • GenreId (장르아이디) — NOT NULL — Foreign key → Genre.GenreId — NOT NULL

MovieNote (Untitled2)

  • NoteId (게시물아이디) — NOT NULL — Primary key — NOT NULL
  • Rating (별점) — NOT NULL
  • LikedCount (좋아요수)
  • MovieId (영화아이디) — NOT NULL — Foreign key → Movie.MovieId — NOT NULL
  • UserId (사용자아이디) — NOT NULL — Foreign key → User.UserId — NOT NULL
  • CreatedAt (생성일자) — NOT NULL
  • ModifiedAt (수정일자) — NOT NULL
  • Comment (감상평)

User (Untitled)

  • UserId (사용자아이디) — NOT NULL — Primary key — NOT NULL
  • Name (이름) — NOT NULL
  • Password (비밀번호) — NOT NULL
  • Email (이메일) — NOT NULL
  • CreatedAt (생성일자) — NOT NULL
  • ModifiedAt (수정일자)
  • NoteCount (작성게시물수)
  • LikedCount (좋아요 받은 수)
  • Nickname (닉네임) — NOT NULL