user_right_types | |
PK |
user riaht tvoe id |
user_right_type |
X
\
\
room types | |
PK |
room tvoe id |
room_type |
t
computer_types | |
PK |
comouter tvoe id |
computer_type |
\
%
user_rights | |
PK |
user riaht id |
FK1 FK2 |
user_id user_right_type_id |
-AV
JL
room rights | |
PK |
room riaht id |
FK1 FK2 |
userjd room_type_id |
computers | |
PK |
comouter id |
FK1 FK2 |
computer_name roomname computer type id ispoweron is busy ip |
p
user_types | |
PK |
user tvoe id |
usertype |
users | |
PK |
user id |
FK1 |
user_type_id login password reg_date cdłtfłnent —- |
sensor_types | |
PK |
sensor typ_e id |
sensor_type is_bool |
3:
/
X
\
\
rooms | |
PK |
room id |
FK1 FK2 |
roomname room_type_id building_id room_description |
buildings | |
PK |
buildina id |
buildingname floor_number building_description |
\
\
\
X
weather | |
PK |
weather id |
FK1 |
sensor_type_id actual |
£
sensor_states | |
PK |
sensor State id |
FK2 FK1 |
roomname sensor_type_id actual |