Database

Schemas

licenses

• Description: Define licenses.
• Owner: Licensing Service.

Column	Type	Properties
license_id	VARCHAR(100)	PRIMARY KEY
organization_id	TEXT
license_type	TEXT
product_name	TEXT
license_max	INT
license_allocated	INT
comment	VARCHAR(100)

organizations

• Description: Define organizations.
• Owner: Organization Service.

Column	Type	Properties
organization_id	VARCHAR(100)	PRIMARY KEY
name	TEXT
contact_name	TEXT
contact_email	TEXT
contact_phone	TEXT

users

• Description: Define users and their credentials.
• Owner: Authentication Service.

Column	Type	Properties
user_name	VARCHAR(100)	PRIMARY KEY
password	VARCHAR(100)
enabled boolean NOT NULL

user_roles

• Description: Define users' role.
• Owner: Authentication Service.

Column	Type	Properties
user_role_id	SERIAL	PRIMARY KEY
user_name	VARCHAR(100)
role	VARCHAR(100)

user_orgs

• Description: Define each user belongs to which organization.
• Owner: Authentication Service.

Column	Type	Properties
organization_id	VARCHAR(100)
user_name	VARCHAR(100)	PRIMARY KEY

abtesting

Relationships