DessertTime

Tables (15)

Copy Of Untitled (reviewImg)

  • Key (reviewImgId) — number — Primary key — NOT NULL
  • Field (middlepath) — string
  • Field (path) — string
  • Field (extension) — string
  • Field (imgName) — string
  • Field (createdDate) — date
  • Field (isMain) — boolean
  • Field2 (num) — number
  • Key (reviewId) — number — Foreign key → Untitled.Key — NOT NULL

DessertCategory (dessertCategory)

  • Key (DessertCatrgoryId) — number — Primary key — NOT NULL
  • Field (dessertName) — string
  • Field2 (sessionNum) — number
  • Field3 (createdDate) — date
  • Field4 (updatedDate) — date
  • Field (parentDCId) — number
  • Field (sortNum) — number

Untitled (UserInterestDessert)

  • Key (UIDId) — number — Primary key — NOT NULL
  • Field (createdDate) — date
  • Field2 (updatedDate) — date
  • Key (memberId) — number — Foreign key → User.Key — NOT NULL
  • Key (DId) — number — Foreign key → DessertCategory.Key — NOT NULL

Untitled (QnA)

  • Key (qnaId) — number — Primary key — NOT NULL
  • Field (email) — string
  • Field2 (content) — string
  • Field3 (isAnswered) — boolean
  • Field4 (createdDate) — date
  • Field5 (updatedDate) — date
  • Key (userId) — string — Foreign key → User.Key — NOT NULL
  • Field (isUsable) — boolean

Untitled (Notice)

  • Key (noticeId) — number — Primary key — NOT NULL
  • Field (title) — string
  • Field2 (content) — string
  • Field3 (createdDate) — date
  • Field4 (updatedDate) — date
  • Field (isNotice) — date

Untitled (Review)

  • Key (reviewId) — number — Primary key — NOT NULL
  • Field (totalLikedNum) — number
  • Field2 (content) — string
  • Field3 (menuName) — string
  • Field4 (storeName) — string
  • Field5 (score) — number
  • Field6 (createdDate) — date
  • Field7 (updateDate) — date
  • Field (isUsable) — boolean
  • Field2 (point) — number
  • Field (isUpdated) — boolean
  • Field (isInitalized) — boolean
  • Field (adminMemo) — string
  • Key (memberId) — number — Foreign key → User.Key — NOT NULL
  • Key (receiptImgId) — number — Foreign key → Untitled.Key — NOT NULL

Untitled (like)

  • Key (likeId) — number — Primary key — NOT NULL
  • Field (createdDate) — date
  • Key (reviewId) — number — Foreign key → Untitled.Key — NOT NULL
  • Key (memberId) — number — Foreign key → User.Key — NOT NULL

Untitled (accusation)

  • Key (accusationId) — number — Primary key — NOT NULL
  • Field (content) — string
  • Field (createdDate) — date
  • Field (updatedDate) — date
  • Field (reason) — string
  • Key (memberId) — number — Foreign key → User.Key — NOT NULL
  • Key (reviewId) — number — Foreign key → Untitled.Key — NOT NULL

Untitled (userImg)

  • Key (userImgId) — number — Primary key — NOT NULL
  • Field (middlepath) — string
  • Field (path) — string
  • Field (extension) — string
  • Field (createdDate) — date
  • Field (imgName) — string
  • Key (memberId) — number — Foreign key → User.Key — NOT NULL

Untitled (PointHistory)

  • Key (pointHisotryId) — number — Primary key — NOT NULL
  • Field (pointCount)
  • Field3 (menuName) — string
  • Field4 (updateDate) — date
  • Field5 (createDate) — date
  • Key (memberId) — number — Foreign key → User.Key — NOT NULL
  • Key (reviewId) — number — Foreign key → Untitled.Key — NOT NULL
  • Key (PTSId) — number — Foreign key → Untitled.Key — NOT NULL

Untitled (PointTotalCount)

  • Key (PTSId) — number — Primary key — NOT NULL
  • Field (pointTotalCount) — number
  • Field (updateDate) — date
  • Field2 (createDate) — date
  • Key (memberId) — number — Foreign key → User.Key — NOT NULL

Untitled (receiptImg)

  • Key (receiptImgId) — number — Primary key — NOT NULL
  • Field (middlepath) — string
  • Field (path) — string
  • Field (extention) — string
  • Field (imgName) — string
  • Field (createdDate) — Date

Untitled (reviewIngredient)

  • Key (reviewIngredientId) — number — Primary key — NOT NULL
  • Key (reviewId) — number — Foreign key → Untitled.Key — NOT NULL
  • Key (ingredientId) — number — Foreign key → Untitled.Key — NOT NULL

Untitled (ingredient)

  • Key (ingredientId) — number — Primary key — NOT NULL
  • Field (ingredientName) — string
  • Field (usable) — booean
  • Field2 (createdDate) — date

User (user)

  • Key (memberId) — number — Primary key — NOT NULL
  • (userName) — string
  • (nickName) — string
  • (birthYear) — date
  • (gender) — string
  • (memberEmail) — string
  • (isHavingImg) — boolean
  • (firstCity) — string
  • (secondaryCity) — string
  • (thirdCity) — string
  • (createdDate) — date
  • (updatedDate) — date
  • Field (lastAccessDate) — date
  • Field (isAgreeAD) — boolean
  • Field (isAgreeAlarm) — boolean