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