...
| Author | Adesh Singh |
|---|---|
| JIRA task | https://issuesfolio-org.folioatlassian.orgnet/browse/MODFISTO-394 Define DB schema for storing tenants and create table https://issuesfolio-org.folioatlassian.orgnet/browse/MODFISTO-400 |
| Business Requirements | Define DB schema for storing tenants and create table Define DB schema for storing user and affiliation associations and create table |
| Architects Review | Pending |
| PO review | Pending |
...
| Column | Column Data Type | Sense | Is mandatory? | Is unique? | Notes |
|---|---|---|---|---|---|
| id | UUID | How to identify a user and tenant table | Y | Y | UUID of user and tenant table and it is primary key |
| user_id | UUID | How to identify a user? | Y | Y | UUID of the user |
| username | String(text) | How to identify a username? | Y | N | username of the user |
| tenant_id | String(text) | What tenantId does the user associate with? | Y | N | UUID of the affiliation is associated with the user. - Foreign Key to tenant table |
| is_primary | Boolean | is Tenant primary for the user? | Y | N | Whether this tenant is the primary tenant for the user. |
