API:Database field and API property associations

This table shows some of the ways in which the logging, page, recentchanges, revision, and text tables are linked together and what properties from the recentchanges and revisions parts of the API are associated with them.

Sometimes there is not an exact match between items on the same row of this table, but they are related in some way. E.g., the "anon" property provides useful information about the user who took an action. It is put in the same row as rc_user because there was no closer match (except perhaps the user property); the recentchanges part of the API does not return a user id. Fields marked in sky blue are obsolete. Fields marked in pink are those that appear to be inaccessible via API. Fields marked in yellow are those that are an inexact match.