The Custom tables module uses the following database tables:

 

•CMS_Class - custom tables are stored as classes in the system database, this database table is used for storing information about classes.

•CMS_ClassSite - this table is used to assign classes (and therefore also custom tables) to particular sites in the system.

•CMS_Query - contains records representing SQL queries for operations with data in custom tables, along with other queries used by the system.

•CMS_Transformation - contains records representing transformations for custom tables data, as well as other transformations used by the system.

•CMS_AlternativeForm - contains records representing alternative forms for particular custom tables, together with other alternative forms used by the system.

•<prefix>_<table code name> - particular custom tables are stored as standard tables in the system database. You can distinguish them by giving them a descriptive prefix, while the customtable_ prefix is used by default.