week2
Tables (8)
Untitled (category)
- Key (category_id) — BIGINT — Primary key — NOT NULL
- Field (name) — VARCHAR(50) — NOT NULL
Untitled (book)
- Key (book_id) — BIGINT — Primary key — NOT NULL
- Field (title) — VARCHAR(100) — NOT NULL
- Field (description) — TEXT
- Field (created_at) — DATETIME — NOT NULL
- Key (category_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (rental)
- Key (rental_id) — BIGINT — Primary key — NOT NULL
- Field (rented_at) — DATETIME — NOT NULL
- Field (due_at) — DATETIME — NOT NULL
- Field (returned_at) — DATETIME
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- Key (book_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (hashtag)
- Key (hashtag_id) — BIGINT — Primary key — NOT NULL
- Field (name) — VARCHAR(30) — NOT NULL
Untitled (book_hashtag)
- Key (book_hashtag_id) — BIGINT — Primary key — NOT NULL
- Key (book_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (hashtag_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (book_like)
- Key (book_like_id) — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- Key (book_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (notification_allow_list)
- Key (notification_allow_list_id) — BIGINT — Primary key — NOT NULL
- Field (is_allow_notice) — BOOLEAN — NOT NULL
- Field (is_allow_book_return) — BOOLEAN — NOT NULL
- Field (is_allow_marketing) — BOOLEAN — NOT NULL
user
- user_id — BIGINT — Primary key — NOT NULL
- Field (kakao_id) — VARCHAR(100) — NOT NULL
- Field (name) — VARCHAR(100) — NOT NULL
- Field (nickname) — VARCHAR(100) — NOT NULL
- Field (phone) — VARCHAR(20) — NOT NULL
- Field (gender) — VARCHAR(10) — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
- Field (deleted_at) — DATETIME
- Key (notification_allow_list_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL