projecterd

Tables (10)

Untitled (item)

  • Key (item_id) — Primary key — NOT NULL
  • Field (dtype)
  • Field (name)
  • Field (price)
  • Field2 (stock)
  • Field (image)
  • Field (content)
  • Field (isbn)
  • Field (author)
  • Field (brand)

Untitled (orders)

  • Key (order_id) — Primary key — NOT NULL
  • member_id — Foreign key → member.member_id — NOT NULL
  • Field (receiver_name)
  • Field (receiver_phone)
  • Field (receiver_address)
  • Field (date)
  • Field (status)
  • Field (merchant_uid)

Untitled (order_item)

  • Key (order_item_id) — Primary key — NOT NULL
  • Key (order_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (item_id) — Foreign key → Untitled.Key — NOT NULL
  • Field3 (orderprice)
  • Field (count)
  • Field (review_check)

Untitled (coupon)

  • Key (coupon_id) — Primary key — NOT NULL
  • Field (name)
  • Field (discount)
  • Field (type)

Untitled (delivery)

  • Key (delivery_id) — Primary key — NOT NULL
  • Key (order_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (address)
  • Field2 (status)

Untitled (cart)

  • Key (cart_id) — Primary key — NOT NULL
  • member_id — Foreign key → member.member_id — NOT NULL

Untitled (cart_item)

  • Key (cart_item_id) — Primary key — NOT NULL
  • Key (cart_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (item_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (price)
  • Field (count)

Untitled (member_coupon)

  • Key (member_coupon_id) — Primary key — NOT NULL
  • member_id — Foreign key → member.member_id — NOT NULL
  • Key (coupon_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (count)

Untitled (review)

  • Key (review_id) — Primary key — NOT NULL
  • member_id — Foreign key → member.member_id — NOT NULL
  • Key (item_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (order_item_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (date)
  • Field2 (title)
  • Field (content)

member

  • member_id — Primary key — NOT NULL
  • (email)
  • (pwd)
  • (name)
  • (phone)
  • Field (address)
  • (type)
  • Field (date)
  • Field2 (grade)
  • Field (sum_price)