Database schema for Confluence backups

Table AO_32F7CE_DBREQUIREMENT
#0 schemaversion	Integer
#1 spacekey	String mapped by SpaceMapper
#2 key	String
#3 baseline	Integer
#4 status	String
#5 htmlexcerpt	String
#6 htmlflag	Integer
#7 hash	Integer
#8 newspacekey	String
#9 newkey	String
#10 creationuser	String mapped by UserMapper
#11 creationdate	Date
#12 lastupdateduser	String mapped by UserMapper
#13 lastupdateddate	Date
#14 storagetype	Integer

Table AO_32F7CE_DBLINK
#0 schemaversion	Integer
#1 parent	DBRequirement
#2 origin	boolean
#3 relationship	String
#4 type	String
#5 app	String mapped by DocumentMapper
#6 documentid	String mapped by DocumentMapper
#7 documentversion	String mapped by DocumentMapper
#8 marker	String
#9 title	String
#10 dependency	DBDependency
#11 creationdate	Long
#12 issuetemplate	DBIssueTemplate

Table AO_32F7CE_DBBASELINE
#0 schemaversion	Integer
#1 baseline	Integer
#2 spacekey	String mapped by SpaceMapper
#3 status	String
#4 name	String
#5 pageid	Long mapped by PageMapper
#6 searchquery	String
#7 refreezeproperties	String
#8 parentbaseline	Integer
#9 creator	String mapped by UserMapper
#10 requirementcount	Integer
#11 pagecount	Integer
#12 model	int
#13 history	String
#14 progress	String

Table AO_32F7CE_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_32F7CE_DBSETTINGS
#0 schemaversion	Integer
#1 property	String (pk)
#2 spacekey	String (pk) mapped by SpaceMapper
#3 userkey	String (pk) mapped by UserMapper
#4 value	String
#5 preloaded	boolean

Table AO_32F7CE_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_32F7CE_DBBACKUPITEM (not in backups)
schemaversion	Integer
iD	long
backupkey	String
newid	Long
json	String
oldid	Long
type	BackupRecordType

Table AO_32F7CE_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_32F7CE_DBISSUE_TEMPLATE
#0 schemaversion	Integer
#1 applinkid	String mapped by ApplinkMapper
#2 title	String
#3 projectid	Long mapped by JiraProjectIdMapper
#4 projectmetadata	String
#5 issuetypeid	Long
#6 relationship	String
#7 fields	String
#8 spacekey	String mapped by SpaceMapper
#9 groupall	boolean

Table AO_32F7CE_DBTRACEABILITYMATRIX
#0 schemaversion	Integer
#1 originalid	Long
#2 title	String
#4 spacekey	String mapped by SpaceMapper
#5 searchquery	String
#6 description	String
#7 traceabilitymatrixcolumns	String
#8 withjira	boolean
#9 flushjiracache	boolean
#10 includebaselined	boolean
#11 crossspace	boolean
#12 permissions	String
#13 userkey	String
#14 type	String

Table AO_32F7CE_DBKEYSUGGESTION
#0 schemaversion	Integer
#1 spacekey	String mapped by SpaceMapper
#2 uniquekey	String
#3 prefix	String
#4 suffix	String
#5 current	Long
#6 padding	Integer

Table AO_32F7CE_DBUSAGESTATS (not in backups)
schemaversion	Integer
iD	long
date	Date
value	Long
type	String

Table AO_32F7CE_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_32F7CE_DBQUEUEMESSAGE (not in backups)
schemaversion	Integer
iD	long
lastResponse	String
status	String
json	String
userkey	String
applink	String
type	Method

Table AO_32F7CE_DBOPERATIONJOB (not in backups)
schemaversion	Integer
iD	long
warnings	String
status	Status
userkey	String
applink	String
errors	String
info	String