Relation b/w Themes, Configurations and Spaces in database.

Nitin Kumar3

Hi . I am looking to manage the page/space configuration (not content) in Confluence(5.5) as part of the release process.

Is there a way to do that ? I know about Bandana table . I can migrate the themes (RefinedWiki) across environments by picking on spacekey in Bandana table but cannot get the relation b/w spaces and categories working under Oranize Spaces page in Admin.

Can anyone please show me a relation b/w these three entities.

William Crighton _CCC_

I'm guessing you already used google with something like 'atlassian confluence data model' and found this page?

• Confluence Data Model

The second paragraph about how the data model can change, while true, is not exactly something to get highly concerned over - most the queries I wrote back in 2005 during my first Confluence implementation still work.

The first paragraph will be you answer for any confluence managed (opposed to 3rd party plugin managed) data - quoted here for effect:

The Hibernate mapping files are the authoritative reference for the Confluence data model. These are the *.hbm.xml files which you will find in the main Confluence JAR file (<CONFLUENCE-INSTALLATION>\confluence\WEB-INF\lib\confluence-5.1.1.jar).

If you've gone through a similar exercise with JIRA these are like the entity-model.xml file describing the tables and their relationships. It's all based on (at it's core) the Apache OFBiz project (I believe) and has a summary of the approach for handling data here Open for Biz Data Model (along with a lot of other doc).

maybe that'll get you somewhere close to what you are looking for. I'm thinking, though, that you're mixing 3rd Party Plugin names/concepts with Confluence ones - and it'd help a lot if you mentioned the 3rd party plugin you were working with (providing the 'Themes').

-wc