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
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