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