e-commerce
Tables (9)
deliverys (배송)
- id (배송id) — BIGINT — Primary key — NOT NULL
- order_id (주문id) — BIGINT — Foreign key → orders.id — NOT NULL
- address (배송지) — VARCHAR
- phone_number (전화번호) — VARCHAR
- deliver_status (배송상태) — VARCHAR(준비중, 배송중, 배송 완료,반품)
- created_at (생성날짜) — TIMESTAMP
- completed_at (배송 완료 날짜) — TIMESTAMP
orderitems (주문 상품)
- id (주문상품id) — BIGINT — Primary key — NOT NULL
- order_id (주문id) — BIGINT — Foreign key → orders.id — NOT NULL
- product_id (상품id) — BIGINT — Foreign key → products.id — NOT NULL
- order_quantity (주문 수량) — INT
- created_at (생성날짜) — TIMESTAMP
- updated_at (수정날짜) — TIMESTAMP
orders (주문)
- id (주문id) — BIGINT — Primary key — NOT NULL
- user_id (회원id) — BIGINT — Foreign key → users.id — NOT NULL
- orderer (주문자) — VARCHAR
- total_price (총 구매금액) — BIGINT
- status (주문상태) — VARCHAR(주문완료, 주문취소,거래 확정)
- created_at (생성날짜) — TIMESTAMP
- updated_at (수정날짜) — TIMESTAMP
- returnsigned_at (반품신청날짜) — TIMESTAMP
payment (결제)
- id (결제id) — BIGINT — Primary key — NOT NULL
- order_id (주문id) — BIGINT — Foreign key → orders.id — NOT NULL
- payment_method (주문 방법) — VARCHAR(카드, 계좌이체)
- payment_status (결제 상태) — VARCHAR(결제 대기, 결제 완료, 결제 취소)
- order_price (주문 금액) — INT
- delivery_price (배송비) — INT
- total_payment_price (총 지불 금액) — INT
- payment_completed_at (결제 완료 날짜) — TIMESTAMP
- created_at (생성날짜) — TIMESTAMP
- updated_at (수정날짜) — TIMESTAMP
products (상품)
- id (상품id) — BIGINT — Primary key — NOT NULL
- product_name (상품명) — VARCHAR
- description (상품설명) — VARCHAR
- category (카테고리) — VARCHAR(TOP, BOTTOM, OUTER, HAT, ACC)
- price (상품가격) — INT
- created_at (생성날짜) — TIMESTAMP
- updated_at (수정날짜) — TIMESTAMP
stock (재고)
- id (재고id) — BIGINT — Primary key — NOT NULL
- product_id (상품id) — BIGINT — Foreign key → products.id — NOT NULL
- quantity (상품 수량) — BIGINT
users (회원)
- id (회원id) — BIGINT — Primary key — NOT NULL
- username (이름) — VARCHAR
- email (이메일주소) — VARCHAR
- password (비밀번호) — VARCHAR
- phone_number (전화번호) — VARCHAR(10)
- address (주소) — VARCHAR
- created_at (생성날짜) — TIMESTAMP
- updated_at (수정날짜) — TIMESTAMP
- emailVerified (이메일 인증 여부) — true, false
wishlist_items (위시리스트 상품)
- id (장바구니상품id) — BIGINT — Primary key — NOT NULL
- wishlist_id (위시리스트 id) — BIGINT — Foreign key → wishlists.id — NOT NULL
- product_id (상품id) — BIGINT — Foreign key → products.id — NOT NULL
- quantity (위시리스트 삼품 수량) — INT
- created_at (생성날짜) — TIMESTAMP
- updated_at (수정날짜) — TIMESTAMP
wishlists (위시리스트)
- id (장바구니id) — BIGINT — Primary key — NOT NULL
- user_id (회원id) — BIGINT — Foreign key → users.id — NOT NULL
- created_at (생성날짜) — TIMESTAMP
- updated_at (수정날짜) — TIMESTAMP