1
I’m making a stock system and modeling, instead of each item having its attributes defined I wanted to make four tables tags (tag_decimal, tag_data, tag_text, tag_boolean) that pointed to the item table.
Since I’ve never seen this in my class I was wondering if it’s out of the ordinary, or have any problems.
It would be better to show this to us to see the whole context better. Right or wrong always depends on context.
– Maniero
Might as well, but think about what the appointments are going to be, which is almost certain to be a full Outer Join
– FourZeroFive
An excessive amount of Outer joins weigh the requests? I’ll put the context, thanks for the warning
– V A P O R D E A D
I just saw the image, the way you are doing can cause problems, I thought you are wanting to make an entity item and there was only a single entity of tags that would contemplate(tag_decimal, tag_data, tag_text, tag_boolean), so an item has 1:1 and a tag has 1.1 items
– FourZeroFive
I ended up using only text tag same, thanks for the personal help.
– V A P O R D E A D