CREATE TABLE House(
 RoomID text,
 SensorID text,
 State text,
 Time timestamp,
 CONSTRAINT miltipk PRIMARY KEY(RoomID, SensorID)
 
);

CREATE TABLE Entertainment(
 RoomID text,
 SensorID text,
 State text,
 Time timestamp,
 CONSTRAINT Entpk PRIMARY KEY(RoomID, SensorID)
);

CREATE TABLE Tracking(
 RoomID text,
 SensorID text,
 Location text,
 State text,
 Time timestamp,
 CONSTRAINT Tracpk PRIMARY KEY(RoomID, SensorID) 
 );

create table AlarmSystem (
 ID serial primary key,
 Room text,
 Sensor text,
 AlarmStatus text,
 FOREIGN KEY (Room, Sensor) REFERENCES House(RoomID, SensorID) ON DELETE CASCADE ON UPDATE CASCADE
);

CREATE TABLE Water(
 ID serial primary key,
 Room text,
 Sensor text,
 WaterState text,
 FOREIGN KEY (Room, Sensor) REFERENCES House(RoomID, SensorID) ON DELETE CASCADE ON UPDATE CASCADE
);

CREATE TABLE Temperature(
 ID serial primary key,
 Room text,
 Sensor text,
 Temp decimal,
 FOREIGN KEY (Room, Sensor) REFERENCES House(RoomID, SensorID) ON DELETE CASCADE ON UPDATE CASCADE
);

CREATE TABLE Light(
 ID serial primary key,
 Room text,
 Sensor text,
 LightState text,
 FOREIGN KEY (Room, Sensor) REFERENCES House(RoomID, SensorID) ON DELETE CASCADE ON UPDATE CASCADE
);