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_DBPROPERTY | |
---|---|
#0 schemaversion | Integer |
#1 parent | DBRequirement (pk) |
#2 property | String (pk) |
#3 type | String (pk) |
#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 (pk) |
#2 parent | DBRequirement (pk) |
#3 child | DBRequirement (pk) |
#4 crossin | boolean |
#5 crossout | boolean |
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_DBPROPERTYNAME | |
---|---|
#0 schemaversion | Integer |
#1 propertyname | String (pk) |
#2 datatype | String |
#3 meta | 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 |
Table AO_32F7CE_DBRULERESULT | |
---|---|
#0 schemaversion | Integer |
#1 parent | DBRequirement |
#2 rule | DBRequirementType |
#3 type | Type |
#4 level | Level |
#5 json | String |