Database schema for Confluence backups
Generated for RY 3.7.1 with DatabaseDocumentationJUnit.
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 | |
---|---|
#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 | |
---|---|
#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 | |
---|---|
#0 Â schemaversion | Integer |
#1 Â relationship | String |
#2 Â parent | DBRequirement |
#3 Â child | DBRequirement |
#4 Â crossin | boolean |
#5 Â crossout | boolean |
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 | |
---|---|
#0 Â schemaversion | Integer |
#1 Â propertyname | String (pk) |
#2 Â datatype | String |
#3 Â meta | 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 |