Define DB schema for storing user and affiliation associations and create table

Description

Overview:
We need to investigate data structure for storing users and affiliations associations, also we need some sign to undestand what is the primary tenant(affiliation) , myabe we can use separate column for it.

Liquibase is already configured in scope of Tenants feature.

 

Acceptance Criteria:

  • Investigate and document SQL mapping for 'user+affiliation' association, primary tenant

  • Investigate in wich SQL schema we should store new table 'tenant'

  • Create Liquibase script to create tenant table

Environment

None

Potential Workaround

None

Attachments

4

Checklist

hide

TestRail: Results

Activity

Show:

Serhii_Nosko March 8, 2023 at 11:14 AM

Changes looks good, closing this story

Adesh Singh March 8, 2023 at 8:13 AM

Done

Details

Assignee

Reporter

Priority

Story Points

Development Team

Thunderjet

Fix versions

Release

Poppy (R2 2023)

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created February 27, 2023 at 10:00 AM
Updated July 31, 2023 at 12:30 PM
Resolved March 8, 2023 at 11:15 AM
TestRail: Cases
TestRail: Runs