DB 설계

ERD 설계 하면서 API도 부분 수정하였습니다.

1. users ERD

컬럼명	타입
id	int
email	varchar
password	varchar
created_at	timestamp

2. books ERD

컬럼명	타입
id	int
title	varchar
category_id	int
format	varchar
isbn	varchar
summary	text
description	text
author	varchar
pages	int
index	text
price	int
likes	int
pubDate	timestamp

3. likes ERD

컬럼명	타입
user_id	int
liked_book_id	int

4. cart ERD

컬럼명	타입
cart_item_id	int
book_id (FK)	int
count	int

5. delivery ERD

컬럼명	타입
id	int
address	varchar
receiver	int
contact	int

6. order ERD

컬럼명	타입
order_id	int
delivery_id	int
total_price	int
created_at	timestamp
book_title	varchar
total_count	int

7. pay ERD

컬럼명	타입
order_id	int
book_id	int
count	int

---

02/11 테이블 추가 books categoty / varchar -> category_id / int로 변경

8. category ERD

컬럼명	타입
category_id	int
name	varchar

👉🏻 API 설계 확인하기