goqual

Tables (10)

airconSensor (Untitled)

  • id (Key) — Primary key — NOT NULL
  • roomId (Key2) — Foreign key → roomList.roomId — NOT NULL
  • homeId (Field3)
  • modelName (Field)
  • name (Field4)
  • deviceType (Field2)
  • online (Field5)
  • power (Field6)
  • category (Field7)
  • temperature (Field8)
  • mode (Field9)
  • fanSpeed (Field10)
  • measuredTime (Field11)

deviceState (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • deviceType (Field)
  • deviceState (Field2)

doorSensor (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • modelName (Field4)
  • name (Field6)
  • deviceType (Field2)
  • IsOpen (Field) — enum
  • battery (Field3)
  • homeId (Field5)
  • category (Field7)
  • online (Field8)
  • power (Field9)
  • roomId (Key2) — Foreign key → roomList.roomId — NOT NULL
  • measuredTime (Field10)

homeList (Untitled4)

  • homeId (Key) — Primary key — NOT NULL
  • name (Field)
  • subName (Field2)

log (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • responseTime (Field)
  • requestTime (Field2)
  • type (Field3)
  • message (Field4)

notification (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • dateTime (Field3)
  • deviceInfo (Field4)

roomDevice (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • deviceType (Field2)
  • hasSubDevices (Field3)
  • modelName (Field4)
  • familyId (Field5)
  • category (Field6)
  • online (Field7)

roomList (Untitled5)

  • roomId (Key) — Primary key — NOT NULL
  • homeId (Key2) — Foreign key → homeList.homeId — NOT NULL
  • name (Field)
  • subName (Field2)

switchSensor (CopyOfCopyOfUntitled2)

  • id (Key) — Primary key — NOT NULL
  • name (Field16)
  • modelName (Field18)
  • deviceType (Field2)
  • power1 (Field)
  • power2 (Field3)
  • power3 (Field4)
  • power4 (Field12)
  • power5 (Field11)
  • power6 (Field13)
  • power1Name (Field5)
  • power2Name (Field6)
  • power3Name (Field7)
  • power4Name (Field8)
  • power5Name (Field9)
  • power6Name (Field10)
  • category (Field14)
  • homeId (Field15)
  • power (Field17)
  • roomId (Key2) — Foreign key → roomList.roomId — NOT NULL
  • measuredTime (Field19)

temphumiditySensor (CopyOfUntitled2)

  • id (Key) — Primary key — NOT NULL
  • modelName (Field5)
  • name (Field7)
  • deviceType (Field2)
  • battery (Field3)
  • temperature (Field)
  • humidity (Field4)
  • homeId (Field6)
  • online (Field8)
  • power (Field9)
  • category (Field10)
  • roomId (Key2) — Foreign key → roomList.roomId — NOT NULL
  • measuredTime (Field11)