order_system

Tables (4)

member (회원)

  • id (Key) — Primary key — NOT NULL
  • email (Field)
  • password (Field2)
  • role (Field3) — emum
  • Field4

order (주문)

  • order_id (Key) — Primary key — NOT NULL
  • Field (주문생성 일자)
  • member_id (Key2) — Foreign key → member.id — NOT NULL

order_details (주문상세)

  • id (Key) — Primary key — NOT NULL
  • order_id (Key2) — Foreign key → order.order_id — NOT NULL
  • product_id (Key3) — Foreign key → product.id — NOT NULL
  • Field (주문수량)

product (상품)

  • id (Key) — Primary key — NOT NULL
  • Field (상품명)
  • Field (상품가격)
  • Field2 (상품제고)
  • member_id (Key2) — Foreign key → member.id — NOT NULL