Database schema for Confluence backups

Generated for RY 3.7.1 with DatabaseDocumentationJUnit.

Table AO_32F7CE_DBREQUIREMENT

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_DBPROPERTY

Table AO_32F7CE_DBPROPERTY

#0   schemaversion

Integer

#1   parent

DBRequirement

#2   property

String

#3   type

String

#4   value

String

#5   indexingjson

String

#6   storagetype

Integer

Table AO_32F7CE_DBLINK

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_DBDEPENDENCY

Table AO_32F7CE_DBDEPENDENCY

#0   schemaversion

Integer

#1   relationship

String

#2   parent

DBRequirement

#3   child

DBRequirement

#4   crossin

boolean

#5   crossout

boolean

Table AO_32F7CE_DBBASELINE

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_DBPROPERTYNAME

Table AO_32F7CE_DBPROPERTYNAME

#0   schemaversion

Integer

#1   propertyname

String (pk)

#2   datatype

String

#3   meta

String

Table AO_32F7CE_DBQUEUE (not in backups)

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

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)

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)

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)

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

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

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

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)

Table AO_32F7CE_DBUSAGESTATS (not in backups)

schemaversion

Integer

iD

long

date

Date

value

Long

type

String

Table AO_32F7CE_DBBACKUPMAPPING (not in backups)

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)

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)

Table AO_32F7CE_DBOPERATIONJOB (not in backups)

schemaversion

Integer

iD

long

warnings

String

status

Status

userkey

String

applink

String

errors

String

info

String