Book

Tables (6)

Book (book)

  • 책id (id) — BIGINT — Primary key — NOT NULL
  • 책이름 (title) — varchar(100)
  • 작가 (author) — varchar(45)
  • isbn — varchar(45)
  • 평균별점 (star) — int
  • 표지 (image) — text
  • 줄거리 (plot) — text
  • 출판날짜 (date) — date
  • Field

Book_Comment (book_comment)

  • idi (id) — Bigint — Primary key — NOT NULL
  • 책id (book_id) — BIGINT — Foreign key → Book.책id — NOT NULL
  • 유저id (user_id) — BIGINT — Foreign key → User.유저id — NOT NULL
  • 별점 (star) — int

Book_categories (book_categories)

  • id — BIGINT — Primary key — NOT NULL
  • 카테고리id (category_id) — BIGINT — Foreign key → Category.카테고리id — NOT NULL
  • 책id (book_id) — BIGINT — Foreign key → Book.책id — NOT NULL

Category (category)

  • 카테고리id (category_id) — BIGINT — Primary key — NOT NULL
  • 카테고리이름 (category)

Post (post)

  • postid (id) — BIGINT — Primary key — NOT NULL
  • 제목 (title) — varchar(100)
  • 본문 (content) — text
  • 유저id (id2) — BIGINT — Foreign key → User.유저id — NOT NULL
  • startdate (start_date) — date
  • enddate (end_date) — date
  • 작성날짜 (date) — date
  • Field2

User (user)

  • 유저id (id) — BIGINT — Primary key — NOT NULL
  • 이름 (name) — varchar(45)
  • 이메일 (email) — varchar(50)
  • 비밀번호 (password) — varchar(45)
  • 역할 (role) — varchar(20)
  • 프로필이미지 (image) — text
  • Field