Designing a user-defined list to be stored in a relational database - Should I include user index?

Posted by Zaemz on Programmers See other posts from Programmers or by Zaemz
Published on 2013-10-21T17:13:01Z Indexed on 2013/10/21 22:03 UTC
Read the original article Hit count: 161

Filed under:
|
|

By index, I mean, as the user creates the list, each item receives an integer index for its place in that particular list. Since there will be a table of ListItems, I'd prefer to avoid using the name "Index" for the field.

Then I was thinking - should I even include the list index in the database? I figured I would because the list would be created in the same fashion every time, then. Or I could order the list for the user based on its actual primary key, since the list items are created in succession anyway...

What should I do?

© Programmers or respective owner

Related posts about design

Related posts about database