백엔드
테이블 (4)
Book
- book_id (Key) — 기본 키 — NOT NULL
- title
- author
- publisher
- piblication_date (publication_date)
- img_path (price)
- price (image_path)
- category
- description (Field)
Cart
- user_id (Key2) — 외래 키 → User.user_id — NOT NULL
- book_id (Key22) — 외래 키 → Order.user_id — NOT NULL
- user_id (Key) — 외래 키 → Order.book_id — NOT NULL
- order_id (cart_id)
- cart_items
- cart_id (Field)
Order
- user_id (Key2) — 외래 키 → User.user_id — NOT NULL
- book_id (Key) — 외래 키 → Book.book_id — NOT NULL
- order_id
- order_date
- delivery_address
- payment_method
- quantity (Field2)
User
- user_id (Key) — 기본 키 — NOT NULL
- username — String
- password — String
- address — String
- phone — String