rtMedia Table Overview
rtMedia uses the following tables:
{wp_}rt_rtm_mediafor indexing media{wp_}rt_rtm_media_metafor storing metadata as key-value pairs.{wp_}rt_rtm_media_interactionfor storing data on actions carried out on media.{wp_}rt_rtm_activityfor storing rtMedia BuddyPress activity data.
{wp_}rt_rtm_media
Field Type null default key WP relation
| id | bigint(20) | NOT NULL | PRIMARY | ||
| blog_id | bigint(20) | NULL | NULL | blog_id | |
| media_id | bigint(20) | NOT NULL | KEY | post ID of attachment | |
| media_author | bigint(20) | NOT NULL | KEY | post_author | |
| media_title | text | post_title | |||
| album_id | bigint(20) | KEY | post_parent | ||
| media_type | varchar(100) | NULL | NULL | ||
| context | varchar(100) | NULL | NULL | post_type, current BuddyPress Component, custom | |
| context_id | bigint(20) | NULL | NULL | post ID, component ID | |
| activity_id | bigint(20) | NULL | NULL | BuddyPress activity ID | |
| cover_art | varchar(250) | NULL | NULL | media_id reference to {wp_}rt_rtm_media table | |
| privacy | int(3) | NULL | NULL | ||
| views | bigint(20) | NULL | 0 | ||
| downloads | bigint(20) | NULL | 0 | ||
| ratings_total | bigint(20) | NULL | 0 | ||
| ratings_count | bigint(20) | NULL | 0 | ||
| ratings_average | decimal(4,2) | NULL | 0 | ||
| likes | bigint(20) | NULL | 0 | ||
| dislikes | bigint(20) | NULL | 0 |
All Keys:
Following keys are defined for this table:
- PRIMARY KEY (id)
- KEY media_id (media_id)
- KEY media_author (media_author)
- KEY album_id (album_id)
- KEY media_author_id (album_id,media_author)
- KEY context_author_album_id (context_id,album_id,media_author)
- KEY context(context)
Description
id
The unique id for each media item, including albums. This media object is accessible at the /media/{id} REST endpoint from a valid context.
blog_id
The id of the blog in a multisite install. For single wordpress site this will be always set to 1.
media_id
This will always refer to a post_id from wp_posts table.
- For media files: The id of the attachment post_type
- For albums: The id of the post that is considered an album. Can be any post type or the inbuilt rt_media_album post type.
media_author The id of the author of the media. This has the same value as post_author for the media_id in the WordPress posts table. In short, this will be always set to the logged in user who is uploading media from the web-interface.
media_title The title for the media. This has the same value as post_title for the media_id in the WordPress wp_poststable.
album_id The id of the album, to which this media belongs.
- For media files: The post_parent in the WordPress table
- For albums: Default NULL. In future, when we add the parent-child album concept, this will be set to post_parent in the WordPress table.
media_type
- Any of the registered types
photo,audio,video,albumor a custom one. - rtMedia-PRO adds
playlist,docsandothersas media_type. context *The context associated with the media. *This could be any of the following:
WordPress:
- For Post type: post, page, etc
- For Comments: comment
- For Dashboard upload: dashboard
- bbPress topic or reply
- BuddyPress component: activity, group, profile
- WordPress Comment: comment
- A custom context
context_id The unique id for the context to differentiate among them. For example, for BuddyPress profiles upload, when context is set to profile, context_id will be set to buddypress profile_id (i.e. wordpress user_id). This can be NULL also for some context where differentiation is not required, e.g. dashboard uploads.
activity_id Default is NULL. The id of the activity generated if BuddyPress is active and the Activity component is enabled.
covert_art Default is NULL Used for media_type album, music and video only. For album, it is media_id in {wp_}rt_rtm_media table. For music and video, it is URL.
privacy Default is NULL. Used for BuddyPress Profile media tab. Valid values are:
- 0 = Public
- 20 = Logged-in/Registered-Users
- 40 = Friends
- 60 = Private
- _80 = in moderation queue. This will be changed to
For BuddyPress Groups and bbPress Forums, values are:
- 0 = public group/forum
- 60 = private/hidden group/forum
When uploading from BuddyPress Activity Stream Uploader, if upload is sent to “My Profile”, only the privacy value will be set as per above. For BuddyPress Group uploads, this privacy column is not used. Media visibility is controlled by Group’s visibility setting.
views
Default is 0. View count will be incremented by 1 for every single media view inside lightbox or from single-media page. Counter is incremented by AJAX call to reduce load on server and avoid cache-effects. Currently PHP sessions are used to identify unique views from a visitor. We plan to make this more robust and gaming-safe in future.
Another table {wp_}rt_rtm_media_interaction is used to store details about views and other interactions.
downloads
Default is 0. The download count is incremented for every download action on that media. This will only work if download option is enabled in rtMedia-PRO settings.
ratings-total
Default is 0. The total ratings received, each instance adding a percentage based value.
**ratings-count
Default is 0. The total number of times, a media item has received ratings.
ratings-average
Default is 0. The average ratings received upto 1 decimal digit.
likes
Default is 0. The total number of like interactions. If user unlike, previously liked post this will be decremented.
dislikes
Default is 0. The total number of dislike interactions. This is reserved for future thumbs-up/down (vote-up/vote-down) style functionality.
{wp_}rt_rtm_media_meta
Field Type
| meta_id | bigint(20) |
| media_id | bigint(20) |
| meta_key | varchar(255) |
| meta_value | longtext |
All Keys
PRIMARY KEY (meta_id)
Description
meta_idThe unique id for indexing.media_idThe id from the wp_rtm_media tablemeta_keyThe key of the key-value pairmeta_valueThe value of the key-value pair
{wp_}rt_rtm_media_interaction
Field Type null Default Key Extra
| id | bigint(20) | NOT NULL | PRIMARY | AUTO_INCREMENT | |
| user_id | bigint(20) | NOT NULL | 0 | KEY | |
| media_id | bigint(20) | NOT NULL | 0 | KEY | |
| action | varchar(255) | ||||
| value | varchar(255) | ||||
| action_date | TIMESTAMP | NULL | CURRENT_TIMESTAMP |
### All Keys * PRIMARY KEY (id), * KEY user_id(user_id), * KEY media_id(media_id) ### Description * `id` The unique id for indexing. * `user_id` The id of the user. * `media_id` The id from the _wp_rtm_media_ table. * `action` This could be a Like, Rating, or View. * `value` The value related to the action. * `action_date` The timestamp of the action. ## {wp_}rt_rtm_activity Field Type null Default Key Extra
| activity_id | bigint(20) | NULL | KEY | ||
| user_id | bigint(20) | NOT NULL | 0 | KEY | |
| privacy | int(3) | NULL | KEY | ||
| blog_id | bigint(20) | NULL | NULL |
All Keys
- KEY activity_id(activity_id),
- KEY user_id(user_id),
- KEY privacy(privacy)
Description
activity_idThe activity id of rtMedia activity.user_idThe id of the user.privacyPrivacy of this particular activity according to attached media.blog_idThe id of the blog in a multisite install. For single wordpress site, this will be always set to 1.