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