shoppingmall

테이블 (8)

Address

  • address_id — BIGINT UNSIGNED — 기본 키 — NOT NULL
  • member_id — BIGINT UNSIGNED — 외래 키 → 회원.member_id — NOT NULL
  • 주소 (address) — VARCHAR(100)
  • 상세주소 (address_detail) — VARCHAR(100)

Cart

  • cart_id — BIGINT UNSIGNED — 기본 키 — NOT NULL
  • member_id — BIGINT UNSIGNED — 외래 키 → 회원.member_id — NOT NULL

Cart_Product

  • cart_id — BIGINT UNSIGNED — 외래 키 → Cart.cart_id — NOT NULL
  • product_id — BIGINT UNSIGNED — 외래 키 → Product.product_id — NOT NULL
  • quantity — INT uNSIGNED

Order

  • order_id — BIGINT UNSIGNED — 기본 키 — NOT NULL
  • recipient_id — BIGINT UNSIGNED — 외래 키 → 회원.member_id — NOT NULL
  • orderer_id — BIGINT UNSIGNED — 외래 키 → 회원.member_id — NOT NULL
  • payment_id — BIGINT UNSIGNED — 외래 키 → Payment.payment_id — NOT NULL
  • date — DATE
  • price — BIGINT UNSIGNED
  • messege — VARCHAR2(50)
  • company_name — VARCHAR2(10)

Order_Product

  • order_id — BIGINT UNSIGNED — 외래 키 → Order.order_id — NOT NULL
  • product_id — BIGINT UNSIGNED — 외래 키 → Product.product_id — NOT NULL
  • quantity — INT UNSIGNED

Payment

  • payment_id — BIGINT UNSIGNED — 기본 키 — NOT NULL
  • method — VARCHAR2(10)
  • status — VARCHAR2(10)

Product

  • product_id — BIGINT UNSIGNED — 기본 키 — NOT NULL
  • name — VARCHAR2(10)
  • description — VARCHAR2(10)
  • quantity — BIGINT UNSIGNED
  • price — BIGINT UNSIGNED

회원 (Member)

  • member_id — BIGINT UNSIGNED — 기본 키 — NOT NULL
  • username — VARCHAR2(10)
  • password — VARCHAR2(10)
  • family_name — VARCHAR2(10)
  • first_name — VARCHAR2(10)
  • phone — VARCHAR2(20)