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