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