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 Type	Example Value	Use Case
TEXT	”Machine A-123”	Equipment names, comments
INTEGER	42	Counts, quantities, identifiers
DATE	2023-04-15	Production dates, schedule dates
TIME	14:10:00	Shift times, operation times
TIMESTAMP	2023-04-15 14:10:00	Event timestamps, log entries
JSON	{"status": "active", "temp": 72.5}	Configuration settings, complex states

Data Validation

Manufactory validates all incoming data against these specified formats. Ensure your values match the required formats to avoid data rejection.

Related articles

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

Tallyfy Manufactory offers customized pricing based on data volume storage duration API call frequency and integration options with personalized quotes available through direct sales consultation.