The jira database data is displayed abnormally

[arno]

你好 

Today, when I was querying the database data, I found that the information in my database was displayed abnormally. In the jiraissue data table, data in "assignee" is not displayed properly, as users' E-mail information should normally be displayed, while some data is displayed as JIRAUSER+ID. And the ID does not match the cwd_user table.

What I want to realize is that the information displayed should be the user's email information. How to set it?

It's worth noting that my jira system integrates with LDAP, so it should normally display domain account information

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

Stop looking at the database.  It is horribly complex and rarely works the way that you are guessing that it will.

If you want to look at users email addresses, look at the LDAP server, or Jira's UI or REST interface.  The database is not going to work the way you think.