Skip to content
Tallyfy

Data types

Supported data types

Tallyfy Manufactory supports these data types:

  • TEXT - Stores any text data with unlimited length. Use for names, descriptions, comments, or any character-based information.

  • INTEGER - Stores whole numbers ranging from -2,147,483,648 to 2,147,483,647. Use for counts, IDs, or any numerical data without decimal points.

  • DATE - Stores calendar dates. All values must use the format yyyy-mm-dd, for example: 2023-04-15.

  • TIME - Stores time values. All values must use the format HH:MM:SS in 24-hour format, for example: 14:10:00.

  • TIMESTAMP - Stores combined date and time values. All values must use the format yyyy-mm-dd HH:MM:SS, for example: 2023-04-15 14:10:00.

  • JSON - Stores data in JSON format. It’s useful for complex structured data stored as a single value.

Examples of proper data type usage

Data TypeExample ValueUse Case
TEXT”Machine A-123”Equipment names, comments
INTEGER42Counts, quantities, identifiers
DATE2023-04-15Production dates, schedule dates
TIME14:10:00Shift times, operation times
TIMESTAMP2023-04-15 14:10:00Event timestamps, log entries
JSON{"status": "active", "temp": 72.5}Configuration settings, complex states
Get in touch
About Tallyfy