|
The _link table is a standard many-to-one SQL link table. It matches book_ids to the data table ID. Nothing in this table should be interpreted as a rating. The data table contains the actual rating value, referenced by the data table ID which in this case is a row number.
The order of rows in a _link table depends on the order that values were created and deleted. For example, it should be that if you remove rating X from all books then all those books will disappear from the _link table and the line containing X will disappear from the data table. If you later add X to some book then a line will appear at the end of the _link table and X will appear at the end of the data table with a new row number.
|