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)