spring

Tables (7)

cart

  • cartid — INT(11) — Primary key — NOT NULL
  • userid — VARCHAR(50) — NOT NULL
  • productcount — INT(11)
  • checked — INT(11)
  • registerdate — TIMESTAMP
  • productid — INT(11)
  • USERID — VARCHAR(20) — Foreign key → member.USERID — NOT NULL

deletemember

  • USERID — VARCHAR(50) — Primary key — NOT NULL
  • PWD — VARCHAR(50)
  • NAME — VARCHAR(50)
  • SEX — VARCHAR(50)
  • ADDRESS — VARCHAR(50)
  • PHONE — VARCHAR(50)
  • EMAIL — VARCHAR(50)
  • CREATEDATE — TIMESTAMP
  • GRADE — VARCHAR(50)
  • ISDORMANT — VARCHAR(50)
  • DELETEDATE — TIMESTAMP

member

  • USERID — VARCHAR(20) — Primary key — NOT NULL
  • PWD — VARCHAR(20)
  • NAME — VARCHAR(20)
  • SEX — VARCHAR(20)
  • ADDRESS — VARCHAR(20)
  • PHONE — VARCHAR(20)
  • EMAIL — VARCHAR(20)
  • CREATEDATE — TIMESTAMP
  • GRADE — VARCHAR(50)
  • ISDORMANT — VARCHAR(10)

order

  • orderid — INT(11) — Primary key — NOT NULL
  • address — VARCHAR(50)
  • memberid — VARCHAR(50)
  • sender — VARCHAR(50)
  • receiver — VARCHAR(50)
  • orderdate — TIMESTAMP
  • receiverphone — VARCHAR(50)
  • totalprice — INT(11)
  • orderstate — VARCHAR(50)
  • receiver_location — VARCHAR(50)
  • INDEX — `FK_order_member`
  • USERID — VARCHAR(20) — Foreign key → member.USERID — NOT NULL

orderitem

  • orderitemid — INT(11) — Primary key — NOT NULL
  • orderid — INT(11) — Foreign key → order.orderid
  • productcount — INT(11)
  • userid — VARCHAR(50)
  • isPurchased — INT(11)
  • productid — INT(11)

product

  • productid — INT(11) — Primary key — NOT NULL
  • isbn — VARCHAR(50)
  • productname — VARCHAR(50)
  • price — INT(11)
  • discount — INT(11)
  • description — TEXT
  • booktype — VARCHAR(50)
  • salestype — VARCHAR(50)
  • publisher — VARCHAR(50)
  • writer — VARCHAR(50)
  • totalpage — INT(11)
  • bookindex — TEXT
  • publishdate — TIMESTAMP
  • thumbnail — VARCHAR(100)
  • registerdate — TIMESTAMP
  • cartid — INT(11) — Foreign key → cart.cartid — NOT NULL

productimage

  • imagenum — INT(11) — Primary key — NOT NULL
  • productid — INT(11)
  • org_name — VARCHAR(50)
  • contenttype — VARCHAR(50)
  • real_name — VARCHAR(50)
  • INDEX — `FK_productimage_product`