Skip to content

Data Types

Data Types

Manufactory supports the following data types:

  • TEXT - any text data with unlimited length.
  • INTEGER - Any number that has a range from -2,147,483,648 to 2,147,483,647.
  • DATE - used to store dates. Please note that values must match this format yyyy-mm-dd 1970-12-30
  • TIME - used to store times. Please note that values must match this format HH:MM:SS 14:10:00. Noting that all time values are stores in 24 hours format.
  • TIMESTAMP - used to store date with time. Please note that values must match this format yyyy-mm-dd HH:MM:SS 1970-12-30 14:10:00
  • JSON - used to store textual JSON data

Manufactory > Data Types

Manufactory data types include TEXT INTEGER DATE TIME TIMESTAMP and JSON with specific formatting requirements for storing various types of data and values.

Manufactory > Data Types

Manufactory supports six distinct data types including TEXT INTEGER DATE TIME TIMESTAMP and JSON each with specific formatting requirements and storage capabilities.

Manufactory > Naming Conventions

Keys in column names must use lowercase letters and underscores while avoiding numbers at the start and special characters like dots or hyphens.

Manufactory > Naming Conventions

Column names must use lowercase letters and underscores only, avoiding numbers at the start and special characters like hyphens or periods.
Get in touch
About Tallyfy