Re: How to store/manage tags?

On 13/07/2019 11:09, ^Bart wrote:
> I need to store tags in a db, for example about restaurants, like
> romantic, sea view, etc., I thought to do something like this:
>
> restaurants
> ---------------
> id_restaurant
> name
>
> tags
> ---------------
> id_tag
> name
>
> restauranttags
> --------------
> id_restauranttag
> FK_id_restaurant
> FK_id_tag
>
> Do you have other ideas?
>

[Quoted] No. that is the way to manage many to many relationships But you left out the tag text. like 'sea view' etc.

> Regards.
> ^Bart

-- 
There is something fascinating about science. One gets such wholesale 
returns of conjecture out of such a trifling investment of fact.

Mark Twain