Database schema for Confluence backups

Generated for RY 4.2.4 with DatabaseDocumentationJUnit.

Table AO_32F7CE_DBREQUIREMENT
#0 schemaversion	Integer
#1 spacekey	String (pk) mapped by SpaceMapper
#2 key	String (pk)
#3 baseline	Integer (pk)
#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 (pk)
#2 spacekey	String (pk) 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
#15 comment2	String

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)
iD	long
schemaversion	Integer
applinkid	String mapped by ApplinkMapper
version	Long
label	String
status	String
serviceid	String
displayurl	String
rpcurl	String
userKey	String

Table AO_32F7CE_DBJIRACACHE (not in backups)
iD	long
schemaversion	Integer
applinkid	String mapped by ApplinkMapper
key	String
type	String
filterby	String
projectid	Long
issuetypeid	Long
relationship	String
creationdate	Date
userkey	String
json	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_DBUSAGESTATS (not in backups)
iD	long
schemaversion	Integer
date	Date
value	Long
type	String

Table AO_32F7CE_DBREQUIREMENTTYPE
#0 schemaversion	Integer
#1 spacekey	String mapped by SpaceMapper
#2 name	String
#3 description	String
#4 prefix	String
#5 suffix	String
#6 uniquekey	String
#7 current	Long
#8 padding	Integer
#9 position	Integer
#10 body	String