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 (삭제여부)