Basic SharePoint's tables in Content Database

Here is the list of the basic SharePoint's tables in Content Database

Features: information about all the activated features for each site collection or site.
Sites : information about all the site collections for this content database.
Webs : information about all the specific sites (webs) in each site collection.
UserInfo : information about all the users for each site collection.
Groups : information about all the SharePoint groups in each site collection.
Roles : information about all the SharePoint roles (permission levels) for each site.
AllLists : information about lists for each site.
GroupMembership : information about all the SharePoint group members.
AllUserData : information about all the list items for each list.
AllDocs : information about all the documents (and all list items) for each document library and list.
RoleAssignment : information about all the users or SharePoint groups that are assigned to roles.
SchedSubscriptions : information about all the scheduled subscriptions (alerts) for each user. ImmedSubscriptions : information about all the immediate subscriptions (alerts) for each user.

Enjoy Green coding using code4green.com