Confirmed users
1,201
edits
BMO/UserProfiles: Difference between revisions
Jump to navigation
Jump to search
→Schema
(→Schema) |
|||
| Line 161: | Line 161: | ||
* id ''identity'' | * id ''identity'' | ||
* user_id ''fk profile.userid'' | * user_id ''fk profile.userid'' | ||
* product_id ''fk products.id'' | * product_id ''fk products.id'' (when NULL, refers to 'other' products) | ||
* count ''int'' | * count ''int'' | ||
new fields: | new fields: | ||
* profiles.mozillians_id ''varchar64'' (mozillians.org username) | * profiles.mozillians_id ''varchar64'' (mozillians.org username) | ||
* profiles.last_activity_ts ''datetime'' timestamp of most recent update, comment, etc | * profiles.last_activity_ts ''datetime'' timestamp of most recent update, comment, etc | ||