order

Tables (6)

member (회원)

  • 회원ID (id) — BIGINT — Primary key — NOT NULL
  • 이름 (name)
  • 이메일 (email) — VARCHAR(100) — NOT NULL
  • 패스워드 (password) — VARCHAR(100) — NOT NULL
  • 역할 (role) — enum('user','seller') — NOT NULL

order_details (주문상세)

  • 주문상세ID (id) — BIGINT — Primary key — NOT NULL
  • 주문ID (orders_id) — BIGINT — Foreign key → orders.주문ID — NOT NULL
  • 상품ID (product_id) — BIGINT — Foreign key → product.상품ID — NOT NULL
  • 주문수량 (order_num) — BIGINT — NOT NULL

orders (주문)

  • 주문ID (id) — BIGINT — Primary key — NOT NULL
  • 회원ID (memeber_id) — BIGINT — Foreign key → member.회원ID — NOT NULL
  • 주문생성일자 (order_date) — VARCHAR(100)

product (상품)

  • 상품ID (id) — BIGINT — Primary key — NOT NULL
  • 회원ID (member_id) — BIGINT — Foreign key → member.회원ID — NOT NULL
  • 상품명 (product_name) — VARCHAR(100)
  • 상품가격 (product_price) — BIGINT
  • 상품재고 (product_save) — BIGINT

seller (판매자)

  • Key — Primary key — NOT NULL
  • 회원ID (id) — BIGINT — Foreign key → member.회원ID — NOT NULL
  • Field

user (사용자)

  • Key — Primary key — NOT NULL
  • 회원ID (id) — BIGINT — Foreign key → member.회원ID — NOT NULL
  • Field