e-commerce

Tables (9)

deliverys (배송)

  • id (배송id) — BIGINT — Primary key — NOT NULL
  • order_id (주문id) — BIGINT — Foreign key → orders.id — NOT NULL
  • address (배송지) — VARCHAR
  • phone_number (전화번호) — VARCHAR
  • deliver_status (배송상태) — VARCHAR(준비중, 배송중, 배송 완료,반품)
  • created_at (생성날짜) — TIMESTAMP
  • completed_at (배송 완료 날짜) — TIMESTAMP

orderitems (주문 상품)

  • id (주문상품id) — BIGINT — Primary key — NOT NULL
  • order_id (주문id) — BIGINT — Foreign key → orders.id — NOT NULL
  • product_id (상품id) — BIGINT — Foreign key → products.id — NOT NULL
  • order_quantity (주문 수량) — INT
  • created_at (생성날짜) — TIMESTAMP
  • updated_at (수정날짜) — TIMESTAMP

orders (주문)

  • id (주문id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → users.id — NOT NULL
  • orderer (주문자) — VARCHAR
  • total_price (총 구매금액) — BIGINT
  • status (주문상태) — VARCHAR(주문완료, 주문취소,거래 확정)
  • created_at (생성날짜) — TIMESTAMP
  • updated_at (수정날짜) — TIMESTAMP
  • returnsigned_at (반품신청날짜) — TIMESTAMP

payment (결제)

  • id (결제id) — BIGINT — Primary key — NOT NULL
  • order_id (주문id) — BIGINT — Foreign key → orders.id — NOT NULL
  • payment_method (주문 방법) — VARCHAR(카드, 계좌이체)
  • payment_status (결제 상태) — VARCHAR(결제 대기, 결제 완료, 결제 취소)
  • order_price (주문 금액) — INT
  • delivery_price (배송비) — INT
  • total_payment_price (총 지불 금액) — INT
  • payment_completed_at (결제 완료 날짜) — TIMESTAMP
  • created_at (생성날짜) — TIMESTAMP
  • updated_at (수정날짜) — TIMESTAMP

products (상품)

  • id (상품id) — BIGINT — Primary key — NOT NULL
  • product_name (상품명) — VARCHAR
  • description (상품설명) — VARCHAR
  • category (카테고리) — VARCHAR(TOP, BOTTOM, OUTER, HAT, ACC)
  • price (상품가격) — INT
  • created_at (생성날짜) — TIMESTAMP
  • updated_at (수정날짜) — TIMESTAMP

stock (재고)

  • id (재고id) — BIGINT — Primary key — NOT NULL
  • product_id (상품id) — BIGINT — Foreign key → products.id — NOT NULL
  • quantity (상품 수량) — BIGINT

users (회원)

  • id (회원id) — BIGINT — Primary key — NOT NULL
  • username (이름) — VARCHAR
  • email (이메일주소) — VARCHAR
  • password (비밀번호) — VARCHAR
  • phone_number (전화번호) — VARCHAR(10)
  • address (주소) — VARCHAR
  • created_at (생성날짜) — TIMESTAMP
  • updated_at (수정날짜) — TIMESTAMP
  • emailVerified (이메일 인증 여부) — true, false

wishlist_items (위시리스트 상품)

  • id (장바구니상품id) — BIGINT — Primary key — NOT NULL
  • wishlist_id (위시리스트 id) — BIGINT — Foreign key → wishlists.id — NOT NULL
  • product_id (상품id) — BIGINT — Foreign key → products.id — NOT NULL
  • quantity (위시리스트 삼품 수량) — INT
  • created_at (생성날짜) — TIMESTAMP
  • updated_at (수정날짜) — TIMESTAMP

wishlists (위시리스트)

  • id (장바구니id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → users.id — NOT NULL
  • created_at (생성날짜) — TIMESTAMP
  • updated_at (수정날짜) — TIMESTAMP