schema

In database work, the schema is the design of the database – a set of table definitions and rules that delineate the structure of the data within the database and the aspects of the relational integrity of the data that must be maintained.

Within Archibus, the definition of schema is expanded to include other properties necessary for working with data. These definitions are stored in the database, in tables beginning with the prefix  "Archibus", such as the Archibus Processes table (afm_processes).

The schema includes the following types of tables:

• data dictionary tables
• application dictionary tables
• project security tables
• project application data tables
• Navigator tables

The same schema can underlie a number of project databases.

When you create a new project database, the project tables (such as Buildings or Work Requests) are empty so that you can enter your own data, but the schema tables are completed so that they can define the default Archibus behavior and the default database.

See also project database.