Data Types¶
RayforceDB supports several categories of data types. Each category serves a specific purpose in the database system:
B8¶
Boolean value representing true or false.
Integers¶
8-bit unsigned integer and 16/32/64-bit signed integers.
Symbol¶
Interned string used for efficient string storage and comparison.
Temporal¶
Date (YYYY.MM.DD), Time (HH:MM:SS.mmm), and Timestamp (YYYY.MM.DD\DHH:MM:SS.mmm) formats.
F64¶
64-bit signed floating-point number.
GUID¶
Globally Unique Identifier for unique identification of objects.
C8¶
Single character value.
Vector¶
Represents a collection of elements of a certain type, enabling efficient storage and operations on homogeneous data.
String¶
List¶
Represents a collection of elements that are not necessarily of the same type.
Table¶
An object that holds information about the columns and rows of a specific dataset, forming the core structure for relational operations.
Dictionary¶
An object that holds information about keys and their corresponding values.
Function¶
Built-in or custom user-defined functions and lambdas that perform operations on data.
Enum¶
An enumeration of certain values, providing a way to represent a fixed set of named constants.
Symbols & Enums In-Depth¶
Comprehensive guide explaining symbol interning, why enumerations are essential for storage, how symfiles work, and why shared symfiles are required for parted tables. Recommended reading for newcomers.
Other¶
Special types including Null and Error used throughout the system.
What is a Type Code?¶
A type code is a specific integer that represents a particular data type. It's primarily used in internal object evaluations.