green-market

Tables (9)

ANSWER (Untitled9)

    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 (회원 타입)