June 20th, 2013, 03:54 AM
Question & List Database Structure
I'm making a website in which there's a table with questions.. And the user can make lists.. these list have questions that the user can choose from the questions list.
So i'm thinking, what's the best way to achieve this.
Lists -> id, name
Questions -> id, name
ListsQuestions -> list_id, questions_id
June 20th, 2013, 04:32 AM
June 20th, 2013, 04:33 AM
Allright. So what's the name of this kind of way of tables? these are not subtables right?
Originally Posted by r937
June 20th, 2013, 07:28 AM
there are many names for this concept:
i prefer to say relationship table
- relationship table
- association table
- many-to-many table
- intersection table
- cross-reference table
- junction table
Comments on this post