[Dev-team4] - ecommerce_system

Tables (8)

Deliver_Address (배송 주소)

  • Key (delivery_address_id) — BIGINT — Primary key — NOT NULL — 배송주소ID
  • user_id — BIGINT — Foreign key → Users.user_id — NOT NULL — 회원ID
  • Field (address) — VARCHAR(50) — NOT NULL — 주소
  • Field (is_configured) — Boolean — NOT NULL — 상태
  • Field (coordinate) — POINT — NOT NULL — 좌표

Basket_Product (장바구니 상품)

  • user_id — BIGINT — Foreign key → Users.user_id — NOT NULL — 회원ID
  • product_id — BIGINT — Foreign key → Products.product_id — NOT NULL — 상품ID
  • Field (quantity) — INT — NOT NULL — 수량

Delivery (배송)

  • Key (delivery_id) — BIGINT — Primary key — NOT NULL — 배송ID
  • Key (delivery_address_id) — BIGINT — Foreign key → Deliver_Address.Key — NOT NULL — 배송주소ID
  • order_id — BIGINT — Foreign key → Orders.order_id — NOT NULL — 주문ID

Orders (주문)

  • order_id — BIGINT — Primary key — NOT NULL — 주문ID
  • user_id — BIGINT — Foreign key → Users.user_id — NOT NULL — 회원ID
  • order_detail — VARCHAR(100) — NOT NULL — 주문 요청사항
  • total_price — INT — NOT NULL — 총 합계
  • order_status — ENUM — NOT NULL — 주문 상태(주문중..)
  • created_at — DATETIME — NOT NULL — 생성 날짜

Products (상품)

  • product_id — BIGINT — Primary key — NOT NULL — 상품ID
  • name — varchar(20) — NOT NULL — 상품 이름
  • price — INT — NOT NULL — 상품 가격
  • quantity — INT — NOT NULL — 재고
  • created_at — DATETIME — NOT NULL — 생성 날짜

Refund (환불)

  • Key (refund_id) — BIGINT — Primary key — NOT NULL — 환불ID
  • order_id — BIGINT — Foreign key → Orders.order_id — NOT NULL — 주문ID
  • Field (refund_reason) — VARCHAR(100) — NOT NULL — 환불사유

Users (회원)

  • user_id — BIGINT — Primary key — NOT NULL — 회원ID
  • name — VARCHAR(20) — NOT NULL — 이름
  • email — VARCHAR(20) — NOT NULL — 이메일
  • password — VARCHAR(20) — NOT NULL — 비밀번호
  • phone_num — VARCHAR(20) — NOT NULL — 휴대폰 번호
  • created_at — DATETIME — NOT NULL — 생성 날짜
  • Field (is_admin) — BOOLEAN — NOT NULL — 관리자

order_item (주문 상품)

  • order_id — BIGINT — Foreign key → Orders.order_id — NOT NULL — 주문ID
  • product_id — BIGINT — Foreign key → Products.product_id — NOT NULL — 상품ID
  • Field (quantity) — INT — NOT NULL — 주문 수량