green-market
Tables (9)
BASKET - REDIS (Untitled4)
- basket_id (Key) — Primary key — NOT NULL
- count (상품 수량)
- product_id (Key1)
- user_id (Key2)
CATEGORY (Untitled3)
- category_id (Key) — Primary key — NOT NULL
- name (카테고리 이름)
- user_id (Key2) — Foreign key → USER.user_id — NOT NULL
ORDER (Untitled5)
- order_id (Key) — Primary key — NOT NULL
- reciever_name (수령인)
- phone (전화번호)
- address (배송지 주소)
- status (주문 상태)
- payment (지불 금액)
- user_id (Key2) — Foreign key → USER.user_id — NOT NULL
ORDER_PRODUCT (Untitled6)
- order_product_id (Key) — Primary key — NOT NULL
- count (주문 수량)
- price (주문 금액)
- order_id (Key2) — Foreign key → ORDER.order_id — NOT NULL
- product_id (Key3) — Foreign key → PRODUCT.product_id — NOT NULL
PRODUCT (Untitled2)
- product_id (Key) — Primary key — NOT NULL
- name (상품 명)
- content (내용)
- price (가격)
- quantity (재고)
QUESTION (Untitled8)
- question_id (Key) — Primary key — NOT NULL
- title (질문 제목)
- content (내용)
- user_id (Key2) — Foreign key → USER.user_id — NOT NULL
- product_id (Key3) — Foreign key → PRODUCT.product_id — NOT NULL
REVIEW (Untitled7)
- review_id (Key) — Primary key — NOT NULL
- title (리뷰 제목)
- score (점수)
- user_id (Key2) — Foreign key → USER.user_id — NOT NULL
- product_id (Key3) — Foreign key → PRODUCT.product_id — NOT NULL
USER (Untitled)
- user_id (Key) — Primary key — NOT NULL
- email (이메일)
- password (비밀번호)
- name (이름)
- phone (전화번호)
- role (회원 타입)