test

Tables (4)

order (주문)

  • id (order_id) — bigint — Primary key — NOT NULL
  • 유저아이디 (user_id) — bigint — Foreign key → user.id — NOT NULL

order-product (상품-주문)

  • id (order_product_id) — bigint — Primary key — NOT NULL
  • 상품아이디 (product_id) — bigint — Foreign key → product.id — NOT NULL
  • 주문아이디 (order_id) — bigint — Foreign key → order.id — NOT NULL
  • 주문일 (order_date) — datetime

product (상품)

  • id (product_id) — bigint — Primary key — NOT NULL
  • 상품이름 (name) — varchar
  • 가격 (price) — integer

user (유저)

  • id (user_id) — bigint — Primary key — NOT NULL
  • 이름 (name) — varchar
  • 주소 (address) — varchar
  • 생년월일 (birth) — varchar