In this discussion I propose we finally Review and Rename all incorrectly named Tables:
BanRules => UserBanRules, user ban rules (rarely used), might move from CORE to UserBans in the future.
Cache => SystemCache, used in CORE, propose to rename so it's more self-exlainatory
Category => Categories, used in CORE
CategoryCustomData - category custom field values CORE? Need to Rename?
CustomField => CustomFields, currently used in CORE, but may not be part of default install CORE in the future (after minimized)
Drafts => FormSubmissionReplyDrafts, currently used in CORE, but may not be part of default install CORE in the future (after minimized), proposed module - form submission drafts - Forms
Events => EmailEvents, used in CORE, propose to rename so it's more self-exlainatory
Favorites => CategoryItemFavorites - favorite category items and friend list (in in-bulletin) - CategoryItems
Images => CategoryItemImages, used for user/category/category item images – CORE? propose to rename so it's more self-exlainatory
ItemFiles => CategoryItemFiles, propose to rename so it's more self-exlainatory
ItemRating => CategoryItemRating, propose to rename so it's more self-exlainatory - category item ratings - CategoryItems
ItemReview => CategoryItemsReviews, propose to rename so it's more self-exlainatory- category item review - CategoryItems
Language => Languages, proper naming
PermCache => CategoryPermissionCache, used in CORE, category-based permission caching (because of inheritance)
PermissionConfig => CategoryPermissionConfig, used in CORE - list of all possible category-based permissions – CORE?
Permissions => CategoryPermissions, used in CORE - what permissions were set
Phrase => LanguagePhrases, used in CORE, list of labels - CORE
PhraseCache => LanguagePhrasesCache, used in CORE - way of caching label and phrase data based on visited template - CORE
PortalGroup => UserGroups, used in CORE, list of all groups
PortalUser => Users, used in CORE, list of users
PortalUserCustomData => UsersCustomData, used in CORE, list of users custom fields, data
RelatedSearches => CategoryRelatedSearches, used in CORE, but might be moved into separate Module in the future
Relationship => CategoryItemRelationships, used in CORE, category/category item relations – CategoryItems or Relationships
SearchConfig - front-end search configuration settings – CORE or Search
SearchLog => SearchLogs, used in CORE - list of search queries, used on Front-end - Logs
SessionData => UserSessionData, used in CORE - user session-specific data - CORE
SessionLogs => UserSessionLogs, used in CORE - session usage log - Logs
Skins => AdminSkins - admin skinning support - CORE
SubmissionLog => FormSubmissionReplies, used in CORE - list of messages, associated with a form submissions - Forms
Theme => Themes, used in CORE - list of front-end themes - CORE
UserGroup => UserGroupRelations, used in CORE - what user is in what group - CORE
UserSession => UserSessions, used in CORE - list of active user sessions - CORE
Visits => UserVisits, used in CORE - attempt to create simplified google analytics, but isn't used - Logs
It's only the CORE for now.