Aaron Snyder
Member since Jan 15, 2014
- Profile: /members/11550-aaron-snyder.htm
- Comments: 3
Recent Blog Comments By Aaron Snyder
-
How To Store Arbitrary And Transient Attributes With Your User Data
Posted on Jan 15, 2014 at 11:05 AM
Ooops, meant to have column 2 called "eventTypeName"...you get the point... read more »
-
How To Store Arbitrary And Transient Attributes With Your User Data
Posted on Jan 15, 2014 at 11:03 AM
@Ben, Exactly. It's a more generic design, and scales pretty well. As a slight modification, you might add a "user_event_type" table, and store it's id on your "user_event" table. user_event: ----------- * userID (ex. 4) * eventTypeID (ex. 2) * occurredAt (ex 2014/01/15) use... read more »
-
How To Store Arbitrary And Transient Attributes With Your User Data
Posted on Jan 15, 2014 at 10:26 AM
I don't know that specific user activities deserve their own DB table. With this design, you'd inevitably end up with "remarket_video_viewing" and "email_popup_viewing" tables as well. You'd find yourself with and endless list of "_viewing" tables. Might be better to re... read more »