쿠팡

테이블 (7)

Copy Of Copy Of Copy Of Copy Of Copy Of Untitled (Reward)

  • userID (reward_ID) — 기본 키 — NOT NULL
  • userID (review_ID) — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled.userID — NOT NULL
  • userID — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled.userID — NOT NULL
  • Field (points)
  • Field (review)
  • Field (review_date)
  • Email (review_text)
  • Name (rating)
  • Field (coupon)

Copy Of Copy Of Copy Of Copy Of Untitled (Review)

  • userID (review_ID) — 기본 키 — NOT NULL
  • userID — 외래 키 → Users.userID — NOT NULL
  • Field (product_ID)
  • Field (payment_ID)
  • Field (order_ID)
  • Field (comment)
  • Field (submitted_date)

Copy Of Copy Of Copy Of Copy Of Untitled2 (Payment)

  • userID (payment_ID) — 기본 키 — NOT NULL
  • userID (order_ID) — 외래 키 → Copy Of Copy Of Untitled.userID — NOT NULL
  • product_ID — 외래 키 → Copy Of Copy Of Untitled.product_ID — NOT NULL
  • Field (order_id)
  • Field (payment_method)
  • Name (transaction_date)
  • Email (transaction_status)

Copy Of Copy Of Copy Of Untitled (Delivery)

  • userID (delivery_ID) — 기본 키 — NOT NULL
  • userID (payment_ID) — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled2.userID — NOT NULL
  • userID (order_ID) — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled2.userID — NOT NULL
  • product_ID — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled2.product_ID — NOT NULL
  • Field (tracking_number)
  • Name (carrier)
  • Email (status)
  • Field (estimated_delivery_date)

Copy Of Copy Of Untitled (Orders)

  • userID (order_ID) — 기본 키 — NOT NULL
  • product_ID — 외래 키 → Products.product_ID — NOT NULL
  • Field (userID)
  • Field (order_date)
  • Name (total_amount)
  • Email (order_status)

Products

  • product_ID — 기본 키 — NOT NULL
  • userID — 외래 키 → Users.userID — NOT NULL
  • brand
  • category
  • description
  • Email (product_name)
  • Field (selller_id)
  • Phone Number (price)
  • Field2 (stock_quantity)

Users

  • userID — 기본 키 — NOT NULL
  • name
  • Name (email)
  • Phone Number (phone_number)
  • Field2 (address)
  • Field (identifcation_number)
  • (signup_date)