Online-mall

Tables (7)

Copy Of Untitled (주문상세 OrderDetail)

  • Key (id) — Primary key — NOT NULL
  • Field2 (quantity)
  • Field6 — (Order과 매핑되서 중간테이블 생성)
  • Key (id_ORDERS) — Foreign key → Untitled.Key — NOT NULL
  • product_id (id_PRODUCT) — Foreign key → product.product_id — NOT NULL

Untitled (loginHistory)

  • Key (id) — Primary key — NOT NULL
  • Field (userId)
  • Field2 (lastLoginTime)
  • Field3 (ClientIp)
  • Field4 (userAgent)

Untitled (주문 Orders)

  • Key (id) — Primary key — NOT NULL
  • Key (id_CART) — Long — Foreign key → Untitled2.Key — 없어도 주문 가능
  • Field3 (totalPrice) — 총 주문 금액
  • Field4 (orderDate) — 주문일
  • Field5 (recipientName)
  • Field6 (recipientPhone)
  • Field3 (recipientZipcode) — 수령인
  • Field7 (recipientAddress)
  • Field4 (recipientAddeDetail)
  • Field
  • Field (id_MEMBER) — Foreign key → member.Field — NOT NULL

Untitled2 (장바구니 Cart)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (product)
  • Field2 (member)
  • Field (quantity)

coupon (쿠폰 Coupon)

  • Key (id) — Primary key — NOT NULL
  • Field (member)
  • Field2 (couponType)
  • Field (couponRegDt) — 등록일
  • Field2 (couponExpirationDt)

member (회원 Member)

  • Field (id) — Primary key — NOT NULL
  • Field3 (userId)
  • Field (userName)
  • Field2 (phone) — varchar(25) — NOT NULL
  • Field (password) — NOT NULL
  • Field (point) — INT
  • Field (zipcode)
  • Field (addr) — NOT NULL
  • Field10 (addrDetail)
  • Field2 (user_grade) — NOT NULL — lv1, 2, 3, 4, 5 - 누적 구매액
  • Field2 (user_register_date) — NOT NULL
  • Field5 (reg_dt)
  • Field6 (adminYN)
  • Field7 (userStatus)
  • Field (lastLoginTime)
  • Field3 (emailAuthYn)
  • Field5 (emailAuthDt)
  • Field6 (emailAuthKey)
  • Field7 (resetPasswordKey)
  • Field9 (resetPasswordLimitDt)
  • Field
  • Field2
  • Key (couponId) — Foreign key → coupon.Key — NOT NULL
  • Key (id2) — Long — Foreign key → Untitled2.Key — NOT NULL

product (Product 상품)

  • product_id (id) — Primary key — NOT NULL
  • Field2 (productName) — 상품명
  • Field (price) — 상품 가격
  • Field3 (soldOutYN) — BOOLEAN — NOT NULL — 품절 여부
  • Field4 (productImg) — 상품 사진
  • Field5 (category)
  • Field (productQuantity)
  • Field2 (stockedDt)
  • Field
  • Key (id2) — Long — Foreign key → Untitled2.Key — NOT NULL