shop

Tables (7)

Address (주소)

  • id (주소아이디) — BIGINT — Primary key — NOT NULL
  • member_id (회원아이디) — BIGINT — Foreign key → Member.id — NOT NULL
  • address_name (주소명) — VARCHAR
  • zipcode (우편번호) — VARCHAR
  • address (주소) — VARCHAR
  • detail_address (상세주소) — VARCHAR
  • phone_number (전화번호) — VARCHAR
  • created_at (등록일) — DATETIME
  • updated_at (수정일) — DATETIIME

Cart (장바구니)

  • id (장바구니아이디) — BIGINT — Primary key — NOT NULL
  • member_id (회원아이디) — BIGINT — Foreign key → Member.id — NOT NULL
  • created_at (생성일) — DATETIME
  • updated_at (수정일) — DATETIME

CartItem (장바구니상품)

  • id (장바구니상품아이디) — BIGINT — Primary key — NOT NULL
  • cart_id (장바구니아이디) — BIGINT — Foreign key → Cart.id — NOT NULL
  • product_id (상품아이디) — BIGINT — Foreign key → Product.id — NOT NULL
  • quantity (수량) — INT
  • created_at (추가일) — DATETIME
  • updated_at (수정일) — DATETIME

Member (회원)

  • id (회원아이디) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR
  • passowrd (비밀번호) — VARCHAR
  • name (이름) — VARCHAR
  • role (권한) — VARCHAR
  • created_at (가입일) — DATETIME
  • updated_at (수정일) — DATETIME

OrderItem (주문상품)

  • id (주문상품아이디) — BIGINT — Primary key — NOT NULL
  • product_id (상품아이디) — BIGINT — Foreign key → Product.id — NOT NULL
  • orders_id (주문아이디) — BIGINT — Foreign key → Orders.id — NOT NULL
  • quantity (수량) — INT
  • order_price (주문시가격) — INT
  • product_name (주문시상품이름) — String

Orders (주문)

  • id (주문아이디) — BIGINT — Primary key — NOT NULL
  • member_id (회원아이디) — BIGINT — Foreign key → Member.id — NOT NULL
  • address_id (주소아이디) — BIGINT — Foreign key → Address.id — NOT NULL
  • total_price (총주문금액) — INT
  • status (주문상태) — VARCHAR
  • ordered_at (주문일) — DATETIME

Product (상품)

  • id (상품아이디) — BIGINT — Primary key — NOT NULL
  • name (상품명) — VARCHAR
  • price (상품가격) — INT
  • stock_quantity (상품재고) — INT
  • description (상품설명) — TEXT
  • status (상품판매상태) — VARCHAR
  • created_at (등록일) — DATETIME
  • updated_at (수정일) — DATETIME