创建房间设备视图 vw_RoomDevice

创建视图 vw_RoomDevice 作为 SELECT r.UserID AS 用户ID, rt.Username AS 用户名, r.RoomName AS 房间名, d.DeviceName AS 设备名, d.DeviceType AS 设备类型, dy.SensorType AS 传感器类型, dy.SensorValue AS 传感器值, dy.Timestamp AS 时间戳, dr.StatusName AS 设备状态 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；