13 lines
654 B
Markdown
13 lines
654 B
Markdown
# PostgreSQL 16 Hybrid Multi-Tenant Setup
|
|
|
|
## Architektur Overview
|
|
- **Docker Setup**: PostgreSQL 16 Alpine via Docker Compose.
|
|
- **Rollen-Isolation**: `app_user` (DML) & `migration_user` (DDL).
|
|
- **Master Schema**: `tenants` Tabelle in `V1__init_master_schema.sql`.
|
|
- **Tenant Schemas**: `dining_areas`, `restaurant_tables`, `guests`, `reservations`, `reservation_table_assignments`, `staff_users` in `V1__init_tenant_schema.sql`.
|
|
|
|
## Backend Integration
|
|
- `TenantContext` (ThreadLocal Schema Resolver)
|
|
- `SchemaBasedMultiTenantConnectionProvider` (Hibernate Connection Handling)
|
|
- HikariCP Connection Pool optimiert für Postgres in `application.yml`.
|