Understanding the Yellowfin database structure

Hello Tara,

Thanks for reaching out with your question.

In regards to duplicates of users in the Config DB, when a user is removed the record remains in the IpClass. Instead of removing the record, Yellowfin changes the 'EndDate' field to a date older than 'today' to remove the user. If the account is added again after removal, a new record will be created in this table, resulting in seemingly duplicate entries.

The Organisation table will list all existing Client Organizations within the Yellowfin installation.

The main entries for users are within the IpClass + Person tables, however references to them via their Primary Key echo throughout other tables as well.

IpRltshp - maps users to Client Organizations as part of its functionality.

AccessGroupFlat - maps users to Groups within Yellowfin.

OrgRole - contains the role definitions. I'm unsure as to what you're referring in parasynthesis.

StaffMemberRole - maps users to their assigned roles.

AccessGroup - contains all groups created within Yellowfin.

AccessGroupMembers - contains users and their group assignments.

Does this address your questions?

Thanks,

Ryan

Hello Tara,

I'm going to go ahead and mark this as Answered. If I haven't answered your questions, or you need more information, don't hesitate to re-open this Question.

Thanks,

Ryan

Thanks, Ryan. You were able to answer my question.

Tara,

Thanks for the update. Don't hesitate to contact us with any further questions or issues.

Thanks,

Ryan