Blog

Tables (6)

BookReview (책/리뷰)

  • Id (id) — Long — Primary key — NOT NULL
  • Member (member) — Long — Foreign key → Member.id — NOT NULL
  • Thumbnail (thumbnail) — String
  • Title (title) — String
  • Author (author) — String
  • Publisher (publisher) — String
  • Review (review) — String
  • Heart (heartCnt) — Long
  • CreatedAt (createdAt) — LocalDate
  • ModifiedAt (modifiedAt) — LocalDate

Comment

  • id — Long — Primary key — NOT NULL
  • Member (member_id) — Long — Foreign key → Member.id — NOT NULL
  • BookReview (bookReview_id) — Long — Foreign key → BookReview.Id — NOT NULL
  • Content (content) — String
  • CreatedAt (createdAt) — LocalDate
  • ModifiedAt (modifiedAt) — LocalDate

Likes

  • id — Long — Primary key — NOT NULL
  • Member (member_id) — Long — Foreign key → Member.id — NOT NULL
  • BookReview (bookReview_id) — Long — Foreign key → BookReview.Id — NOT NULL

Member

  • id — Long — Primary key — NOT NULL
  • Username (username) — String
  • Password (password) — String
  • CreatedAt (createdAt) — LocalDate
  • ModifiedAt (modifiedat) — LocalDate

Refresh-Token

  • id — Long — Primary key — NOT NULL
  • Member (member_id) — Long — Foreign key → Member.id — NOT NULL
  • value — String
  • CreatedAt (createdAt) — LocalDate
  • ModifiedAt (modifiedAt) — LocalDate

Sub_Comment

  • Id (id) — Long — Primary key — NOT NULL
  • Comment (comment_id) — Long — Foreign key → Comment.id — NOT NULL
  • Member (member_id) — Long — Foreign key → Comment.Member — NOT NULL
  • Content (content) — String
  • CreatedAt (createdAt) — LocalDate
  • ModifiedAt (modifiedAt) — LocalDate