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