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