백엔드

테이블 (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