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_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