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