SHP

Tables (4)

Member

  • member_id — BIGINT — Primary key
  • LoginId — varcher(20)
  • name — VARCHAR(100)
  • email — VARCHAR(100)
  • password — VARCHAR(100)
  • phone — VARCHAR(50)
  • address — VARCHAR(200)

Order

  • order_id — BIGINT — Primary key
  • member_id — BIGINT — Foreign key → Member.member_id
  • totalPrice — INT
  • pointused — INT
  • cashamount — INT
  • orderStatus — VARCHAR(50)
  • createDate — DATETIME

OrderItem

  • order_item_id — BIGINT — Primary key
  • quantity — INT
  • price — INT
  • order_id — BIGINT — Foreign key → Order.order_id
  • product_id — BIGINT — Foreign key → Product.product_id

Product

  • product_id — BIGINT — Primary key
  • productName — VARCHAR(100)
  • productStock — INT
  • description — VARCHAR(255)