Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add table, schema, model and resolvers for localAffiliations #66

Open
briri opened this issue Aug 20, 2024 · 0 comments
Open

Add table, schema, model and resolvers for localAffiliations #66

briri opened this issue Aug 20, 2024 · 0 comments

Comments

@briri
Copy link
Collaborator

briri commented Aug 20, 2024

We need a place to store affiliations that are created when a user selects 'Other' from the typeahead fields. The table will be called localAffiliations

The table should also contain these additional fields that can be updated afterward by an admin:

  • id String! (a random alpha-numeric sequence similar to a ROR id)
  • name String!
  • displayName String! (auto-generated usually a combo of the name + homepage to help disambiguate)
  • aliases String[]
  • acronyms String[]
  • homepage String
  • metadataUrl String (the endpoint that can return metadata about the org)
  • countryName String
  • countryCode String

We also need a separate partnerAffiliations table that stores additional info for orgs that are defined in the table above as well as for ROR orgs.

  • affiliationId String! (the localAffiliations metadataUrl OR the ROR id)
  • ssoEntityId String (SSO entityId)
  • emailDomains String[] (list of email domains/subdomains that are associated with the org if it uses SSO)
  • logo File (logo image to display in the subHeader)
  • nbrUsers Int! (an aid for helping sort typeahead results)
  • helpdeskEmail String! (contact email to display in the subHeader)
  • uiLinks String[] (links to display in the subHeader stored as { "link": "http://example.com", "displayOrder": 1 )
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant