핸드폰 판매 쇼핑몰

테이블 (9)

Favorite (Untitled8)

  • favorite_id (seq) — INT(AI)
  • product_id (Field2) — INT(AI) — 외래 키 → product.product_id
  • member_id (seq2) — INT(AI) — 외래 키 → Member.member_id

Member (member)

  • member_id (seq) — INT(AI) — 기본 키
  • member_email (email) — VARCHAR(30)
  • member_password (password) — VARCHAR(100)
  • member_nickname (name) — VARCHAR(12)
  • member_point (point) — INT
  • member_address (address) — VARCHAR(300)
  • member_detailAddress (detailAddress) — VARCHAR(20)
  • member_status (status) — CAHR(1)

design (Untitled4)

  • design_id (design) — INT(AI) — 기본 키
  • design_name (Field2) — VARCHAR(30)
  • product_id (Field3) — INT — 외래 키 → product.product_id

model (Untitled5)

  • model_id (model) — INT(AI) — 기본 키
  • model_name (Field2) — VARCHAR(30)
  • product_id (Field) — INT(AI) — 외래 키 → product.product_id

order (Untitled6)

  • order_id (Field) — BIGINT(AI) — 기본 키
  • product_design (Field2) — VARCHAR(30)
  • product_model (Field3) — VARCHAR(30)
  • order_count (Field4) — INT
  • member_id (seq) — INT(AI) — 외래 키 → Member.member_id
  • product_id (Field5) — INT(AI) — 외래 키 → product.product_id

photo (Untitled7)

  • photo_id (photo) — INT(AI) — 기본 키
  • photo_name (Field) — VARCHAR(1000)
  • product_id (Field2) — INT(AI) — 외래 키 → product.product_id

product (Untitled3)

  • product_id (Field) — INT(AI) — 기본 키
  • product_name (Field2) — VARCHAR(30)
  • product_price (Field3) — INT
  • product_Discount (Field4) — INT
  • product_deliveryPrice (Field5) — INT
  • member_id (seq) — INT(AI) — 외래 키 → Member.member_id

refreshToken (Untitled)

  • Field — 기본 키
  • refreshToken_id (seq) — INT(AI)
  • refreshToken — VARCHAR(200)
  • member_id (seq2) — INT — 외래 키 → Member.member_id

review (Untitled2)

  • review_id (Field) — INT(AI) — 기본 키
  • review_name (Field6) — VARCHAR(50)
  • review_content (Field3) — VARCHAR(1000)
  • review_date (fff) — Date
  • review_photo (Field5) — VARCHAR(1000)
  • product_id (Field2) — INT(AI) — 외래 키 → product.product_id
  • member_id (seq) — INT(AI) — 외래 키 → Member.member_id