hea17hDB

Tables (5)

Categories (categories)

  • _id — ObjectId — Primary key — NOT NULL
  • name — String
  • Timestamp (TimeStamp) — Date

Food (foods)

  • _id — ObjectId — Primary key — NOT NULL
  • _id (category) — ObjectId — Foreign key → Categories._id — NOT NULL
  • name — String
  • nameEng — String
  • Field (image) — String
  • Timestamp (TimeStamp) — Date

certificates (Certificates)

  • Key (_id) — ObjectId — Primary key — NOT NULL
  • Field (certificate) — Array
  • Field (certificate_name) — String
  • Field (certificate_image) — String
  • Field (timeStamp) — Date
  • Key (user_id) — ObjectId — Foreign key → users.Key — NOT NULL
  • Key (role) — String — Foreign key → users.Key — NOT NULL

diets

  • Key (_id) — ObjectId — Primary key — NOT NULL
  • Key2 (user) — ObjectId — Primary key — NOT NULL
  • Field (name) — String
  • Field2 (totalCalories) — Number
  • Field3 (totalCarb) — Number
  • Field (totalProtein) — Number
  • Field (totalFat) — Number
  • Field (dietFoods) — Array
  • Field (comment) — Array
  • Field (mealType) — String
  • Field (mainImg) — String
  • Field (foods) — Array
  • Field (mealCalories) — Number
  • Field (mealCarbs) — Number
  • Field (mealProtein) — Number
  • Field (mealFat) — Number
  • Field (mealId) — ObjectId
  • Field (commentContent) — String
  • Field (timeStamp) — Date
  • _id (food_id) — ObjectId — Foreign key → Food._id — NOT NULL
  • _id (food_category) — ObjectId — Foreign key → Food._id — NOT NULL

users

  • Key (_id) — ObjectId — Primary key — NOT NULL
  • Key (role) — String — Primary key — NOT NULL
  • Field (name) — String
  • Field (password) — String
  • Field2 (gender) — String
  • Field (height) — Number
  • Field (weight) — Number
  • Field (age) — Number
  • Field (goal) — Number
  • Field (activeLevel) — Numver
  • Field (timeStamp) — Date
  • Field
  • Key (_id2) — ObjectId — Foreign key → diets.Key — NOT NULL
  • Key2 (user) — ObjectId — Foreign key → diets.Key2 — NOT NULL