Where Confluence Pages are stored (DB table name)

[Fedorov Fedor]

HI,

Where Confluence Pages are stored ? Confluence Server version.

I am need know table name in DB (Oracle)

For example I know id page pageId=2336917, how I am find this page in DB an other pages?

Thnx all.

[Alex K]

@Fedorov Fedor 

You can see the storage format for any content in the BODYCONTENT table. To see other details about the page a good starting place is the CONTENT table. 

Let me know if there is something else in particular you are searching for.

Regards,
Alex

[Fedorov Fedor]

You know plugin Inline comments!? 

I cant find inline comments in db !? One of the pages content include inline comment, but this comment not displayed. And I am looking this inline comment in DB, i know id this inline comment, but I dont know table, where stored plugin inline comments. 

[Fedorov Fedor]

My Confluence Server version 6.0.7

, not Cloud.

[Nic Brough -Adaptavist-]

Comments are also content.  This is one of the reasons you probably don't want to be reading the database - it's the most complex and worst way you can try to get data out of Confluence.

[Fedorov Fedor]

I cant find Inline comments in Editor one of the space page confluence.

But I added this comment.

Plugin working..

Inline comments in Editor

The problem only in one page, and I am looking entry this comment in the database. But I dont know name table Inline comments in Editor, where stored inline comments. 

[Nic Brough -Adaptavist-]

They're in the content tables as given above.

Could you explain what you are actually trying to achieve here?  There is a better way than trying to read the database, and probably more than one better way.  

But without knowing what you're trying to do, we can't help you with it. 

Running off trying to explain how the database is used as a data store is not that helpful in the long run - you have already run into "it is a lot more complicated than you assumed" and you are quickly going to run into "the relationship info you are looking for is done in the code, not the data"

[Fedorov Fedor]

Log error in console dev browser, when I am opening page

[Fedorov Fedor]

adress error - confluence.company.com/rest/inlinecomments/1.0/comments?containerId=2336917&_=1602063406471

[Nic Brough -Adaptavist-]

Ok, so that has nothing to do with the database, it's a problem with reading and rendering.

What are you doing to provoke that error?

[Fedorov Fedor]

OK.

I understand, its not good idea, working with DB.

Thanx all