Relational database schema

Overview

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 Using Form Runner with a relational database.

Tables

Table Name

Description

See also

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.

Organization-based permissions

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 (except for Oracle where it is a sequence).

Organization-based permissions

The orbeon_form_definition and orbeon_form_definition_attach also hold published section template libraries and their attachments if any.
The orbeon_form_data and orbeon_form_data_attach tables also hold unpublished form definitions, unpublished libraries, as well as form templates, and their attachments if any. These form definitions, libraries, and form templates are visible when you go to the Form Builder Summary page. You can edit them with Form Builder.

See also:

Sequences

Sequence Name

Description

orbeon_seq

Oracle database only: Used to generate organization IDs and form data IDs.

Current DDL

Introduction

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.

For a list of supported Orbeon Forms versions, see Release History.

Oracle

Orbeon Forms version(s)

DDL to create from scratch

DDL to upgrade from previous format

2024.1 and newer

oracle-2024_1.sql

oracle-2019_1-to-2024_1.sql

2022.1 to 2023.1

oracle-2019_1.sql

oracle-2018_2-to-2019_1.sql

MySQL

Orbeon Forms version(s)

DDL to create from scratch

DDL to upgrade from previous format

2024.1 and newer

mysql-2024_1.sql

mysql-2019_1-to-2024_1.sql

2022.1 to 2023.1

mysql-2019_1.sql

mysql-2018_2-to-2019_1.sql

SQL Server

Orbeon Forms version(s)

DDL to create from scratch

DDL to upgrade from previous format

2024.1 and newer

sqlserver-2024_1.sql

sqlserver-2023_1-to-2024_1.sql

2023.1

sqlserver-2023_1.sql

sqlserver-2019_1-to-2023_1.sql

2022.1

sqlserver-2019_1.sql

sqlserver-2017_2-to-2019_1.sql

PostgreSQL

Orbeon Forms version(s)

DDL to create from scratch

DDL to upgrade from previous format

2024.1 and newer

postgresql-2024_1.sql

postgresql-2023_1-to-2024_1.sql

2023.1

postgresql-2023_1.sql

postgresql-2019_1-to-2023_1.sql

2022.1

postgresql-2019_1.sql

postgresql-2018_2-to-2019_1.sql

DB2

Orbeon Forms version(s)

DDL to create from scratch

DDL to upgrade from previous format

2022.1 and newer

db2-2017_2-to-2019_1.sql

Historical DDL

Introduction

The following sections list the DDL (Data Definition Language) files for older and non-supported versions of Orbeon Forms.

For a list of supported Orbeon Forms versions, see Release History.

Oracle

Orbeon Forms version(s)

DDL to create from scratch

DDL to upgrade from previous format

2019.1 to 2021.1

oracle-2019_1.sql

oracle-2018_2-to-2019_1.sql

2018.2

oracle-2018_2.sql

oracle-2017_2-to-2018_2.sql

2017.2, 2018.1

oracle-2017_2.sql

oracle-2017_1-to-2017_2.sql

2017.1

oracle-2017_1.sql

oracle-2016_3-to-2017_1.sql

2016.3

oracle-2016_3.sql

oracle-2016_2-to-2016_3.sql

2016.2

oracle-2016_2.sql

oracle-4_10-to-2016_2.sql

4.10, 2016.1

oracle-4_10.sql

oracle-4_6-to-4_10.sql

4.6, 4.7, 4.8, 4.9

oracle-4_5-to-4_6.sql

4.5

oracle-4_4-to-4_5.sql

4.4

oracle-4_3-to-4_4.sql

4.3

-

MySQL

Orbeon Forms version(s)

DDL to create from scratch

DDL to upgrade from previous format

2019.1 to 2021.1

mysql-2019_1.sql

mysql-2018_2-to-2019_1.sql

2018.2

mysql-2018_2.sql

mysql-2017_2-to-2018_2.sql

2017.2, 2018.1

mysql-2017_2.sql

mysql-2016_3-to-2017_2.sql

2016.3, 2017.1

mysql-2016_3.sql

mysql-2016_2-to-2016_3.sql

2016.2

mysql-2016_2.sql

mysql-4_6-to-2016_2.sql

4.6 to 4.10, 2016.2

mysql-4_5-to-4_6.sql

4.5

mysql-4_4-to-4_5.sql

4.4

mysql-4_3-to-4_4.sql

4.3

-

SQL Server

Orbeon Forms version(s)

DDL to create from scratch

DDL to upgrade from previous format

2019.1 to 2021.1

sqlserver-2019_1.sql

sqlserver-2017_2-to-2019_1.sql

2017.2

sqlserver-2017_2.sql

sqlserver-2016_3-to-2017_2.sql

2016.3 to 2017.1

sqlserver-2016_3.sql

sqlserver-2016_2-to-2016_3.sql

2016.2

sqlserver-2016_2.sql

sqlserver-4_6-to-2016_2.sql

4.6 to 2016.1

sqlserver-4_6.sql

-

PostgreSQL

Orbeon Forms version(s)

DDL to create from scratch

DDL to upgrade from previous format

2019.1 to 2021.1

postgresql-2019_1.sql

postgresql-2018_2-to-2019_1.sql

2018.2

postgresql-2018_2.sql

postgresql-2017_2-to-2018_2.sql

2017.2, 2018.1

postgresql-2017_2.sql

postgresql-2016_3-to-2017_2.sql

2016.3 to 2017.1

postgresql-2016_3.sql

postgresql-2016_2-to-2016_3.sql

2016.2

postgresql-2016_2.sql

postgresql-4_8-to-2016_2.sql

4.8 to 2016.1

postgresql-4_8.sql

-

DB2

Orbeon Forms version(s)

DDL to create from scratch

DDL to upgrade from previous format

2019.1 to 2021.1

db2-2017_2-to-2019_1.sql

2017.2 to 2018.2

db2-2016_3-to-2017_2.sql

2016.3 to 2017.1

db2-2016_2-to-2016_3.sql

2016.2

db2-4_6-to-2016_2.sql

4.6 to 2016.1

db2-4_4-to-4_6.sql

4.4 to 4.5

db2-4_3-to-4_4.sql

4.3

-

See also

PreviousUsing a relational database NextPurging old data using SQL

Last updated 2 months ago