minipj
Tables (8)
meal_feedback
- id — BIGINT
- meal_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- rating — INT
- comment — TEXT — EX
- created_at — TIMESTAMP
meal_set_items
- id — BIGINT
- meal_set_id — BIGINT — NOT NULL
- menu_item_id — BIGINT — NOT NULL
meal_sets
- id — BIGINT
- meal_id — BIGINT — NOT NULL
- set_name — VARCHAR(100)
- created_at — TIMESTAMP
meals
- id — BIGINT
- meal_date — DATE — NOT NULL
- meal_type — ENUM('BREAKFAST','LUNCH','DINNER') — NOT NULL
- average_rating — DECIMAL(3,2)
- participant_count — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
menu_item_allergens
- id — BIGINT
- menu_item_id — BIGINT — NOT NULL
- allergen — VARCHAR(50) — NOT NULL
menu_item_nutrition
- id — BIGINT
- menu_item_id — BIGINT — NOT NULL
- calories — INT
- protein — INT
- carbohydrates — INT
- fat — INT
- fiber — INT
- sodium — INT
menu_items
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- category — VARCHAR(50) — NOT NULL
- is_active — TINYINT(1)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users
- id — BIGINT
- username — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — ENUM('STUDENT','NUTRITIONIST','ADMIN')
- is_active — TINYINT(1)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP