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)