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