SmartVillage

Tables (4)

GateTable (Untitled2)

  • Sensor_ID — int — Primary key — NOT NULL
  • sensor_name — varchar(20)
  • sensor_num — int
  • hub_name — varchar(20)
  • value — varchar(20)
  • purpose — varchar(20)
  • time — datatime()

Hublist

  • hub_ID — int — Primary key — NOT NULL
  • name — varchar(30))

Sensorlist

  • ID — int — Primary key — NOT NULL
  • name — varchar(30)

hub_sensor (Untitled)

  • (hub_ID, ID) (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • ID (ID2) — int — Foreign key → Sensorlist.ID — NOT NULL
  • hub_ID — int — Foreign key → Hublist.hub_ID — NOT NULL