BookRental

Tables (8)

Book

  • id — BIG INT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • categoryId — INT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

BookRental

  • id — BIG INT
  • user_id — BIG INT
  • book_id — BIG INT
  • rentalDate — TIMESTAMP
  • returnDate — TIMESTAMP
  • status — ENUM('Rented', 'Returned', 'Overdue')

Book_Hashtag

  • book_id — BIG INT
  • hashtag_id — INT

Category

  • id — BIG INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL

Hashtag

  • idi (id) — BIG INT — Primary key — NOT NULL
  • tag — VARCHAR(100) — NOT NULL

Notification

  • id — BIG INT — Primary key — NOT NULL
  • user_id — BIG INT — Foreign key → User.id — NOT NULL
  • type — ENUM('Notice', 'Return', 'Marketing') — NOT NULL
  • message — TEXT — NOT NULL
  • createdAt — TIMESTAMP

User

  • id (Key) — BIG INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • gender — ENUM('Male', 'Female') — NOT NULL
  • kakaoId — VARCHAR(100) — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP

User_Like

  • id — BIG INT
  • user_id — INT
  • book_id — INT
  • createdAt — TIMESTAMP