Hi, where can I find table descriptions that are created by default by applications? For example backend_users, cache, cms_theme_templates, system_settings etc.

Last updated 4 years ago

Not sure that exists yet, but you may find this in the source code using the grep command on linux:

$ grep -r " .table = '" modules/
modules/system/models/RequestLog.php:    protected $table = 'system_request_logs';
modules/system/models/Parameter.php:    protected $table = 'system_parameters';
modules/system/models/MailTemplate.php:    protected $table = 'system_mail_templates';
modules/system/models/MailLayout.php:    protected $table = 'system_mail_layouts';
modules/system/models/File.php:    protected $table = 'system_files';
modules/system/models/PluginVersion.php:    public $table = 'system_plugin_versions';
modules/system/models/MailPartial.php:    protected $table = 'system_mail_partials';
modules/system/models/EventLog.php:    protected $table = 'system_event_logs';
modules/system/models/Revision.php:    public $table = 'system_revisions';
modules/cms/models/ThemeExport.php:    public $table = 'cms_theme_data';
modules/cms/models/ThemeLog.php:    protected $table = 'cms_theme_logs';
modules/cms/models/ThemeData.php:    public $table = 'cms_theme_data';
modules/cms/models/ThemeImport.php:    public $table = 'cms_theme_data';
modules/backend/models/User.php:    protected $table = 'backend_users';
modules/backend/models/AccessLog.php:    protected $table = 'backend_access_log';
modules/backend/models/UserRole.php:    protected $table = 'backend_user_roles';
modules/backend/models/UserThrottle.php:    protected $table = 'backend_user_throttle';
modules/backend/models/UserGroup.php:    protected $table = 'backend_user_groups';
modules/backend/models/UserPreference.php:    protected $table = 'backend_user_preferences';