Define database structure

[Ty3r0X]

Table: users
Columns: id, username, password

Table: userdata
Columns: uid, fname, lname, age, profilepic
uid references users.id

Table: Items
Columns: Item_ID, Name, Brand, Weight, Nutritional facts, Price, Picture

Table: User_Allergens
Columns: User_ID, Allergen
User_ID references users.id

Table: Items_Allergens
Columns: Item_ID, Allergen
Item_ID references Items.Item_ID

[Ty3r0X]

Food Allergy	Symptoms
Milk	Hives, upset stomach, vomiting
Eggs	Skin inflammation, digestive issues
Peanuts	Anaphylaxis, hives, difficulty breathing
Tree Nuts	Swelling, difficulty swallowing
Fish	Nausea, vomiting, diarrhea
Shellfish	Tingling in mouth, digestive issues
Soy	Skin rash, digestive problems
Wheat	Digestive issues, skin rash
Sesame Seeds	Hives, anaphylaxis, difficulty breathing
Mustard	Skin rash, swelling, difficulty breathing
Celery	Skin inflammation, digestive issues
Lupin	Skin rash, digestive problems
Sulphites	Asthma, hives, anaphylaxis
Molluscs	Itching, swelling, digestive problems
Corn	Skin rash, digestive issues
Red Meat	Hives, stomach pain, digestive issues
Kiwi	Hives, vomiting, difficulty breathing
Avocado	Skin rash, swelling, difficulty breathing
Banana	Hives, stomach pain, difficulty breathing
Chocolate	Hives, nausea, digestive problems
Citrus Fruits	Hives, stomach pain, mouth irritation
Garlic	Skin rash, digestive issues
Onions	Digestive issues, skin rash
Sunflower Seeds	Hives, anaphylaxis, difficulty breathing
Bell Peppers	Skin rash, digestive issues
Pineapple	Hives, digestive issues, mouth irritation
Strawberries	Hives, swelling, difficulty breathing
Tomatoes	Skin rash, digestive issues
Carrots	Skin rash, digestive issues
Apples	Hives, stomach pain, difficulty breathing
Pears	Hives, stomach pain, difficulty breathing
Grapes	Hives, stomach pain, difficulty breathing
Watermelon	Hives, stomach pain, difficulty breathing
Peaches	Hives, stomach pain, difficulty breathing
Plums	Hives, stomach pain, difficulty breathing
Cherries	Hives, stomach pain, difficulty breathing
Apricots	Hives, stomach pain, difficulty breathing
Berries	Hives, stomach pain, difficulty breathing
Mango	Hives, stomach pain, difficulty breathing
Papaya	Hives, stomach pain, difficulty breathing
Melon	Hives, stomach pain, difficulty breathing
Coconut	Hives, stomach pain, difficulty breathing
Lychee	Hives, stomach pain, difficulty breathing
Persimmons	Hives, stomach pain, difficulty breathing
Pine Nuts	Hives, difficulty swallowing
Macadamia Nuts	Swelling, difficulty swallowing
Brazil Nuts	Swelling, difficulty swallowing
Pecans	Swelling, difficulty swallowing
Walnuts	Swelling, difficulty swallowing
Hazelnuts	Swelling, difficulty swallowing
Almonds	Swelling, difficulty swallowing
Cashews	Swelling, difficulty swallowing
Pistachios	Swelling, difficulty swallowing
Chestnuts	Swelling, difficulty swallowing
Coconuts	Swelling, difficulty swallowing
Sunflower Seeds	Hives, anaphylaxis, difficulty breathing
Poppy Seeds	Hives, anaphylaxis, difficulty breathing
Flax Seeds	Hives, anaphylaxis, difficulty breathing
Chia Seeds	Hives, anaphylaxis, difficulty breathing
Pumpkin Seeds	Hives, anaphylaxis, difficulty breathing
Hemp Seeds	Hives, anaphylaxis, difficulty breathing
Quinoa	Hives, anaphylaxis, difficulty breathing
Amaranth	Hives, anaphylaxis, difficulty breathing
Buckwheat	Hives, anaphylaxis, difficulty breathing
Millet	Hives, anaphylaxis, difficulty breathing
Teff	Hives, anaphylaxis, difficulty breathing
Sorghum	Hives, anaphylaxis, difficulty breathing
Barley	Hives, anaphylaxis, difficulty breathing
Rye	Hives, anaphylaxis, difficulty breathing
Spelt	Hives, anaphylaxis, difficulty breathing
Kamut	Hives, anaphylaxis, difficulty breathing
Durum Wheat	Hives, anaphylaxis, difficulty breathing
Einkorn Wheat	Hives, anaphylaxis, difficulty breathing
Farro	Hives, anaphylaxis, difficulty breathing
Triticale	Hives, anaphylaxis, difficulty breathing