|
|
|
|
|
by Mister_Snuggles
3725 days ago
|
|
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... |
|