IOT Assignment 3
Tables (9)
IOT Device
- Field2 (Device ID) — PK — Primary key
- Field2 (User ID) — PK — Foreign key → Untitled.Field2
- Field (Device Type)
- Field (Device Name)
- Field2 (Status)
- Field3 (Location)
- Field2 (Network ID) — FK
- Field (Manufacturer ID) — FK
Manufacturer
- Field2 (Manufacturer ID) — PK — Foreign key → IOT Device.Field2
- Field2 (User ID) — PK — Foreign key → IOT Device.Field2
- Field (Manufacturer Name)
- Field2 (Country)
- Field3 (Support Contact)
- Field4 (Warranty Period)
Subscription (Untitled)
- Field2 (User ID) — PK — Foreign key → Untitled.Field2
- Field2 (User ID3) — PK — Foreign key → Untitled.Field2
- Field (Subscription ID) — PK
- Field (Subscription Type)
- Field (Start Date)
- Field (End Date)
- Field (Price)
Untitled (Data Log)
- Field2 (Sensor ID) — FK — Foreign key → Untitled3.Field2
- Field2 (User ID) — PK — Foreign key → Untitled3.Field2
- Log ID (Field) — PK
- Timestamp (Field2)
- Device ID (Field3) — FK
- Sensor Data (Field5)
- Action Performed (Field6)
Untitled (User)
- Field2 (User ID) — PK — Foreign key → Untitled.Field2
- Field2 (User ID3) — PK — Foreign key → Untitled.Field2
- (User Name)
- (Email)
- Field (Phone)
- Field (Address)
- Field (Subscription ID) — FK
Untitled2 (Network)
- Field2 (Network ID) — PK — Foreign key → IOT Device.Field2
- Field2 (User ID) — PK — Foreign key → IOT Device.Field2
- Field (Network type)
- Field (Bandwith)
- Field (Latency)
Untitled3 (Sensor)
- Field2 (Sensor ID) — PK — Foreign key → IOT Device.Field2
- Field2 (User ID) — PK — Foreign key → IOT Device.Field2
- Field (Sensor Type)
- Field (Sensor Data)
- Field (Unit)
- Field (Range)
- Field (Status)
- Field (Device ID) — FK
- Field (Power Usage)
Untitled4 (Actuator)
- Field2 (Actuator ID) — PK — Foreign key → IOT Device.Field2
- Field2 (User ID) — PK — Foreign key → IOT Device.Field2
- Field (Actuator Type)
- Field (Action)
- Field (Status)
- Field (Device ID) — FK
- Field (Power Usage)
Untitled5 (Alert)
- Field2 (Alert ID) — PK — Foreign key → IOT Device.Field2
- Field2 (User ID) — PK — Foreign key → IOT Device.Field2
- Field (Alert Type)
- Field (Severity)
- Field (Timestamp)
- Field (Device ID) — FK
- Field (Resolved)