Top => resps_seen   How much has each user seen of each item?

Categories: Responses 

Notes:  Tracks which users have seen which (how many) responses on which items. This acts like a high-water mark, i.e. if resps_seen.seen is 17, then response numbers 0 through 17 are "seen", and any higher-numbered responses are "new".

Name Type Index Null? Default
userid varchar(240) (pk) No '' FK user_info
items_id int(11) (pk) No '0' FK items
seen int(11) NULL how many responses in the item has the user seen?
forgot tinyint(4) '0' 1 = user has forgotten the entire item