OraClE_ERD

Tables (4)

Order (주문)

  • orderId (주문아이디) — bigint — Primary key
  • userId (주문자아이디) — bigint
  • orderStatus (주문상태) — varchar
  • paymentType (결제수단) — varchar
  • paymentTotalAmount (결제금액)
  • totalDeliveryFee (총배송비)
  • paymentCompleteAt (주문완료시간)
  • buyerName (구매자이름)
  • buyerPhone (구매자연락처)
  • recieverName (수취인이름)
  • receiverPhone (수취인주소)
  • receiverAddress (수취인연락처)
  • createdAt (생성일시) — timestamp
  • createdBy (생성인) — varchar
  • modifiedAt (변경일시) — timestamp
  • modifiedBy (변경인) — varchar

OrderOption (주문옵션)

  • orderOptionId (주문옵션아이디) — Primary key — NOT NULL
  • orderProductId (주문상품아이디) — Foreign key → OrderProduct.orderProductId — NOT NULL
  • orderOptionStatus (주문옵션상태)
  • name (주문옵션이름)
  • price (가격)
  • quantity (개수)
  • deliveryFee (배송비)
  • deliveryStatus (배송상태)
  • deliveryNumber (운송장번호)
  • cretedAt (생성ㅇ리시) — timestamp
  • createdBy (생성인) — varchar
  • modifiedAt (변경일시) — timestamp
  • modifiedBy (변경인) — varchar

OrderOptionCancel (주문옵션취소)

  • orderOptionCancelId (주문옵션취소아이디) — Primary key — NOT NULL
  • orderOptionId (주문옵션아이디) — Foreign key → OrderOption.orderOptionId — NOT NULL
  • cancelType (취소유형)
  • description (상세사유)
  • quantity (취소개수)
  • amount (취소금액)
  • createdAt (생성일시) — timestamp
  • createdBy (생성인) — varchar
  • modifiedAt (변경일시) — timestamp
  • modifiedBy (변경인) — varchar

OrderProduct (주문상품)

  • orderProductId (주문상품아이디) — Primary key — NOT NULL
  • orderId (주문아이디) — Foreign key → Order.orderId
  • name (상품이름)
  • price (가격)
  • companyId (회사아이디)
  • companyName (회사이름)
  • description (상품설명)
  • createdAt (생성일시) — timestamp
  • createdBy (생성인) — varchar
  • modifiedAt (변경일시) — timestamp
  • modifiedBy (변경인) — varchar