Seed project for achieving multi-tenancy (single pooled schema-per-tenant) using SpringBoot and Hibernate as proposed in this article.
This project assumes a dedicated MySql DB is reachable (can be configured in application.properties), which has a default schema named default_schema and at least one additional schema with some tenant name you choose.
The default schema has a single table called user_tenant_relation and has the following structure:
CREATE TABLE `user_tenant_relation` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(45) NOT NULL,
`tenant` varchar(45) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username_tenent_uq` (`username`,`tenant`)
);
The JWT boiler-plate code is removed from to keep it clear and as simple as possible.