创建房间设备视图 vw_RoomDevice

CREATE VIEW vw_RoomDevice AS SELECT rd.UserID AS UserID, rt.Username AS Username, rd.RoomName AS RoomName, d.DeviceName AS DeviceName, d.DeviceType AS DeviceType, dy.SensorType AS SensorType, dy.SensorValue AS SensorValue, dy.Timestamp AS Timestamp, dr.StatusName AS StatusName FROM RoomDevice rd INNER JOIN Room r ON rd.DeviceID = r.RoomID INNER JOIN Device d ON d.DeviceID = rd.DeviceID INNER JOIN DeviceStatus dr ON dr.StatusID = r.RoomID INNER JOIN SensorData dy ON dy.DataID = r.RoomID INNER JOIN userb rt ON r.UserID = rt.UserID;