MovieTmp

Tables (16)

Community

  • Key (communityID) — Long — Primary key — NOT NULL
  • Key (memberID) — Long — Foreign key → Member.Key — NOT NULL
  • Key (contentsID) — Long — Foreign key → Contents.Key — NOT NULL
  • Field (title) — Long — NOT NULL
  • Field (post) — String — NOT NULL

Contents

  • Key (contentsID) — bigint — Primary key — NOT NULL
  • Field (title) — Varchar — NOT NULL
  • Field2 (actor) — Varchar — NOT NULL
  • Field3 (description) — varcha — NOT NULL
  • Field (sumOfstarPoint) — int — NOT NULL
  • Field (reviewCounts) — double

ContentsGenre

  • Key — Primary key — NOT NULL
  • Key (contentsID) — Long — Foreign key → Contents.Key — NOT NULL
  • Key (genreID) — Long — Foreign key → Genre.Key — NOT NULL

ContentsOTT

  • Key (contentOTTID) — Long — Primary key — NOT NULL
  • Key (ottID) — Long — Foreign key → OTT.Key — NOT NULL
  • Key (contentsID) — bigint — Foreign key → Contents.Key — NOT NULL

Genre

  • Key (genreID) — Long — Primary key — NOT NULL
  • Field (name) — String — NOT NULL

JJIM

  • Key (jjImID) — bigINT — Primary key — NOT NULL
  • Key (memberID) — bigint — Foreign key → Member.Key — NOT NULL
  • Key (contentsID) — bigint — Foreign key → Contents.Key — NOT NULL

LikeReview

  • Key (LikeReviewID) — Long — Primary key — NOT NULL
  • Key (memberID) — Long — Foreign key → Member.Key — NOT NULL
  • Key (reviewID) — Long — Foreign key → Review.Key — NOT NULL

Member

  • Key (memberID) — Long — Primary key — NOT NULL
  • Field (socialType) — ENUM — google,kakao 등
  • Field (socialId) — String
  • Field (nickName) — String — NOT NULL
  • Field (password) — String
  • Field2 (imgUrl) — String
  • Field (grade) — ENUM — NOT NULL

MemberGenre

  • Key — Primary key — NOT NULL
  • Key (memberID) — Long — Foreign key → Member.Key — NOT NULL
  • Key (genreID) — Long — Foreign key → Genre.Key — NOT NULL

Movie

  • Key — Primary key — NOT NULL
  • Field

OTT

  • Key (ottID) — Long — Primary key — NOT NULL
  • Field (name) — String — NOT NULL

Reply

  • Key (replyID) — Long — Primary key — NOT NULL
  • Key (communityID) — Long — Foreign key → Community.Key — NOT NULL
  • Key (parentID) — Long — Foreign key → Reply.Key
  • Field (post) — String

Review

  • Key (reviewID) — Long — Primary key — NOT NULL
  • Field (goodness) — int
  • Key (memberID) — Long — Foreign key → Member.Key — NOT NULL
  • Key (contentsID) — Long — Foreign key → Contents.Key — NOT NULL
  • Field2 (content) — String — NOT NULL
  • Field2 (title) — String — NOT NULL
  • Field2 (starPoint) — Double — NOT NULL

ReviewGenre

  • Key — Primary key — NOT NULL
  • Key (reviewID) — Long — Foreign key → Review.Key — NOT NULL
  • Key (genreID) — Long — Foreign key → Genre.Key — NOT NULL

SubscribeOTT

  • Key (subscirbeottID) — Long — Primary key — NOT NULL
  • Key (memberID) — Long — Foreign key → Member.Key — NOT NULL
  • Key (ottID2) — Long — Foreign key → OTT.Key — NOT NULL

Tv

  • Key — Primary key — NOT NULL