Database - wuyichen24/spring-microservices-in-action GitHub Wiki

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

user_orgs

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

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

oauth_client_details

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

Column	Type	Properties
client_id	VARCHAR(256)	PRIMARY KEY
resource_ids	VARCHAR(256)
client_secret	VARCHAR(256)
scope	VARCHAR(256)
authorized_grant_types	VARCHAR(256)
web_server_redirect_uri	VARCHAR(256)
authorities	VARCHAR(256)
access_token_validity	INTEGER
refresh_token_validity	INTEGER
additional_information	VARCHAR(4096)
autoapprove	VARCHAR(256)

users

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

Column	Type	Properties
username	VARCHAR(256)	PRIMARY KEY
password	VARCHAR(256)
enabled	BOOLEAN

authorities

• Description: Define users' authority (role).
• Owner: Authentication Service.

Column	Type	Properties
id	SERIAL	PRIMARY KEY
username	VARCHAR(256)
authority	VARCHAR(256)

abtesting

• Description: Define alternate endpoints for different services.
• Owner: Specialroutes Service.

Column	Type	Properties
service_name	VARCHAR(100)	PRIMARY KEY
active	VARCHAR(1)
endpoint	VARCHAR(100)
weight	INTEGER