- Added `code` VARCHAR(50) NOT NULL for programmatic use
- Added `is_active` BOOLEAN DEFAULT TRUE
- Added `metadata` JSONB DEFAULT '{}'
- Added indexes for code and is_active
- Added unique constraint for code per tenant
Aligns DDL with role.entity.ts
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
|
||
|---|---|---|
| .. | ||
| 01-users.sql | ||
| 02-roles.sql | ||
| 03-invitations.sql | ||