A

Tables (9)

delivery (배송)

  • no (주문번호) — NOT NULL — Foreign key → order_group.no — NOT NULL
  • name (수취인명) — NOT NULL
  • phone_number (수취인 전화번호) — NOTNULL
  • address (배송지 주소) — NOT NULL
  • memo (배송관련메모) — NULL

delivery_detail (Untitled)

  • no (배송번호) — NOT NULL — Primary key — NOT NULL
  • no (주문상품번호) — NOT NULL — Foreign key → order.no — NOT NULL
  • no (주문번호) — NOT NULL — Foreign key → delivery.no — NOT NULL
  • status(출고/배송중/도착) (배송상태) — NOT NULL
  • departed (출고일자) — NULL
  • arrived (도착예정일자) — NULL

order (주문의 개별 상품)

  • no (주문상품번호) — NOT NULL — Primary key — NOT NULL
  • no (주문번호) — NOT NULL — Foreign key → order_group.no — NOT NULL
  • no (상품번호) — NOT NULL — Foreign key → product.no — NOT NULL
  • product_quantity (상품수량) — NOT NULL
  • color (주문색상) — NOT NULL

order_group (총주문)

  • no (주문번호) — NOT NULL — Primary key — NOT NULL
  • no (회원번호) — NOT NULL — Foreign key → user.no — NOT NULL
  • datetime (주문일자) — NOT NULL
  • total_price (총 주문금액) — NOT NULL

payment (결제)

  • no (결제번호) — NOT NULL — Primary key — NOT NULL
  • no (주문번호) — NOT NULL — Foreign key → order_group.no — NOT NULL
  • method (결제방식) — NOT NULL
  • nstallment (할부여부) — NOT NULL
  • discount_amount (할인금액) — NULL
  • total_price (총 결제금액) — NOT NULL

product (상품)

  • no (상품번호) — NOT NULL — Primary key — NOT NULL
  • name (상품명) — NOT NULL
  • category (상품카테고리) — NOT NULL
  • status (상품상태(여유/품절임박/품절)) — NOT NULL
  • Inventory_amount (상품 재고량) — NOT NULL
  • color (상품색상) — NULL
  • introduction (상품소개) — NOT NULL
  • model (상품모델) — NOT NULL
  • image (상품이미지) — NOT NULL

refund (환불)

  • no (환불번호) — NOT NULL — Primary key — NOT NULL
  • no (주문번호) — NOT NULL — Foreign key → order.no — NOT NULL
  • no (상품번호) — NOT NULL — Foreign key → order.no — NOT NULL
  • reason (환불사유) — NOT NULL
  • image (환불사유 이미지) — NOT NULL
  • datetime (환불 접수날짜) — NOT NULL

review (리뷰)

  • no (리뷰번호) — NOT NULL — Primary key — NOT NULL
  • product_no (상품번호) — NOT NULL — Foreign key → product.no — NOT NULL
  • title (제목) — NOT NULL
  • content (내용) — NOT NULL
  • gpa (평점) — NOT NULL
  • imgae (리뷰이미지) — NOT NULL

user (고객)

  • no (회원번호) — NOT NULL — Primary key — NOT NULL
  • name (회원이름) — NOT NULL
  • id (회원아이디) — NOT NULL
  • password (회원비밀번호) — NOT NULL
  • email (이메일) — NOT NULL
  • phone_number (전화번호) — NOTNULL
  • address (주소) — NOT NULL
  • birth (생년월일) — NOTNULL
  • rating (회원등급) — NOT NULL
  • point (포인트) — NOT NULL
  • generation_date (생성일자) — NOT NULL