Relational database schema
Last updated
Last updated
Orbeon Forms uses, out of the box, a relational database persistence provider. This page describes the purpose of the tables and sequences used by this provider, as well as points to current and historical DDL (Data Definition Language) files for the supported versions of Orbeon Forms.
For more about the relational database setup, see .
orbeon_form_definition
Holds published form definitions.
orbeon_form_definition_attach
Holds attachments related to published form definitions.
orbeon_form_data
Holds saved and draft form data.
orbeon_form_data_attach
Holds attachments associated with submitted form data.
orbeon_form_data_lease
Holds information about active leases on form data.
orbeon_organization
Holds information about organizations.
orbeon_i_current
Holds references to the current form data, as opposed to historical data.
orbeon_i_control_text
Holds the values of indexed form controls for search and the Summary page.
orbeon_seq
Used to generate organization IDs (all databases) and form data IDs (Oracle-only as of Orbeon Forms 2024.1).
The following sections list the DDL (Data Definition Language) files for the latest supported versions of Orbeon Forms. The DDL files are used to create the database schema from scratch or to upgrade an existing schema to a newer version.
2024.1 and newer
2022.1 to 2023.1
2024.1 and newer
2022.1 to 2023.1
2024.1 and newer
2023.1
2022.1
2024.1 and newer
2023.1
2022.1
2022.1 and newer
The following sections list the DDL (Data Definition Language) files for older and non-supported versions of Orbeon Forms.
2019.1 to 2021.1
2018.2
2017.2, 2018.1
2017.1
2016.3
2016.2
4.10, 2016.1
4.6, 4.7, 4.8, 4.9
4.5
4.4
4.3
-
2019.1 to 2021.1
2018.2
2017.2, 2018.1
2016.3, 2017.1
2016.2
4.6 to 4.10, 2016.2
4.5
4.4
4.3
-
2019.1 to 2021.1
2017.2
2016.3 to 2017.1
2016.2
4.6 to 2016.1
-
2019.1 to 2021.1
2018.2
2017.2, 2018.1
2016.3 to 2017.1
2016.2
4.8 to 2016.1
-
2019.1 to 2021.1
2017.2 to 2018.2
2016.3 to 2017.1
2016.2
4.6 to 2016.1
4.4 to 4.5
4.3
-
For a list of supported Orbeon Forms versions, see .
For a list of supported Orbeon Forms versions, see .