I'm trying to create a database that stores, manages, and tracks all employee data using Jira Insight and I'm looking for best practices and your suggestions.
There are details such as Name, ID, Birthday, Address, etc, that have a one-to-one relationship with one user. I've created attributes for each one and linked them to user's objects easily.
But, for Education information, for example, Bs. , Ms., or Ph.D. universities, and their Cities, Field of Studies, Scores, and other related data, it is a bit complicated.
I created an object type, named Universities, that contains all universities in our country as objects. Also, an object type named Cities, which has all provinces and cities as objects.
here is two possible solution:
1. If I create another object type, for example,Education Info, It's objects would be like:
User-A BS (that contains university, city, major, ... for BS degree of user A)
and so on...
2. The second way is to add Attributes to User Object type. Such as:
BS Univ, BS City, BS Field, ..., MS Univ, MS City, MS Field, ... Ph.D. Univ, Ph.D. city, Ph.D. field, ...etc.
I'm not sure I'm doing it right or this is how insight works for one-to many relationships! On the other hand, we also need to store Job Experiences that are unlimited for each user. For example User A has worked in 10 different companies and we need to have their cities, locations, dates, and many other details.
How can I store that data in Insight? Have you ever done this before?
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