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