UserRole
Assignment of a role to a user.
Entity: UserRole
Description
Assignment of a role to a user.
Attributes
| Attribute | Type / Unit | Description |
|---|---|---|
URID | PK (UUID/string) | User-role id. |
RID | FK → Role(RID) | Role. |
UID | FK → User(UID) | User. |
added_at | timestamp | When added. |
Keys
- Primary Key:
URID - Foreign Keys:
RID→Role.RID,UID→User.UID - Unique Keys: (optional) (
RID,UID)