E-R Diagram

RA December 5, 2024

Hello,

 

I'm looking for the latest E-R diagram just like the one I came across here

https://support.atlassian.com/analytics/docs/schema-for-jira-family-of-products/

This one is not matching to the columns I see in some of the tables like jira_issue_field, jira_sprint and so on.

Thanks

2 answers

0 votes
RA December 16, 2024

1

0 votes
vikram
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 5, 2024

Hi @RA 

Welcome to Atlassian Community. 

To get full ER-Diagram of your jira instance or version, you have to raise a ticket to Atlassian support team from below url, Atlassian Team will send to you the pdf directly to your email. 

https://support.atlassian.com/ 

With Regards

Vikram P

vikram
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 5, 2024

Below URL also provide you the schemas for jira.

 

https://developer.atlassian.com/server/jira/platform/database-schema/

 

https://developer.atlassian.com/server/jira/platform/database-schema/#Databaseschema-ChangeHistory

 

Also if you have Jira database access as admin/super user permission, you can login to database from any client and get the ER-Diagrams from database. 

Vikram P

RA December 6, 2024

Thanks much Vikram.. this will definitely help to kick start.

vikram
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 6, 2024

Hi @RA

Felt happy, that it help you.

Thank you too.

Vikram P

RA December 18, 2024

Hello Vikram,

We have a Jira Cloud platform and not a hosted one on-prem.

Can you please guide as to how we can get an E-R diagram for the same?

Thanks

RA

vikram
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 18, 2024

 

 

Hi @RA 

you have to send an email to Atlassian Support from below url.

https://support.atlassian.com/ 

as per your Application Instance. 

Vikram P

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events