Databases
StackOverflow2013
Postsdbo
POCan a many-to-many join table have more than two columns?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCan a many-to-many join table have more than two columns?
    primarykey
    data
    text
    <p>I have some tables that benefit from many-to-many tables. For example the team table.</p> <p>Team member can hold more than one 'position' in the team, all the positions are listed in the position db table. The previous positions held are also stored for this I have a separate table, so I have</p> <ul> <li>member table (containing team details)</li> <li>positions table (containing positions)</li> <li>member_to_positions table (id of member and id of position)</li> <li>member_to_previous_positions (id of member and id of position)</li> </ul> <p>Simple, however the crux comes now that a team member can belong to many teams aghhh. I already have a team_to_member look-up table. Now the problem comes how do I tie a position to a team? A member may have been team leader on one team, and is currently team radio man and press officer on a different team. How do I just pull the info per member to show his current position, but also his past history including past teams. Do I need to add a position_to team table and somehow cross reference that, or can I add the team to the member to positions table?</p> <p>It's all very confusing, this normalization.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USTom H
    1. USPaul M
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCan a many-to-many join table have more than two columns?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POCan a many-to-many join table have more than two columns?
      1. USPaul M
      1. VTFavorite
    3. VO
      singulars
      1. POCan a many-to-many join table have more than two columns?
      1. USAmit Erandole
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload