Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
Confluence
Teams
, (opens new window)

Requirement Yogi (Data Center)
Results will update as you type.
  • Getting Started - Tutorials
  • Administrator's guide
    • Configuration
    • Maintenance guide
    • Limitations
    • Migration to the Cloud
    • Requirement Yogi Cloud vs Data Center
    • Backup, import and export of Requirement Yogi data across Confluence and Jira instances
      • What are the steps of export / re-import?
      • How to carefully perform the mappings for the backup import/export step?
      • Checking that the Jira mappings are correct
      • Cleaning up links to non-existing Jira issues
      • Backup file structure
      • Database schema for Confluence backups
      • Database schema for Jira backups
      • Deleting the results of an incorrect import in Jira
    • Database schema
    • Changing Applinks
    • Performance
    • Copying, Splitting and Moving pages
    • Choosing the indexing engine
    • Notifications
    • Data Center SLA / Escalation process
    • History - Administrator's guide
  • Features
  • Requirement Yogi for Jira
  • RY Testing and Compliance
  • Integrations
  • APIs
  • Release notes
  • Archives (Legacy Features)
    Calendars
You‘re viewing this with anonymous access, so some content might be blocked.
/
Database schema for Jira backups
Updated Jan 04, 2024

    Database schema for Jira backups

    Generated for RY 3.7.1 with DatabaseDocumentationJUnit.

    Table AO_42D05A_DBREMOTEREQUIREMENT

    Table AO_42D05A_DBREMOTEREQUIREMENT

    #0   schemaversion

    Integer

    #1   applink

    String (pk) mapped by ApplinkMapper

    #2   spacekey

    String (pk) mapped by ConfluenceSpaceKeyMapper

    #3   key

    String (pk)

    #4   baseline

    Integer (pk)

    #5   flagdeleted

    boolean

    #6   lastsynchronization

    Date

    #7   publicdescription

    boolean

    #8   htmlexcerpt

    String

    #9   textexcerpt

    String

    Table AO_42D05A_DBISSUELINK

    Table AO_42D05A_DBISSUELINK

    #0   schemaversion

    Integer

    #1   issueid

    Long (pk) mapped by IssueMapper

    #2   issuekey

    String

    #3   relationship

    String (pk)

    #4   requirement

    DBRemoteRequirement (pk)

    Table AO_42D05A_DBAUDITTRAIL

    Table AO_42D05A_DBAUDITTRAIL

    #0   schemaversion

    Integer

    #1   issuenumber

    Long mapped by IssueMapper

    #2   issuekey

    String

    #3   userkey

    String mapped by UserMapper

    #4   iuserkey

    String

    #5   iusername

    String

    #6   difftimestamp

    Date

    #7   json

    String

    #8   notified

    boolean

    Table AO_42D05A_DBINTEGRATION (not in backups)

    Table AO_42D05A_DBINTEGRATION (not in backups)

    schemaversion

    Integer

    iD

    long

    upgrademode

    String

    userkey

    String

    applink

    String

    version

    Integer

    Table AO_42D05A_DBAPPLINK (not in backups)

    Table AO_42D05A_DBAPPLINK (not in backups)

    schemaversion

    Integer

    iD

    long

    applinkid

    String mapped by ApplinkMapper

    serviceid

    String

    displayurl

    String

    status

    String

    rpcurl

    String

    userKey

    String

    version

    Long

    label

    String

    Table AO_42D05A_DBQUEUE (not in backups)

    Table AO_42D05A_DBQUEUE (not in backups)

    schemaversion

    Integer

    iD

    long

    applinkid

    String mapped by ApplinkMapper

    lastresponse

    String

    queuekey

    String

    queueversion

    Integer

    ownerkey

    String

    nextretry

    Date

    progresspercent

    Integer

    lastcheckdate

    Date

    progressmarker

    String

    creationdate

    Date

    status

    String

    json

    String

    subject

    String

    retries

    Integer

    Table AO_42D05A_DBQUEUEMESSAGE (not in backups)

    Table AO_42D05A_DBQUEUEMESSAGE (not in backups)

    schemaversion

    Integer

    iD

    long

    lastResponse

    String

    status

    String

    json

    String

    userkey

    String

    applink

    String

    type

    Method

    Table AO_42D05A_DBJIRACACHE (not in backups)

    Table AO_42D05A_DBJIRACACHE (not in backups)

    schemaversion

    Integer

    iD

    long

    applinkid

    String mapped by ApplinkMapper

    creationdate

    Date

    projectid

    Long

    issuetypeid

    Long

    json

    String

    userkey

    String

    key

    String

    type

    String

    Table AO_42D05A_DBOPERATIONJOB (not in backups)

    Table AO_42D05A_DBOPERATIONJOB (not in backups)

    schemaversion

    Integer

    iD

    long

    warnings

    String

    status

    Status

    userkey

    String

    applink

    String

    errors

    String

    info

    String

    Table AO_42D05A_DBBACKUPITEM (not in backups)

    Table AO_42D05A_DBBACKUPITEM (not in backups)

    schemaversion

    Integer

    iD

    long

    backupkey

    String

    newid

    Long

    json

    String

    oldid

    Long

    type

    BackupRecordType

    Table AO_42D05A_DBBACKUPMAPPING (not in backups)

    Table AO_42D05A_DBBACKUPMAPPING (not in backups)

    schemaversion

    Integer

    iD

    long

    ceoversion

    Long

    issuekey

    String

    extensiondocumentid

    String

    destinationvalue

    String

    destinationhumanvalue

    String

    backupkey

    String

    dependencies

    String

    spacekey

    String

    username

    String

    status

    MappingStatus

    ceotype

    String

    title

    String

    ceoid

    Long

    userkey

    String

    applink

    String

    url

    String

    key

    String

    type

    Type

    Table AO_42D05A_DBUSAGESTATS (not in backups)

    Table AO_42D05A_DBUSAGESTATS (not in backups)

    schemaversion

    Integer

    iD

    long

    date

    Date

    value

    Long

    type

    String

    {"serverDuration": 18, "requestCorrelationId": "5abaa55770b14019b53cda0a0604aa24"}