This page is a sub-page of the Milwaukee Makerspace Sensor Array project.
The purpose of this page is to discuss the various database and web tools used in the project. Feel free to make suggestions or comments below.
The database used should be something that the MMS hosts or owns. It should be on or available from the internet so that the MMS website can use it as well as member's personal web pages and smart device apps.
What database does the Makerspace have access to? If none, we should use MySQL. Most hosting sites offer MySQL as an option.
The database should have a user that has both read and write options for the database and a user that only has read options. This way, we could share the read user and password with trusted people so they can make applications.
<Add your comments here. Date and time stamp the comment and add it to the top of the discussion, i.e. newest comments first.>
Table: Location
Description: This table will have a record for each room or area that will have sensors in it.
Column | Description | Type | Size | Other |
LocNbr | A unique id for the location | Integer | ?? | Auto-increment, indexed |
LocName | A text description of the location | VarChar | 255 | |
ParentLoc | The parent location number of this location. For example, the forge is part of a larger room. | Integer | ?? | Validate against existing LocNbrs in the table |
Add_Date | The date the record was added | Date | N/A | |
Add_Time | The time the record was added | Time | N/A | |
Add_User | The user name that added the record. Does not need validation. | VarChar | 255 | |
Chg_Date | The date the record was last changed. | Date | N/A | |
Chg_Time | The time the record was last changed. | Time | N/A | |
Chg_User | The user name that last changed the record. Does not need validation. | VarChar | 255 |
Table: Equipment
Description: The things that contain the measuring points we want to measure. Equipment is installed in a location.
Column | Description | Type | Size | Other |
Table: Measuring point
Description: Something that will be measured on an equipment. There would be one MP for each thing a sensor measures. One sensor could measure more than one thing: temperature, humidity, light levels, etc. Each thing would be a separate MP.
Column | Description | Type | Size | Other |
Table: Measures
Description: Store each individual reading for each MP with date and time stamp.
Column | Description | Type | Size | Other |
meas_pt | The measuring point number | Integer | 128 | Must be in the Measuring point table |
reading | The reading to store | Integer | 128 | Required |
um | Unit of measure for the reading | Varchar | 10 | |
add_date | Date added | Date | N/A | |
add_time | Time added | Time | N/A | |
comments | Comments for this measurement | Varchar | 255 |
<Add your comments here. Date and time stamp the comment and add it to the top of the discussion, i.e. newest comments first.>
<Add your comments here. Date and time stamp the comment and add it to the top of the discussion, i.e. newest comments first.>
<Add your comments here. Date and time stamp the comment and add it to the top of the discussion, i.e. newest comments first.>