e-commerce

Tables (8)

couPon (쿠폰)

  • couponid (Key) — Primary key — NOT NULL
  • discount (Field)
  • couponName (Field3)
  • startAt (Field4)
  • endAt (Field5)
  • quantity (Field2)

order (주문)

  • orderId (Key) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → user.userId — NOT NULL
  • orderedAt (Field2)
  • totalAmount (Field3)
  • status (Field4)

orderItemOrder (주문상세)

  • orderItemId (Key) — Primary key — NOT NULL
  • orderId (Key2) — Foreign key → order.orderId — NOT NULL
  • userId (Key22) — Foreign key → order.userId — NOT NULL
  • productId (Key3) — Foreign key → product.productId — NOT NULL
  • quantity (Field3)
  • unitPrice (Field4)

point (유저포인트)

  • pointId (Key2) — Primary key — NOT NULL
  • userId (Key3) — Foreign key → user.userId — NOT NULL
  • point (Field)
  • updateAt (Field2)

product (상품)

  • productId (Key) — Primary key — NOT NULL
  • name (Field)
  • size (Field2)
  • price (Field3)
  • Quantity (Field4)

user (유저)

  • userId (Key) — Primary key — NOT NULL

userCoupon (유저쿠폰)

  • userCouponId (Key) — Primary key — NOT NULL
  • userId (Key3) — Foreign key → user.userId — NOT NULL
  • couponid (Key4) — Foreign key → couPon.couponid — NOT NULL
  • startAt (Field)
  • usageAt (Field2)
  • status (Field3)
  • couponName (Field4)
  • expirationAt (Field5)

userPointHistory (유저포인트내역)

  • historyId (Key2) — Primary key — NOT NULL
  • pointId (Key22) — Foreign key → point.pointId — NOT NULL
  • userId (Key3) — Foreign key → point.userId — NOT NULL
  • point (Field2)
  • type (Field3)