book-personalize

Tables (5)

book

  • book_id — NOTNULL — Primary key — NOT NULL
  • member_id — NOTNULL — Foreign key → member.member_id — NOT NULL
  • title — NOTNULL
  • author — NOTNULL
  • summary — NOTNULL
  • rating — NOTNULL
  • cover_image — NOTNULL
  • created_at — NOTNULL
  • updated_at — NOTNULL
  • deleted_at — NULL

member

  • member_id — NOTNULL — Primary key — NOT NULL
  • login_id — NOTNULL
  • nickname — NOTNULL
  • icon — NOTNULL
  • role — NOTNULL
  • enabled — NOTNULL
  • created_at — NOTNULL
  • updated_at — NOTNULL
  • deleted_at — NULL

member_favorite

  • member_favorite_id — NOTNULL — Primary key — NOT NULL
  • member_id — NOTNULL — Foreign key → member.member_id — NOT NULL
  • book_id — NOTNULL — Foreign key → book.book_id — NOT NULL
  • created_at — NOTNULL
  • deleted_at — NULL

member_review

  • member_review_id — Primary key — NOT NULL
  • member_id — NOTNULL — Foreign key → member.member_id — NOT NULL
  • book_id — NOTNULL — Foreign key → book.book_id — NOT NULL
  • rating — NOTNULL
  • review — NOTNULL
  • created_at — NOTNULL
  • updated_at — NOTNULL
  • deleted_at — NULL

member_token

  • member_token_id — NOTNULL — Primary key — NOT NULL
  • member_id — NOTNULL — Foreign key → member.member_id — NOT NULL
  • refresh_token — NOTNULL
  • created_at — NOTNULL
  • updated_at — NOTNULL
  • deleted_at — NULL