overture-stack / ego

OAuth 2.0 authorization service that supports multiple OpenID identity providers
https://www.overture.bio/products/ego
GNU Affero General Public License v3.0
26 stars 14 forks source link

Add Visa to Ego DB #677

Open Buwujiu opened 1 year ago

Buwujiu commented 1 year ago

Detailed Description

Create tables for Visas, a java repo class to fetch Visas.
Make migrate scripts to create visa.

Refer to Bashar's NOtes: Sql DB Changes

CREATE TABLE GA4GHVISA (
  id                      UUID PRIMARY KEY,
  type                    ENUM,
  source                  varchar(255) NOT NULL,
  value                   varchar(255) NOT NULL,
  by                      varchar(255) NOT NULL,
);