spw erd

Tables (9)

Inventory (inventory)

  • 재고id (inventory_id) — int(20) — Primary key — NOT NULL
  • 상품 (product_id) — int(20) — Foreign key → Product.상품 — NOT NULL
  • 수량 (stock_quantity) — int

InventoryHistory (inventoryhistory)

  • 재고상태id (history_id) — int(20) — Primary key — NOT NULL
  • 입고출고구분 (in_and_out)
  • 재고id (inventory_id) — int(20) — Foreign key → Inventory.재고id — NOT NULL
  • 입출고수량 (in_out_quantity) — int
  • 입출고날짜 (in_out_date) — timestamp

Order (order)

  • 주문 id (order_id) — int(10) — Primary key — NOT NULL
  • 주문상태 (order_status) — varchar(30) — NOT NULL — PENDING, CONFIRMED, COMPLETED, CANCELLED
  • 주문 갯수 (total_price) — int(100) — NOT NULL
  • 배송날짜 (delivery_date) — timestamp — NOT NULL
  • 배송상태 (delivery_status) — varchar(30) — NOT NULL — PENDING, SHIPPING, DELIVERED
  • 주문 생성시간 (created_at) — timestamp
  • 사용자id (userid) — Foreign key → User.사용자id — NOT NULL

OrderStatusHistory (orderstatushistory)

  • 주문상태id (status_id) — int(20) — Primary key — NOT NULL
  • 주문 id (order_id) — int(10) — Foreign key → Order.주문 id — NOT NULL
  • 상태 (status)
  • 변경시간 (changed_at) — timestamp

Order_Item (order_item)

  • 주문 아이템 id (order_item_id) — int(20) — Primary key — NOT NULL
  • 주문 id (order_id) — int(10) — Foreign key → Order.주문 id — NOT NULL
  • 상품 (product_id) — int(20) — Foreign key → Product.상품 — NOT NULL
  • 수량 (quantity) — int
  • 가격 (price) — int

Product (product)

  • 상품 (product_id) — int(20) — Primary key — NOT NULL
  • 이름 (name) — varchar(30) — NOT NULL
  • 가격 (price) — int
  • 카테고리 (category)

ReturnExchange (returnexchange)

  • 취소id (return_id) — Primary key — NOT NULL
  • 주문 id (order_id) — int(10) — Foreign key → Order.주문 id — NOT NULL
  • 주문 아이템 id (order_item_id) — int(20) — Foreign key → Order_Item.주문 아이템 id — NOT NULL
  • 타입 (type)
  • Field (reason)
  • 생성시간 (created_at) — timestamp

User (user)

  • 사용자id (userid) — Primary key — NOT NULL
  • 이메일 (email) — varchar(20)
  • 이름 (name) — varchar(10)
  • 생성시간 (created_at) — timestamp

payment

  • 결제 id (pay_id) — int(20) — Primary key — NOT NULL
  • 결제일자 (pay_date) — timestamp — NOT NULL
  • 결제 생성시간 (pay_cretime) — timestamp — NOT NULL
  • 결제 상태 (pay_status) — varchar(20) — NOT NULL
  • 주문 id (order_id) — int(10) — Foreign key → Order.주문 id — NOT NULL