SFDB

Tables (7)

movieactors (영화 배우)

  • movieActorsNo (Key) — int — Primary key — NOT NULL
  • actorNm (Key2) — varchar — Primary key — NOT NULL
  • actorEnNm (Field) — varchar
  • actorId (Field2) — varchar

moviearchive (보관함)

  • movieArchiveNo (Key) — int — Primary key — NOT NULL
  • movieId (영화ID) — varchar
  • title (영화제목) — varchar
  • titleOrg (영화원제) — varchar
  • userId (회원아이디) — varchar
  • addDate (추가한날짜) — date
  • userNo (회원번호) — int — Foreign key → user.userNo — NOT NULL
  • userId (회원아이디2) — varchar — Foreign key → user.userId — NOT NULL
  • movieSeq (영화코드2) — varchar — Foreign key → movies.movieSeq — NOT NULL
  • movieNo (Key2) — int — Foreign key → movies.movieNo — NOT NULL

moviecomment (코멘트(댓글))

  • movieCommentNo (Key) — int — Primary key — NOT NULL
  • commentDetail (내용) — varchar
  • spoilerStatus (스포일러 여부) — varchar
  • Field
  • userNo (회원번호) — int — Foreign key → user.userNo — NOT NULL
  • userId (회원아이디) — varchar — Foreign key → user.userId — NOT NULL
  • movieSeq (영화코드) — varchar — Foreign key → movies.movieSeq — NOT NULL
  • movieNo (Key2) — int — Foreign key → movies.movieNo — NOT NULL

moviedirectors (영화 감독)

  • movieDirectorsNo (Key) — int — Primary key — NOT NULL
  • directorId (Key2) — varchar — Primary key — NOT NULL
  • directorNm (Field) — varchar
  • directorEnNm (Field2) — varchar

movies (영화)

  • movieSeq (영화코드) — varchar — Primary key — NOT NULL
  • movieNo (Key) — int — Primary key — NOT NULL
  • movieId (영화ID) — varchar
  • title (영화제목) — varchar
  • titleOrg (영화원제) — varchar
  • prodYear (제작연도) — varchar
  • nation (제작국가) — varchar
  • runtime (상영시간) — int
  • rating (관람등급) — varchar
  • repRlsDate (개봉일) — date
  • directorIds (감독ID) — varchar
  • actorNms (배우명) — varchar
  • plotText (줄거리) — varchar
  • keywords (Field) — varchar
  • poster (Field2) — varchar
  • awards1 (Field3) — varchar
  • movieDirectorsNo (Key2) — int — Foreign key → moviedirectors.movieDirectorsNo — NOT NULL
  • directorId (Key22) — varchar — Foreign key → moviedirectors.directorId — NOT NULL
  • movieActorsNo (Key3) — int — Foreign key → movieactors.movieActorsNo — NOT NULL
  • actorNm (Key23) — varchar — Foreign key → movieactors.actorNm — NOT NULL

ott_existence (OTT 정보)

  • netflix (Field) — tinyint
  • watcha (Field2) — tinyint
  • wavve (Field3) — tinyint
  • tving (Field4) — tinyint
  • disneyplus (Field5) — tinyint
  • movieSeq (영화코드) — varchar — Foreign key → movies.movieSeq — NOT NULL
  • movieNo (Key) — int — Foreign key → movies.movieNo — NOT NULL

user (회원)

  • userNo (회원번호) — int — Primary key — NOT NULL
  • userId (회원아이디) — varchar — Primary key — NOT NULL
  • userPw (회원비밀번호) — varchar
  • userName (회원이름) — varchar
  • userBirth (생년월일) — varchar
  • userEmail (회원이메일) — varchar
  • userProfileImage (회원프로필이미지) — varchar