itsyours

Tables (7)

categories (Untitled6)

  • district (Field) — String
  • univName (Field2) — SubSchema

community (Untitled7)

  • postId (primary Key) — ObjectId — Primary key — NOT NULL
  • postTitle (Field) — String
  • postContents (Field2) — String
  • postAuth (Field3) — String
  • regDate (Field4) — String

members (Untitled)

  • userId (primary key) — String — Primary key — NOT NULL
  • userPwd (Field) — String
  • userName (Field2) — String
  • userEmail (Field3) — String
  • univName (Field4) — String
  • phoneNum (Field5) — String
  • thumbsUp (Field6) — Number
  • thumbsDown (Field7) — Number
  • useYn (Date) — Date
  • regDate (Field8) — Date
  • roleId (Field9)

products (Untitled2)

  • prodId (primary Key) — ObjectId — Primary key — NOT NULL
  • prodName (Field) — String
  • prodImg (Field2) — Array
  • originPrice (Field3) — Number
  • prodPrice (Field4) — Number
  • prodAuth (Field5) — String
  • prodPub (Field6) — String
  • prodStatus (Field7) — String
  • univName (Field8) — String
  • prodDisc (Field9) — String
  • sellerId (Field10) — String
  • regDate (Field11) — Date

purchase (Untitled3)

  • buyId (primary Key) — ObjectId — Primary key — NOT NULL
  • prodId (Field) — ObjectId
  • prodName (Field2) — String
  • prodImg (Field3) — Array
  • prodPrice (Field4) — Number
  • sellerId (Field5) — String
  • buyDate (Field6)

selling (Untitled4)

  • sellId (primary Key) — ObjectId — Primary key — NOT NULL
  • prodName (Field) — String
  • originPrice (Field2) — Number
  • prodPrice (Field3) — Number
  • prodStatus (Field4) — String
  • sellerId (Field5) — String
  • sellDate (Field6)

wishs (Untitled5)

  • prodId (primary Key) — ObjectId — Primary key — NOT NULL
  • prodName (Field) — String
  • originPrice (Field2) — Number
  • prodPrice (Field3) — Number
  • wishDate (Field4) — Date