Profile / Allergens

[micdra01]

• [x] Checkboxes til allergener
• [x] Typescript der samler til liste og rammer API
• [ ] API endpoint
• [x] DB tabel til allergener

[micdra01]

Baseret på https://www.food.gov.uk/sites/default/files/media/document/top-allergy-types.pdf

[micdra01]

CREATE TABLE IF NOT EXISTS allergenedb.allergens( id SERIAL PRIMARY KEY, name VARCHAR(50) NOT NULL );

INSERT INTO allergenedb.allergens (name) VALUES ('celery'),('crustaceans'),('eggs'),('fish'),('gluten'),('lupin'),('milk'),('molluscs'),('mustard'),('nuts'),('peanuts'),('sesame_seeds'),('soya'),('sulphites');

CREATE TABLE IF NOT EXISTS allergenedb.user_allergens ( user_id INTEGER REFERENCES allergenedb.users(id), allergen_id INTEGER REFERENCES allergenedb.allergens(id), PRIMARY KEY (user_id, allergen_id) );

INSERT INTO allergenedb.user_allergens (user_id, allergen_id) SELECT 3 AS user_id, id AS allergen_id FROM allergenedb.allergens;