What is the page id in Confluence Database schema?

[Rahu]

I want to do so because I want to add a table to the DB and use the page as the foreign key.

[Nic Brough -Adaptavist-]

Ok, on the back of the updated question, the answer is now "no, you don't".  Generally, if you want to store extra data for a page, then you should be looking to do it by writing an addon to do it.  An addon has three options for storage

• you could store something in the page, wrapped in a macro
• you could use active objects
• you could wrap your own database tables in code

In all three cases, you really do not care about the page id in the database - your code will have direct access to it in the API, and your read/writes will be abstracted too.

[Username]

@a display name Can you please tell me about each of the options to store data? Are there tutorials for each? I am a beginner to confluence dev, I would appreciate your help.

[Nic Brough -Adaptavist-]

The first option really is what I said - your data is in the page. The third one means writing a full addon with its own set of database objects and interfaces to them. For most of this work, start at https://developer.atlassian.com/confdev/confluence-plugin-guide/writing-confluence-plugins and for the active object stuff, also see https://developer.atlassian.com/docs/atlassian-platform-common-components/active-objects/getting-started-with-active-objects

[Username]

Thanks @a display name

[Nic Brough -Adaptavist-]

It's the unique identifier for the current page.

I'm not sure I can tell you more than that - I don't understand the story you're working towards,