Apparel ShoppingMall

Tables (14)

Accessory (Untitled3)

  • bName (Key3) — varchar(20) — Foreign key → Gender.bName — NOT NULL
  • imgUrl1 (Field2) — varchar(100)
  • imgUrl2 (Field3) — varchar(100)
  • imgUrl (Field4) — varchar(100)
  • price (Field5) — num(5)
  • purchasedNum (Field6) — num(10)
  • balance (Field7) — num(10)
  • explain (Field8) — varchar(1000)

Auction (auction)

  • userId (Key2) — num(5) — Foreign key → User.userId — NOT NULL
  • bName (Field) — varchar(20)
  • pName (name) — varchar(20)
  • size (Field5) — num(5)
  • price (Field6) — num(10)
  • startPrice (Field11) — num(10)
  • imgUrl (Field2) — varchar(100)
  • endPrice (Field3) — num(10)
  • endTime (Field4) — date

Board

  • userId (Key) — varchar(20) — Foreign key → User.userId — NOT NULL
  • title (Field3) — num(5)
  • content (Field4) — varchar(50)
  • writeDate (Field2) — sysdate
  • num (Field5) — num(1)
  • imgUrl1 (Field6) — varchar(100)
  • imgUrl2 (Field7) — varchar(100)
  • imgUrl3 (Field8) — varchar(100)
  • readCount (Field) — num(5)

Bottom (bottom)

  • pGender (ForeignKey) — num(1) — Foreign key → Gender.pGender — NOT NULL
  • bName (Key3) — varchar(20) — Foreign key → Gender.bName — NOT NULL
  • pName (name) — varchar(20)
  • imgUrl1 (Field2) — varchar(100)
  • imgUrl2 (Field3) — varchar(100)
  • imgUrl3 (Field4) — varchar(100)
  • size (Field5) — num(5)
  • price (Field6) — num(10)
  • purchasedNum (Field7) — num(10)
  • balance (Field8) — num(1)
  • explain (Field9) — varchar(1000)

Brand

  • bName (Key) — varchar(20) — Primary key — NOT NULL
  • imgUrl (Field) — varchar(100)

Cart (cart)

  • userId (Key2) — num(5) — Foreign key → User.userId — NOT NULL
  • bName (Field) — varchar(20)
  • pGender (Field10) — num(1)
  • pName (name) — varchar(20)
  • size (Field5) — num(5)
  • price (Field6) — num(10)
  • balance (Field8) — num(10)
  • imgUrl (Field2) — varchar(100)

Gender (Untitled5)

  • pGender (Key) — num(1) — Primary key — NOT NULL
  • bName (Key3) — varchar(20) — Foreign key → Brand.bName — NOT NULL

Hotdeal (hotdeal)

  • userId (Key2) — num(5) — Foreign key → User.userId — NOT NULL
  • bName (Field) — varchar(20)
  • pName (name) — varchar(20)
  • size (Field5) — num(5)
  • price (Field6) — num(10)
  • hotdealPrice (Field11) — num(10)
  • imgUrl (Field2) — varchar(100)

Like (like)

  • userId (Key2) — num(5) — Foreign key → User.userId — NOT NULL
  • bName (Field) — varchar(20)
  • pGender (Field10) — num(1)
  • pName (name) — varchar(20)
  • size (Field5) — num(5)
  • price (Field6) — num(10)
  • balance (Field8) — num(10)
  • imgUrl (Field2) — varchar(100)

Purchased (purchased product)

  • userId (Key2) — num(5) — Foreign key → User.userId — NOT NULL
  • bName (Field) — varchar(20)
  • pName (name) — varchar(20)
  • size (Field5) — num(5)
  • price (Field6) — num(10)
  • purchasedPrice (Field11) — num(10)
  • imgUrl (Field2) — varchar(100)

Shoes (Untitled2)

  • pGender (ForeignKey) — num(1) — Foreign key → Gender.pGender — NOT NULL
  • bName (Key3) — varchar(20) — Foreign key → Gender.bName — NOT NULL
  • pName (name) — varchar(20)
  • imgUrl1 (Field2) — varchar(100)
  • imgUrl2 (Field3) — varchar(100)
  • imgUrl3 (Field4) — varchar(100)
  • size (Field5) — num(5)
  • price (Field6) — num(10)
  • purchasedNum (Field7) — num(10)
  • balance (Field8) — num(10)
  • explain (Field9) — varchar(1000)

Top (top)

  • pGender (ForeignKey) — num(1) — Foreign key → Gender.pGender — NOT NULL
  • bName (Key3) — varchar(20) — Foreign key → Gender.bName — NOT NULL
  • pName (name) — varchar(20)
  • imgUrl1 (Field2) — varchar(100)
  • imgUrl2 (Field3) — varchar(100)
  • imgUrl3 (Field4) — varchar(100)
  • size (Field5) — num(5)
  • price (Field6) — num(10)
  • purchasedNum (Field7) — num(10)
  • balance (Field8) — num(10)
  • explain (Field9) — varchar(1000)

User

  • userId (Key) — num(5) — Primary key — NOT NULL
  • pass (Field) — num(5)
  • name (Field2) — num(5)
  • email (Field3) — varchar(30)
  • address (Field4) — varchar(100)
  • phone (Field5) — num(11)
  • gender (Field6) — num(5)
  • grade (Field7) — num(1)
  • point (Field8) — num(10)
  • enter (Field9) — sysdate

UserBodyProfile (Untitled4)

  • userId (Key) — varchar(20) — Foreign key → User.userId — NOT NULL