shoppingMall

Tables (6)

Untitled (Member)

    cart_items (Untitled5)

    • cart_item_id (Key) — Primary key — NOT NULL
    • member_id (Field)
    • product_id (Field2)
    • quentity (Field3)
    • total_price (Field4)

    members (Untitled)

    • 회원고유번호 (member_id) — INT — Primary key — NOT NULL
    • 유저 아이디 (user_id) — VARCHAR(30) — NOT NULL
    • 비밀번호 (password) — VARCHAR(20) — NOT NULL
    • 이름 (name) — VARCHAR(15) — NOT NULL
    • 전화번호 (phone_number) — BIGINT — NOT NULL
    • 회원등급 (grade) — VARCHAR(20) — NOT NULL
    • 가입 날짜 (created_at) — timestamp — NOT NULL
    • 탈퇴여부 (is_deleted) — VARCHAR — NOT NULL

    order_items (Untitled4)

    • order_items_id (Key) — Primary key — NOT NULL
    • order_id (Field)
    • product_id (Field2)
    • quantity (Field3)
    • order_price (Field4)

    orders (Untitled3)

    • order_id (Key) — Primary key — NOT NULL
    • order_number (Field)
    • member_id (Field2)
    • order_date (Field3)
    • total_price (Field4)
    • status (Field5)

    products (Untitled2)

    • prodect_id (Key) — Primary key — NOT NULL
    • name (Field)
    • product_code (Field2)
    • price (Field3)
    • is_sold_out (Field4)
    • created_at (Field5)