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