Skip to content

Appendix A: Data type descriptions

This appendix provides detailed descriptions of the data types used in the database schema. Understanding these data types is essential for interpreting the structure and constraints of the data stored within the system.

Numeric data types

  • NUMBER: Numeric data type.
  • FLOAT: Floating-point numeric data type that stores approximate numeric values with double precision.

Character string data types

  • VARCHAR: Variable-length character string data type.

Date and time data types

  • DATE: Data type that stores dates without time information. It accepts dates in the format YYYY-MM-DD, for example, 2024-08-27.
  • TIMESTAMP_NTZ(9): Timestamp data type that stores date and time information without taking any time zone into account, with up to 9 digits of precision for fractional seconds (nanoseconds). The accepted format is YYYY-MM-DD HH:MM:SS.NANOSECONDS, for example, 2024-08-27 11:35:58.671. If the time component is not provided, it defaults to 00:00:00.000.