Jira Schema Tables

Jira stores data in structures which do not follow the rules of data typing and structure that apply to traditional relational tables and columns. Because traditional JDBC toolsets might not support these data structures, the data needs to be mapped to a relational form. To achieve this, the Simba Jira JDBC Connector uses schema tables to map the Jira data to a format that is compatible with JDBC.

The schema tables are listed alphabetically by table name. For each table, the following information is provided:

• The name of the table.
• Whether the table is a virtual table, and if so, the table that it is contained in.
• Whether the table contains any virtual tables, and if so, which ones.
• Any of the columns in the table that are foldable, that is, whether operations on those columns can be delegated to the server instead of the client.
• A list of all of the columns in the table, with information about the SQL type and whether the column is nullable or updatable.