| Info |
|---|
This article is for Tempo for Data Center. |
| Note |
|---|
Disclaimer: Tempo may change the format/layout of database tables at any time and does not support any direct access nor manipulation of the data, even though you can do so with a little SQL knowledge. Should you need any consultation on database querying, please contact Atlassian Support for more info. Also, this is outside of Tempo Support scope. Should you have any questions, please join Tempo Slack Ecosystem to consult with other developers. Always run a backup of database before making any changes on the Data Center. |
...
Tempo does not remove any old tables from the older versions. Therefore, you may see some tables with old data or no data, other than the ones you are actually using in the current version. In this article, we will only mention the active tables of the latest version and not any obsolete/deprecated tables.
...
Plugin Key | Table Name | Tempo Data |
|---|---|---|
Tempo Timesheets | AO_86ED1B_GRACE_PERIOD_V2 | Granted Grace Periods |
AO_86ED1B_PERIOD | Periods in Period Management | |
AO_86ED1B_PERIOD_CONFIG | Rules in Period Configuration | |
AO_86ED1B_TIMESHEET_APPROVAL | Timesheet Approval action log * | |
AO_86ED1B_WORKLOG_EXT_PROP | Servlet API External log |
*For timesheet approval status on Tempo worklogs, it’s recommended to use Tempo Servlet API to retrieve data. However, for any reason, using Servlet API is not an option, you can query the approval periods from AO_86ED1B_TIMESHEET_APPROVAL (see details below) and join with worklog table.
...