Skip to content

Data types

Supported data types

Manufactory supports the following data types for storing your information:

  • 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. Use for complex structured data that needs to be 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

Best Practices > Understanding structured events

Structured events in Tallyfy Manufactory use key-value pairs with specific fields and rich context to enable efficient routing processing analysis and monitoring of system activities through well-organized machine-parsable data formats.

Manufactory > Naming conventions

Keys must only contain lowercase letters and underscores and cannot begin with numbers to be considered valid naming conventions.

Implementation > Configuring events schema

A comprehensive resource about Manufactory implementation detailing event schemas user configuration project planning and integration requirements for manufacturing operations.

Manufactory > Pricing for Manufactory

The pricing structure depends on data volume storage duration API call frequency and integration methods while requiring consultation with the sales team for personalized quotes based on specific implementation needs.