dailycal

Tables (3)

Book (book)

  • Book ID (book_id) — int — Primary key — NOT NULL
  • Title (title) — Spring
  • Author (author) — String
  • Published date (published_date) — int
  • Age limit (age_limit) — boolean
  • Available date (available_date) — int
  • User ID (user_id) — String — Foreign key → User ID.User ID

Review of book (review_of_book)

  • Review ID (review_id) — int — Primary key — NOT NULL
  • User ID (user_id2) — String — Foreign key → User ID.User ID
  • Book ID (book_id2) — int — Foreign key → Book.Book ID — NOT NULL
  • Score (score) — int
  • Review (review) — String
  • Book ID (book_id) — int
  • User Id (user_id) — String

User ID (user_id)

  • User ID (user_id) — String — Primary key
  • Birth of date (birth_of_date) — int
  • Nick name (nick_name) — String