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