Start page / Templates (basics) / Composition of templates / Database schemata

Structure of database schemata

FirstSpirit has powerful mechanisms for connecting databases. A graphical schema editor can be used to create and modify database tables, define templates for maintaining and displaying datasets and formulate queries for filtering the datasets. To support this, a database abstraction layer that maps the universal FirstSpirit content type system to the specific database system to be used has been implemented by FirstSpirit.

The procedure for adding and editing a database schema is described in detail in the following chapters:

  • Adding a schema: Either a new schema can be created in the database or a schema can be generated on the basis of an existing database schema.
  • Schema editor: The desired database schema can be modeled using the graphical editor.
  • Table templates: These connect the tables of a database schema to the data input by the editor.
  • Queries: The number of datasets output for a data source can be restricted.

© 2005 - 2022 Crownpeak Technology GmbH | All rights reserved. | FirstSpirit 2023.1 | Data privacy