I always search my problem with different search terms but the problem I am facing now I can't express this in search keyword. So instead I came here to ask directly from humans as machines were unable to what I exactly means.
So coming to scenario:
I have database with having
table_item has many items. User come and add item(s). Later other user came and
link one item with different item via a form with two
What I did so far is:
Structure of `table_item`: - item_id (Primary) - others..
Structure of `table_item_linked`: - linked_id (Primary) - item_id (Foreign key referencing -> item_id of table_item) - linked_items (here I need to store ids of linked items) - linked_by (referencing to user_id of user_table) - linked_timestamp (timestamp)
If I have items like:
When I link
I can successfully fetch
G when I am fetching
D or vice versa. But problem came when I
So I must fetch
H while fetching
It is like a multiple relation.
Guys I know there must be professional way to do it. I will like to have any guidance. I can even change my database structure.
PS: Please don't suggest to add #tag as one item is exactly similar to the other linked.