Not trying to tell anyone how to develop a database, not trying to be rude here, but inquiring minds need to know.
Jira uses an app_user table that uses usernames as the unique key to associate users to issues instead of using the ID of the user in CWD_User.
This doesn't make sense to me. I would think this would lead to records easily orphaned and such.
Why not link issues using the id field of the cwd_user table?
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events