A
Tables (9)
delivery (배송)
- no (주문번호) — NOT NULL — Foreign key → order_group.no — NOT NULL
- name (수취인명) — NOT NULL
- phone_number (수취인 전화번호) — NOTNULL
- address (배송지 주소) — NOT NULL
- memo (배송관련메모) — NULL
delivery_detail (Untitled)
- no (배송번호) — NOT NULL — Primary key — NOT NULL
- no (주문상품번호) — NOT NULL — Foreign key → order.no — NOT NULL
- no (주문번호) — NOT NULL — Foreign key → delivery.no — NOT NULL
- status(출고/배송중/도착) (배송상태) — NOT NULL
- departed (출고일자) — NULL
- arrived (도착예정일자) — NULL
order (주문의 개별 상품)
- no (주문상품번호) — NOT NULL — Primary key — NOT NULL
- no (주문번호) — NOT NULL — Foreign key → order_group.no — NOT NULL
- no (상품번호) — NOT NULL — Foreign key → product.no — NOT NULL
- product_quantity (상품수량) — NOT NULL
- color (주문색상) — NOT NULL
order_group (총주문)
- no (주문번호) — NOT NULL — Primary key — NOT NULL
- no (회원번호) — NOT NULL — Foreign key → user.no — NOT NULL
- datetime (주문일자) — NOT NULL
- total_price (총 주문금액) — NOT NULL
payment (결제)
- no (결제번호) — NOT NULL — Primary key — NOT NULL
- no (주문번호) — NOT NULL — Foreign key → order_group.no — NOT NULL
- method (결제방식) — NOT NULL
- nstallment (할부여부) — NOT NULL
- discount_amount (할인금액) — NULL
- total_price (총 결제금액) — NOT NULL
product (상품)
- no (상품번호) — NOT NULL — Primary key — NOT NULL
- name (상품명) — NOT NULL
- category (상품카테고리) — NOT NULL
- status (상품상태(여유/품절임박/품절)) — NOT NULL
- Inventory_amount (상품 재고량) — NOT NULL
- color (상품색상) — NULL
- introduction (상품소개) — NOT NULL
- model (상품모델) — NOT NULL
- image (상품이미지) — NOT NULL
refund (환불)
- no (환불번호) — NOT NULL — Primary key — NOT NULL
- no (주문번호) — NOT NULL — Foreign key → order.no — NOT NULL
- no (상품번호) — NOT NULL — Foreign key → order.no — NOT NULL
- reason (환불사유) — NOT NULL
- image (환불사유 이미지) — NOT NULL
- datetime (환불 접수날짜) — NOT NULL
review (리뷰)
- no (리뷰번호) — NOT NULL — Primary key — NOT NULL
- product_no (상품번호) — NOT NULL — Foreign key → product.no — NOT NULL
- title (제목) — NOT NULL
- content (내용) — NOT NULL
- gpa (평점) — NOT NULL
- imgae (리뷰이미지) — NOT NULL
user (고객)
- no (회원번호) — NOT NULL — Primary key — NOT NULL
- name (회원이름) — NOT NULL
- id (회원아이디) — NOT NULL
- password (회원비밀번호) — NOT NULL
- email (이메일) — NOT NULL
- phone_number (전화번호) — NOTNULL
- address (주소) — NOT NULL
- birth (생년월일) — NOTNULL
- rating (회원등급) — NOT NULL
- point (포인트) — NOT NULL
- generation_date (생성일자) — NOT NULL