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