Application Schema
roles
Column
Type
Constraints
tenant_id
bigint
PK, NOT NULL
id
bigint
PK, NOT NULL
name
varchar(100)
UNIQUE
users
Column
Type
Constraints
id
bigint
PK
tenant_id
bigint
NOT NULL
email
varchar(255)
NOT NULL, UNIQUE
role_id
bigint
NOT NULL
L01