Data Models

A DataFakery project can have multiple 'Data Models.' These are containers that include all the tables, columns, and their Faker configurations for a specific database connection. For instance, in an anonymization project for a Microsoft SQL database, all SQL objects, such as tables and views, used in the project will be referenced in an SQL Data Model. Each Data Model has a database connection, allowing the use of different database connections, such as MySQL and Microsoft SQL Server, within the same project.

By default, every DataFakery project includes a 'Virtual Tables' Data Model. This is because, when anonymizing data, mapping tables or auxiliary tables that are not stored in the database but are necessary for expressions can also be used. Within the 'Virtual Tables' Data Model, any number of virtual tables can be created. Virtual tables are structured like ordinary tables but, for simplicity, have no data types. Therefore, each column can contain any data type.