UserSensor
Many-to-many mapping between users and sensors with validity start.
Entity: UserSensor
Description
Many-to-many mapping between users and sensors with validity start.
Attributes
| Attribute | Type / Unit | Description |
|---|---|---|
UID | PK+FK → User(UID) | User. |
SID | PK+FK → Sensor(SID) | Sensor. |
valid_since | PK (timestamp/date) | When mapping became valid. |
Keys
- Primary Key (composite): (
UID,SID,valid_since) - Foreign Keys:
UID→User.UID,SID→Sensor.SID - Unique Keys: —