tbl_member

Tables (7)

goods_category

  • CateCode (cateCode) — not null — Primary key — NOT NULL
  • CateCodeRef (cateCodeRef) — not null — Primary key — NOT NULL
  • CateName (cateName) — not null

tbl_cart

  • CartNum (cartNum) — not null — Primary key — NOT NULL
  • UserId (userId) — not null — Primary key — NOT NULL
  • GdsNum (gdsNum) — not null
  • CartStock (cartStock) — not null
  • AddDate (addDate) — default sysdate
  • UserId (userId2) — not null — Foreign key → tbl_member.UserId — NOT NULL
  • GdsNum (gdsNum2) — not null — Foreign key → tbl_goods.GdsNum — NOT NULL

tbl_goods

  • GdsNum (gdsNum) — not null — Primary key — NOT NULL
  • GdsName (gdsName) — not null
  • CateCode (cateCode) — not null
  • GdsPrice (gdsPrice) — not null
  • GdsStock (gdsStock) — null
  • GdsDes (gdsDes) — null
  • GdsImg (gdsImg) — null
  • GdsDate (gdsDate) — default sysdate
  • CateCode (cateCode2) — not null — Foreign key → goods_category.CateCode — NOT NULL
  • CateCodeRef (cateCodeRef) — not null — Foreign key → goods_category.CateCodeRef — NOT NULL

tbl_member

  • UserId (userId) — not null — Primary key — NOT NULL
  • UserPass (userPass) — not null
  • UserName (userName) — not null
  • UserPhon (userPhon) — not null
  • UserAddr1 (userAddr1) — null
  • UserAddr2 (userAddr2) — null
  • UserAddr3 (userAddr3) — null
  • RegDate (regDate) — default sysdate
  • Verify (verify) — default 0

tbl_order

  • OrderId (orderId) — not null — Primary key — NOT NULL
  • UserId (userId) — not null
  • OrderRec (orderRec) — not null
  • UserAddr1 (userAddr1) — not null
  • UserAddr2 (userAddr2) — not null
  • UserAddr3 (userAddr3) — not null
  • OrderPhon (orderPhon) — not null
  • Amount (amount) — not null
  • OrderDate (orderDate) — default sysdate
  • GdsNum (gdsNum) — not null — Foreign key → tbl_goods.GdsNum — NOT NULL
  • UserId (userId2) — not null — Foreign key → tbl_member.UserId — NOT NULL
  • OrderDetailsNum (orderDetailsNum) — not null — Foreign key → tbl_order_details.OrderDetailsNum — NOT NULL

tbl_order_details (.)

  • OrderDetailsNum (orderDetailsNum) — not null — Primary key — NOT NULL
  • OrderId (orderId) — not null
  • GdsNum (gdsNum) — not null
  • CartStock (cartStock) — not null

tbl_reply

  • GdsNum (gdsNum) — not null — Primary key — NOT NULL
  • RepNum (repNum) — not null — Primary key — NOT NULL
  • UserId (userId) — not null
  • RepCon (repCon) — not null
  • RepDate (repDate) — default sysdate
  • GdsNum (gdsNum2) — not null — Foreign key → tbl_goods.GdsNum — NOT NULL