Log
Audit/log records linked to user/sensor context.
Entity: Log
Description
Audit/log records linked to user/sensor context.
Attributes
| Attribute | Type / Unit | Description |
|---|---|---|
USID | PK+FK → UserSensor(UID,SID,valid_since) | User–sensor link. |
UID | PK+FK → User(UID) | Actor user. |
logged_at | PK (timestamp) | Log timestamp. |
LTID | PK+FK → LogType(LTID) | Log type. |
LID_payload | json/text | Details/payload. |
Keys
- Primary Key (composite): (
USID,UID,logged_at,LTID) - Foreign Keys:
USID→UserSensor(...),UID→User.UID,LTID→LogType.LTID - Unique Keys: —