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)