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

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