tmdb

Tables (6)

Content

  • contentUnique — int — Primary key — NOT NULL — 컨텐츠 고유값
  • contentType — String — 컨텐츠 타입
  • contentId — int — 컨텐츠 아이디
  • scoreAvg — double — 별점 평균

ContentLike

  • username — String — Foreign key → Member.username — NOT NULL — 닉네임
  • contentUnique — int — Foreign key → Content.contentUnique — NOT NULL — 컨텐츠 고유값

Member

  • username — String — Primary key — NOT NULL — 닉네임
  • gender — String — 성별
  • password — String — NOT NULL — 비밀번호
  • regidentNumber — int
  • email — email — NOT NULL — 이메일
  • sns — String — sns
  • img — String — 이미지

Reply

  • rno — int — Primary key — NOT NULL — 댓글 번호
  • contentUnique — int — Foreign key → Content.contentUnique — NOT NULL — 컨텐츠 고유값
  • username (username2) — String — Foreign key → Member.username — NOT NULL — 닉네임
  • reply — String — 댓글
  • replyDate — Date — 댓글 등록 날짜
  • Field

ReplyLike

  • rno — int — Foreign key → Reply.rno — NOT NULL — 댓글 번호
  • username — String — Foreign key → Member.username — NOT NULL — 닉네임

star (start)

  • contentUnique — int — Foreign key → Content.contentUnique — NOT NULL — 컨텐츠 고유값
  • username — String — Foreign key → Member.username — NOT NULL — 닉네임
  • score — int — 점수