But where do you even put the price on a food item to start with? The only price is on the 'delivery' table, which seems to imply that the price is only set wh

But where do you even put the price on a food item to start with? The only price is on the 'delivery' table, which seems to imply that the price is only set when someone orders something. I guess this is a delivery-only place? But because the 'delivery' table can only have one food_uuid, you'd have to put in for a bunch of deliveries to order more than one thing. Maybe the 'price' on the menu is in that 'Additional Info' table? SELECT A.NAME, A.DESCRIPTION, B.VALUE FROM FOOD A LEFT OUTER JOIN "Additional Info" B ON (A.UUID = B.UUID AND B.TYPE = 'Price'); There's so much wrong here...