dd

Tables (6)

orders (주문)

  • id (주문 ID) — Primary key — NOT NULL
  • user_id (유저 ID) — Foreign key → users.id — NOT NULL
  • total_price (주문 총 금액)
  • status (주문 상태)
  • created_at (생성일시)
  • updated_at (수정일시)
  • is_delete (삭제여부)

orders_item (주문상세)

  • id (주문상세 ID) — Primary key — NOT NULL
  • order_id (주문 ID) — Foreign key → orders.id — NOT NULL
  • product_id (상품 ID) — Foreign key → product.id — NOT NULL
  • quantity (상품 수량)
  • price (가격)
  • created_at (생성일시)
  • updated_at (수정일시)
  • is_delete (삭제여부)

payment_history (결제내역)

  • id (결제 ID) — Primary key — NOT NULL
  • order_id (주문 ID) — Foreign key → orders.id — NOT NULL
  • total_price (주문 총 금액)
  • pay_method (결제방식)
  • status (결제 상태)
  • created_at (생성일시)
  • updated_at (수정일시)
  • is_delete (삭제여부)

product (상품)

  • id (상품 ID) — Primary key — NOT NULL
  • name (상품명)
  • price (상품가격)
  • created_at (생성일시)
  • updated_at (수정일시)
  • is_delete (삭제여부)

stock (상품 재고)

  • id (재고 ID) — Primary key — NOT NULL
  • product_id (상품 ID) — Foreign key → product.id — NOT NULL
  • quantity (재고 수량)
  • created_at (생성일시)
  • updated_at (수정일시)
  • is_delete (삭제여부)

users (유저)

  • id (유저 ID) — Primary key — NOT NULL
  • name (이름)
  • hp_no (연락처)
  • created_at (생성일시)
  • updated_at (수정일시)
  • is_delete (삭제여부)