AI-allergy

Tables (30)

allergy

  • code — VARCHAR(30)
  • name — VARCHAR(100) — NOT NULL
  • allergy_group — VARCHAR(20) — NOT NULL
  • display_order — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

allergy_translation

  • id — BIGINT
  • allergy_code — VARCHAR(30) — Foreign key → allergy.code — NOT NULL
  • lang_code — VARCHAR(10) — Foreign key → language.code — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • is_auto_translated — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

cafeteria

  • id — BIGINT
  • school_id — BIGINT — Foreign key → school.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

country

  • code — VARCHAR(10)
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

ingredient

  • code — VARCHAR(50)
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

ingredient_translation

  • id — BIGINT
  • ingredient_code — VARCHAR(50) — Foreign key → ingredient.code — NOT NULL
  • lang_code — VARCHAR(10) — Foreign key → language.code — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • is_auto_translated — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

language

  • code — VARCHAR(10)
  • name — VARCHAR(50) — NOT NULL
  • english_name — VARCHAR(50) — NOT NULL

meal_menu

  • id — BIGINT
  • meal_schedule_id — BIGINT — Foreign key → meal_schedule.id — NOT NULL
  • menu_id — BIGINT — Foreign key → menu.id — NOT NULL
  • corner_name — VARCHAR(100)
  • display_order — INT — NOT NULL
  • ingredient_info_source_type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

meal_menu_confirmation_history

  • id — BIGINT
  • meal_menu_id — BIGINT — Foreign key → meal_menu.id — NOT NULL
  • changed_by_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • action_type — VARCHAR(30) — NOT NULL
  • target_type — VARCHAR(30)
  • ingredient_code — VARCHAR(50) — Foreign key → ingredient.code
  • memo — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL

meal_menu_confirmed_ingredient

  • meal_menu_id — BIGINT — Foreign key → meal_menu.id — NOT NULL
  • ingredient_code — VARCHAR(50) — Foreign key → ingredient.code — NOT NULL
  • confirmed_by_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • confirmed_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

meal_menu_review

  • id — BIGINT
  • meal_menu_id — BIGINT — Foreign key → meal_menu.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

meal_menu_review_like

  • review_id — BIGINT — Foreign key → meal_menu_review.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

meal_schedule

  • id — BIGINT
  • cafeteria_id — BIGINT — Foreign key → cafeteria.id — NOT NULL
  • meal_date — DATE — NOT NULL
  • meal_type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

meal_schedule_crawl_history

  • id — BIGINT
  • cafeteria_id — BIGINT — Foreign key → cafeteria.id — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • failure_message — VARCHAR(1000)
  • started_at — TIMESTAMP — NOT NULL
  • finished_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

menu

  • id — BIGINT
  • name — VARCHAR(200) — NOT NULL
  • spicy_level — BIGINT — NOT NULL
  • ai_analysis_status — VARCHAR(40) — NOT NULL
  • latest_ai_analyzed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

menu_ai_analysis

  • id — BIGINT
  • menu_id — BIGINT — Foreign key → menu.id — NOT NULL
  • status — VARCHAR(40) — NOT NULL
  • attempt_count — INT — NOT NULL
  • model_name — VARCHAR(100)
  • model_version — VARCHAR(50)
  • reason — TEXT
  • analyzed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

menu_ai_analysis_allergy

  • menu_ai_analysis_id — BIGINT — Foreign key → menu_ai_analysis.id — NOT NULL
  • allergy_code — VARCHAR(30) — Foreign key → allergy.code — NOT NULL
  • confidence — NUMERIC(5,2)
  • reason — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL

menu_ai_analysis_ingredient

  • menu_ai_analysis_id — BIGINT — Foreign key → menu_ai_analysis.id — NOT NULL
  • ingredient_code — VARCHAR(50) — Foreign key → ingredient.code — NOT NULL
  • confidence — NUMERIC(5,2)
  • created_at — TIMESTAMP — NOT NULL

menu_like

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • cafeteria_id — BIGINT — Foreign key → cafeteria.id — NOT NULL
  • menu_id — BIGINT — Foreign key → menu.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

menu_review

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • cafeteria_id — BIGINT — Foreign key → cafeteria.id — NOT NULL
  • menu_id — BIGINT — Foreign key → menu.id — NOT NULL
  • meal_menu_id — BIGINT — Foreign key → meal_menu.id
  • meal_date — DATE
  • content — TEXT — NOT NULL
  • like_count — BIGINT — NOT NULL
  • comment_count — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

menu_review_comment

  • id — BIGINT
  • review_id — BIGINT — Foreign key → menu_review.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

menu_review_like

  • id — BIGINT
  • review_id — BIGINT — Foreign key → menu_review.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

menu_translation

  • id — BIGINT
  • menu_id — BIGINT — Foreign key → menu.id — NOT NULL
  • lang_code — VARCHAR(10) — Foreign key → language.code — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • is_auto_translated — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

religious_food_restriction

  • code — VARCHAR(30)
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

religious_food_restriction_ingredient

  • religious_food_restriction_code — VARCHAR(30) — Foreign key → religious_food_restriction.code — NOT NULL
  • ingredient_code — VARCHAR(50) — Foreign key → ingredient.code — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

religious_food_restriction_translation

  • id — BIGINT
  • religious_food_restriction_code — VARCHAR(30) — Foreign key → religious_food_restriction.code — NOT NULL
  • lang_code — VARCHAR(10) — Foreign key → language.code — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • is_auto_translated — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

school

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • source_url — VARCHAR(500) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

school_translation

  • id — BIGINT
  • school_id — BIGINT — Foreign key → school.id — NOT NULL
  • lang_code — VARCHAR(10) — Foreign key → language.code — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • is_auto_translated — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_allergy

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • allergy_code — VARCHAR(30) — Foreign key → allergy.code — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

users

  • id — BIGINT
  • school_id — BIGINT — Foreign key → school.id
  • email — VARCHAR(255)
  • name — VARCHAR(100) — NOT NULL
  • country_code — VARCHAR(10) — Foreign key → country.code
  • language_code — VARCHAR(10) — Foreign key → language.code
  • religious_code — VARCHAR(30) — Foreign key → religious_food_restriction.code
  • status — VARCHAR(20) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • onboarding_completed — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP