homework
Tables (11)
DealReivew
- takerIdx — int(11) — NOT NULL
- giverIdx (Field3) — int(11)
- dealIdx (Field4) — int(11)
- text (Field5) — text
- createAt (Field6) — timestamp
- updateAtimstamp()Field7 (Field7) — timestamp
- status (Field) — char(1)
LIkeProductCategories (Untitled3)
- userIdx (Field) — int(11)
- pdtCategoryIdx (Field2) — int(11)
- createdAt (Field3) — timestamp
- updatedAt (Field4) — timestamp
- Field5 — char(1)
LikeProduct (Untitled)
- userIdx (Field) — int(11)
- productIdx (Field2) — int(11)
- createdAt (Field3) — timestamp
- updatedAt (Field4) — timestamp
- status (Field5) — char(1)\
Manners (Untitled4)
- takerIdx (Field) — int(11)
- giverIdx (Field2) — int(11)
- dealIdx (Field3) — int(11)
- categoryIdx (Field4) — int(11)
- createdAt (Field5) — timestamp
- updatedAt (Field6) — timestamp
- status (Field7) — char(1)
Product (Untitled2)
- productIdx (Field) — int(11)
- location (Field2) — int(11)
- title (Field3) — text
- content (Field4) — text
- price (Field5) — int(11)
- sellerIdx (Field6) — int(11)
- category (Field7) — int(11)
- createdAt (Field8) — timestamp
- updatedAt (Field9) — timestamp
- status (Field10) — char(1)
ProductCategories (Untitled5)
- categoryIdx (Key) — int(11) — Primary key — NOT NULL
- category (Field) — varchar(20)
ProductMessage (CopyOfUntitled5)
- messageIdx (Key) — int(11) — Primary key — NOT NULL
- chatRoomIdx (Field) — int(11)
- senderIdx (Field2) — int(11)
- chat (Field3) — text
- createdAt (Field4) — timestamp
- updatedAt (Field5) — timestamp
- status (Field6) — char(1)
ProductMessagePhoto (CopyOfUntitled52)
- PhotoIdx (Key) — int(11) — Primary key — NOT NULL
- messegaIdx (Field) — int(11)
- Photo (Field2) — text
- createdAt (Field3) — timestamp
- updatedAt (Field4) — timestamp
- status (Field5) — char(1)
ProductViews (Untitled7)
- productIdx (Field) — int(11)
- userIdx (Field2) — int(11)
- createdAt (Field3) — timestamp
- updatedAt (Field4) — timestamp
- count (Field5) — tinyint(4)
Productphoto (Untitled6)
- productphotoIdx (Key) — int(11) — Primary key — NOT NULL
- productIdx (Field) — int(11)
- photo (Field2) — text
- createdAt (Field3) — timestamp
- updatedAt (Field4) — timestamp
- status (Field5) — char(1)
User (사용자)
- userIdx (PRI) — int(11) — Primary key — NOT NULL
- userId (UNI) — varchar(45) — Primary key — NOT NULL
- userPw (Field) — varchar(60)
- userName (Field2) — varchar(24)
- userNickName (Field3) — varchar(24)
- address (Field4) — int(11)
- subAddress (Field5) — int(11)
- createdAt (Field6) — timestamp
- updatedAt (Field7) — timestamp
- status (Field8) — char(1)