The data model pages describe the platforms that [[Invantive UniversalSQL]] connects to. They are generated from the driver of each platform, so they show what the software offers in the release named at the bottom of every page. ## Platform Page The page of a platform, such as `/en/datamodels/exactonline`, holds: - the introduction of the platform, with its authentication, its APIs and its limits, - the link to set the platform up in [[Invantive Cloud/Invantive Cloud|Invantive Cloud]] where that is possible, - how the data is partitioned, for example per Exact Online company, and whether text comparisons are case-sensitive, - the figures of the data model: tables, columns, tables that can be changed and tables that are documented, - the [[Invantive Cloud Documentation/Screens/Data Model Posters|poster]] of the data model, - the tables per schema, the popular ones first, - sample queries, - the link to the attributes of the driver, and the packages of the platform. ## Table Page The page of a table, view or table function, such as `/en/datamodels/exactonline/ExactOnlineREST.CRM.Accounts`, holds in this order: - The title with the label of the table. - Labels with what the table allows: the operations insert, update and delete, whether the data is kept per partition, whether changes arrive through a webhook, and the kind of API. - The catalog, schema and primary key, and a summary with the documentation and an example. - "API Source": the endpoint, metadata address, XML topic or path that the table reads. - "Performance Characteristics", where the driver records them, such as the number of rows a full read delivers per minute. - For a table function, its parameters with whether they are required and their default. - "Table Columns": per column its name and data type, its label, whether it is required, and marks for a column that filters on the platform, that is fetched by default, that can be changed or that is computed. A column that filters on the platform makes a query on that column faster. - "Keys" and "Referenced By": the relations to and from other tables, with their kind. - The code values of a table with fixed values, with their descriptions. - The sample queries that use the table. - At the bottom, the release of Invantive UniversalSQL and the date on which the data model was generated. The top of the page of the Exact Online table `Accounts`:  Names of tables, columns and data types are never translated. Labels and descriptions are shown in the language of the reader where a translation exists. ## Attributes Page The page `/{lang}/datamodels/{provider}/attributes` lists the attributes of a driver, grouped by category such as diagnostics, behaviour, performance, caching, authentication and connection. Each attribute shows its description, its default and where it can be set: in the connection string, with a `set` statement, in the provider file or at log on. Each attribute has its own anchor and is found by its code in the search.