Help / Table Creation Guidelines

Your table defines how you will store data in SensorBase, so it is very important you take the time to define your table correctly. If you are unsure of a data type, refer to the list below.

Data Types » numerical

• Integer / -2,147,683,648 to 2,147,483,647
• Tiny Integer / -128 to 127
• Small Integer / -32,768 to 32.767
• Medium Integer / -8,388,608 to 8,388,607
• Big Integer / -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
• Float / -3.40282E+38 to -1.17549E-38, 0, and 1.17549E-38 to 3.40282E+38
• Double / -1.79769313486232E+308 to -2.2250738585072014E-308
  (exclusive), 0, and 2.2250738585072014E-308 (exclusive) to 1.79769313486232E+308
• Binary / 0 or 1

Data Types » text

• Text / 65,535 characters
• Tiny Text / 255 characters
• Medium Text / 2,097,152 characters
• Variable Characters / variable length strings; must specify maximum
  length, 0 to 65,535

Data Types » media (e.g. images)

• Media / 0 to 64 kilobytes
• Tiny Media / 0 to 281 bytes
• Medium Media / 0 to 2 megabytes

• Date and Time / follows the format YYYY-MM-DD HH:MM:SS
• Date / follows the format YYYY-MM-DD
• Time / follwows the format HH:MM:SS