API:Database field and API property associations

This table shows some of the ways in which the , , , , and  tables are linked together and what properties from the  and  parts of the 8>Special:MyLanguage/API:Main page|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 </> because there was no closer match (except perhaps the user property); the recentchanges part of the API does not return a <tvar|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.