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)