BookSystem

Tables (8)

book

  • book_id — BIGINT — Primary key — NOT NULL
  • title — TEXT — NOT NULL
  • description — TEXT — NOT NULL

book_hashtag

  • book_hashtag_id — BIGINT — Primary key — NOT NULL
  • book_id — BIGINT — Foreign key → book.book_id — NOT NULL
  • hashtag_id — BIGINT — Foreign key → hashtag.hashtag_id — NOT NULL

book_like

  • book_like_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → users.member_id — NOT NULL
  • book_id — BIGINT — Foreign key → book.book_id — NOT NULL

category

  • category_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • book_id — BIGINT — Foreign key → book.book_id — NOT NULL

hashtag

  • hashtag_id — BIGINT — Primary key — NOT NULL
  • title — TEXT — NOT NULL

notification_allow_list

  • notification_allow_list_id — BIGINT — Primary key — NOT NULL
  • is_allow_notice — BOOLEAN — NOT NULL
  • is_allow_book_return — BOOLEAN — NOT NULL
  • is_allow_marketing — BOOLEAN — NOT NULL

rental (rent)

  • rent_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → users.member_id — NOT NULL
  • book_id — BIGINT — Foreign key → book.book_id — NOT NULL

users (member)

  • member_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(5) — NOT NULL
  • nickname — VARCHAR(15) — NOT NULL
  • phone_number — VARCHAR(11) — NOT NULL
  • gender — ENUM('NONE', 'MALE', 'FEMALE') — NOT NULL
  • social_provider — ENUM('LOCAL', 'KAKAO') — NOT NULL
  • social_uid — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP
  • notification_allow_list_id — BIGINT — Foreign key → notification_allow_list.notification_allow_list_id — NOT NULL