week01
Tables (8)
BOOK (Untitled2)
- 책ID (book_id) — BIGINT — Primary key
- 제목 (title) — VARCHAR
- 설명 (description) — VARCHAR
- 카테고리ID (category_id) — BIGINT — Foreign key → CATEGORY.카테고리ID
BOOK_HASHTAG (Untitled6)
- 책해시태그ID (book_hashtag_id) — BIGINT — Primary key
- 책ID (book_id) — BIGINT — Foreign key → BOOK.책ID
- 해시태그ID (hashtag_id) — BIGINT — Foreign key → HASHTAG.해시태그ID
BOOK_LIKE (Untitled7)
- 책좋아요ID (book_like_id) — BIGINT — Primary key
- 사용자ID (user_id) — BIGINT — Foreign key → USER.사용자ID
- 책ID (book_id) — BIGINT — Foreign key → BOOK.책ID
CATEGORY (Untitled3)
- 카테고리ID (category_id) — BIGINT — Primary key
- 카테고리명 (category_name) — VARCHAR
HASHTAG (Untitled5)
- 해시태그ID (hashtag_id) — BIGINT — Primary key
- 해시태그명 (hashtag_name) — VARCHAR
NOTIFICATION (Untitled8)
- 알림ID (notification_id) — BIGINT — Primary key
- 알림유형 (type) — VARCHAR
- 알림내용 (content) — VARCHAR
- 알림일시 (created_at) — DATETIME
- 읽음여부 (is_read) — BOOLEAN
- 사용자ID (user_id) — BIGINT — Foreign key → USER.사용자ID
RENTAL (Untitled4)
- 대여ID (rental_id) — BIGINT — Primary key
- 사용자ID (user_id) — BIGINT — Foreign key → USER.사용자ID
- 대여일시 (rented_at) — DATETIME
- 반납예정일시 (due_at) — DATETIME
- 반납일시 (returned_at) — DATETIME
- 책ID (book_id) — BIGINT — Foreign key → BOOK.책ID
USER (Untitled)
- 사용자ID (user_id) — BIGINT — Primary key
- 카카오ID (kakao_id) — VARCHAR
- 이름 (name) — VARCHAR — NOT NULL
- 닉네임 (nickname) — VARCHAR
- 전화번호 (phone) — VARCHAR
- 성별 (gender) — VARCHAR
- 회원상태 (status) — VARCHAR