You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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?