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