Expand the links below to display the main table and foreign keys for each table.
Click here to show/hide the table ...
Ao_9412a1_aouser |
Id |
Ao_9412a1_user_app_link |
user_id |
fk_ao_9412a1_user_app_link_user_id |
Ao_9412a1_aouser_pkey |
Attachments |
Attachmentid |
Attachmentdata |
Attachmentid |
fk9dc3e34d34a4917e |
Attachments_pkey |
Attachments |
Attachmentid |
Attachments |
Prevver |
fk54475f9017d4a070 |
Attachments_pkey |
Attachments |
Attachmentid |
Content_label |
Attachmentid |
fkf0e7436e34a4917e |
Attachments_pkey |
Attachments |
Attachmentid |
Imagedetails |
Attachmentid |
fka768048734a4917e |
Attachments_pkey |
Content |
ContentID |
Attachments |
PageID |
Fk54475f908c38fbea |
Content_pkey |
Content |
ContentID |
Bodycontent |
ContentID |
fka898d4778dd41734 |
Content_pkey |
Content |
ContentID |
Confancestors |
Ancestorid |
fk9494e23c37e35a2e |
Content_pkey |
Content |
ContentID |
Confancestors |
Descendentid |
Fk9494e23cc45e94dc |
Content_pkey |
Content |
ContentID |
Content |
Prevver |
fk6382c05917d4a070 |
Content_pkey |
Content |
ContentID |
Content |
ParentID |
fk6382c05974b18345 |
Content_pkey |
Content |
ContentID |
Content |
Parentcommentid |
fk6382c059b97e9230 |
Content_pkey |
Content |
ContentID |
Content |
PageID |
Fk6382c0598c38fbea |
Content_pkey |
Content |
ContentID |
Content_label |
ContentID |
fkf0e7436e8dd41734 |
Content_pkey |
Content |
ContentID |
Content_perm_set |
content_id |
Fkbf45a7992caf22c1 |
Content_pkey |
Content |
ContentID |
Contentproperties |
ContentID |
fk984c5e4c8dd41734 |
Content_pkey |
Content |
ContentID |
Extrnlnks |
ContentID |
fk97c10fe78dd41734 |
Content_pkey |
Content |
ContentID |
Likes |
ContentID |
fk4514b9c8dd41734 |
Content_pkey |
Content |
ContentID |
Links |
ContentID |
fk45157998dd41734 |
Content_pkey |
Content |
ContentID |
Notifications |
PageID |
Fk594acc88c38fbea |
Content_pkey |
Content |
ContentID |
Spaces |
Homepage |
Fk9228242d11b7bfee |
Content_pkey |
Content |
ContentID |
Spaces |
Spacedescid |
Fk9228242d2c72d3d2 |
Content_pkey |
Content |
ContentID |
Trackbacklinks |
ContentID |
fkf6977a478dd41734 |
Content_pkey |
Content_perm_set |
Id |
Content_perm |
cps_id |
fkbd74b31676e33274 |
Content_perm_set_pkey |
Cwd_app_dir_mapping |
Id |
Cwd_app_dir_group_mapping |
app_dir_mapping_id |
Fk_app_dir_group_mapping |
Cwd_app_dir_mapping_pkey |
Cwd_app_dir_mapping |
Id |
Cwd_app_dir_operation |
app_dir_mapping_id |
Fk_app_dir_mapping |
Cwd_app_dir_mapping_pkey |
Cwd_application |
Id |
Cwd_app_dir_group_mapping |
application_id |
Fk_app_dir_group_app |
Cwd_application_pkey |
Cwd_application |
Id |
Cwd_app_dir_mapping |
application_id |
fk52050e2fb347aa6a |
Cwd_application_pkey |
Cwd_application |
Id |
Cwd_application_address |
application_id |
Fk_application_address |
Cwd_application_pkey |
Cwd_application |
Id |
Cwd_application_attribute |
application_id |
Fk_application_attribute |
Cwd_application_pkey |
Cwd_directory |
Id |
Cwd_app_dir_group_mapping |
directory_id |
Fk_app_dir_group_dir |
Cwd_directory_pkey |
Cwd_directory |
Id |
Cwd_app_dir_mapping |
directory_id |
Fk_app_dir_dir |
Cwd_directory_pkey |
Cwd_directory |
Id |
Cwd_directory_attribute |
directory_id |
Fk_directory_attribute |
Cwd_directory_pkey |
Cwd_directory |
Id |
Cwd_directory_operation |
directory_id |
Fk_directory_operation |
Cwd_directory_pkey |
Cwd_directory |
Id |
Cwd_group |
directory_id |
fk_directory_id |
Cwd_directory_pkey |
Cwd_directory |
Id |
Cwd_group_attribute |
directory_id |
fk_group_attr_dir_id |
Cwd_directory_pkey |
Cwd_directory |
Id |
Cwd_user |
directory_id |
fk_user_dir_id |
Cwd_directory_pkey |
Cwd_directory |
Id |
Cwd_user_attribute |
directory_id |
fk_user_attr_dir_id |
Cwd_directory_pkey |
Cwd_group |
Id |
Cwd_group_attribute |
group_id |
fk_group_attr_id_group_id |
Cwd_group_pkey |
Cwd_group |
Id |
Cwd_membership |
parent_id |
Fk_parent_grp |
Cwd_group_pkey |
Cwd_group |
Id |
Cwd_membership |
child_group_id |
Fk_child_grp |
Cwd_group_pkey |
Cwd_user |
Id |
Cwd_membership |
child_user_id |
Fk_child_user |
Cwd_user_pkey |
Cwd_user |
Id |
Cwd_user_attribute |
user_id |
fk_user_attribute_id_user_id |
Cwd_user_pkey |
Cwd_user |
Id |
Cwd_user_credential_record |
user_id |
fk76f874f73aee0f |
Cwd_user_pkey |
External_entities |
Id |
External_members |
Extentityid |
fkd8c8d8a5f25e5d5f |
External_entities_pkey |
Groups |
Id |
External_members |
GroupID |
Fkd8c8d8a5117d5fda |
Groups_pkey |
Groups |
Id |
Local_members |
GroupID |
Fk6b8fb445117d5fda |
Groups_pkey |
KeyStore |
keyID |
Trustedapp |
public_key_id |
Fkddb119ca9c85adb1 |
Keystore_pkey |
Label |
Labelid |
Content_label |
Labelid |
Fkf0e7436e27072aef |
Label_pkey |
Os_group |
Id |
Os_user_group |
group_id |
Fk932472461e2e76db |
Os_group_pkey |
Os_user |
Id |
Os_user_group |
user_id |
fk93247246f73aee0f |
Os_user_pkey |
Pagetemplates |
TemplateID |
Content_label |
Pagetemplateid |
Fkf0e7436ed32042e4 |
Pagetemplates_pkey |
Pagetemplates |
TemplateID |
Pagetemplates |
Prevver |
fkbc7ce96a17d4a070 |
Pagetemplates_pkey |
Spacegroups |
Spacegroupid |
Spacegrouppermissions |
Spacegroupid |
fk487d958b16994414 |
Spacegroups_pkey |
Spacegroups |
Spacegroupid |
Spaces |
Spacegroupid |
fk9228242d16994414 |
Spacegroups_pkey |
Spaces |
Spaceid |
Content |
Spaceid |
fk6382c059b2dc6081 |
Spaces_pkey |
Spaces |
Spaceid |
Notifications |
Spaceid |
fk594acc8b2dc6081 |
Spaces_pkey |
Spaces |
Spaceid |
Pagetemplates |
Spaceid |
fkbc7ce96ab2dc6081 |
Spaces_pkey |
Spaces |
Spaceid |
Spacepermissions |
Spaceid |
fkd33f23beb2dc6081 |
Spaces_pkey |
Trustedapp |
Trustedappid |
Trustedapprestriction |
Trustedappid |
fke8496ba235d1d865 |
Trustedapp_pkey |
Users |
Id |
Local_members |
Userid |
fk6b8fb445ce2b3226 |
Users_pkey |
The following sections describe the forms used to classify each logical section in confluence-authorization, content, System information, and so on.
Https://www.cwiki.us/display/CONF6ZH/Confluence+Data+Model
Confluence 6 database tables and references