[7주차] - [9기] 타입스크립트로 함께하는 웹 풀 사이클 개발(React, Node.js) 10회차 - 33

  id int [pk, increment]
  address varchar
  receiver varchar
  contact varchar
}

Table orders {
  id int [pk, increment]
  delivery_id int
  book_tile varchar
  total_quantity int
  total_price int
  created_at timestamp
}

Table orderedBook {
  id int [pk, increment]
  order_id int
  book_id int
  quantity int
}

Ref: books.category_id > category.category_id

Ref: cartItems.user_id > users.id

Ref: cartItems.book_id > books.id

Ref: likes.user_id > users.id

Ref: likes.liked_book_id > books.id

Ref: orders.delivery_id > delivery.id

Ref: orderedBook.order_id > orders.id

Ref: orderedBook.book_id > books.id

// 주문하기
// 배송 정보 입력
INSERT INTO delivery (address, receiver, contact)
VALUES ("서울시 중구", "김승아", "010-1234-5678");

const delivery_id = SELECT max(id) FROM delivery;

// 주문 정보 입력
INSERT INTO orders (book_title, total_quantity, total_price, user_id, delivery_id)
VALUES ("어린왕자들", 3, 60000, 1, delivery_id);

const order_id = SELECT max(id) FROM orders;


// 주문 상세 목록 입력
INSERT INTO orderedBook (order_id, book_id, quantity)
VALUES (order_id, 1, 1);

INSERT INTO orderedBook (order_id, book_id, quantity)
VALUES (order_id, 3, 2);

SELECT max(id) FROM Bookshop.orderedBook;
SELECT last_insert_id();