Users

- user_id (PK)

- name

- email

- created_at

User_Allergies

- user_allergy_id (PK)

- user_id (FK)

- allergen_id (FK)

- notes

- created_at

Allergens

- allergen_id (PK)

- allergy_name

- summary

- severity_notes

- created_at

Allergen_Triggers

- trigger_id (PK)

- allergen_id (FK)

- name_common

- name_scientific

- processing_notes

- cross_reactivity

Allergen_Variants

- variant_id (PK)

- trigger_id (FK)

- variant_type

- name

Product_Scans

- scan_id (PK)

- user_id (FK)

- product_name

- scanned_text

- scanned_at

Detected_Ingredients

- ingredient_id (PK)

- scan_id (FK)

- ingredient_name

- matched_allergen_id (FK)

- match_confidence

Alerts

- alert_id (PK)

- user_id (FK)

- scan_id (FK)

- allergen_id (FK)

- alert_message

- created_at