Last post Nov 20, 2014 10:29 AM by AidyF
Nov 20, 2014 09:00 AM|missy786|LINK
I am trying figure out, what tables i require to create a application, where users can add art items into a their portfolio. I am using a Shopping Cart framework, to base my model upon and this what I have so for database table schema:
I would be inserting the new entries for each user's portfolio, into the 'art_portfolio' table, is this correct? Would I need a junction table, as the entity relationship between art_items and users, is a many-to-many?
Please advice further. Thank you for your time and help.
Nov 20, 2014 10:29 AM|AidyF|LINK
First question I'd ask is if there *is* a many to many relationship between items and users. Isn't there no relation between items and users? There is a one to many between users and portfolio and a one to many between portfolio and items.