You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm new to sqlite so may be missing something. A dump of the tables gives:
[('survey',), ('generations',), ('images',), ('sqlite_sequence',), ('paths',), ('ratings',), ('upscales',)]
I look in ratings and find:
['sid', 'iid', 'rating', 'verified']
I match the sid to the id in the survey table which has:
['id', 'qid', 'rating']
I've sampled each table and do not see the questions that correspond to the qid in the survey table.
The text was updated successfully, but these errors were encountered:
Hi, I have the same question with you. Have you figured out what are the columns mean for each table, especially for "ratings" (sid, iid, rating, verified)?
Thanks a lot for answering! In my understanding, "ratings.sid" represents the user who scores the image. Moreover, I'm wondering that how to explain the same ("ratings.sid", "ratings.iid") have various "ratings.rating"s.
I'm new to sqlite so may be missing something. A dump of the tables gives:
[('survey',), ('generations',), ('images',), ('sqlite_sequence',), ('paths',), ('ratings',), ('upscales',)]
I look in ratings and find:
['sid', 'iid', 'rating', 'verified']
I match the sid to the id in the survey table which has:
['id', 'qid', 'rating']
I've sampled each table and do not see the questions that correspond to the qid in the survey table.
The text was updated successfully, but these errors were encountered: