Representation

Type Registry

representation

Numbers, booleans, encodings, and scientific notation

29 types

boolean

3

Binary Boolean (0/1) binary

BOOLEAN 0

Boolean Initials (T/F, Y/N) initials

BOOLEAN T

Boolean Terms (True/False, Yes/No) terms

BOOLEAN true

code

1

Alphanumeric Identifier alphanumeric_id

VARCHAR SKU-12345

discrete

2

Categorical Value categorical

VARCHAR active

Ordinal Value ordinal

VARCHAR high

file

4

Excel Number Format String excel_format

VARCHAR #,##0.00

File Extension extension

VARCHAR txt

File Size file_size

BIGINT 1024

MIME Type mime_type

VARCHAR text/plain

numeric

6

Decimal Number decimal_number

DOUBLE 3.14

Increment / Counter increment

BIGINT 1

Integer Number integer_number

BIGINT 42

Percentage percentage

DOUBLE 50%

Scientific Notation scientific_notation

DOUBLE 1.23e-4

SI-Prefix Number si_number

DOUBLE 12.2K

scientific

5

DNA Sequence dna_sequence

VARCHAR ATGCAGC

Measurement Unit measurement_unit

VARCHAR meter

Metric Prefix metric_prefix

VARCHAR kilo

Protein Sequence protein_sequence

VARCHAR MKVLLIVGS

RNA Sequence rna_sequence

VARCHAR AUGCAGC

text

8

Color (Hexadecimal) color_hex

VARCHAR #FF0000

Color (RGB) color_rgb

VARCHAR rgb(255, 0, 0)

Emoji emoji

VARCHAR 😀

Entity Name entity_name

VARCHAR The Olive Garden

Paragraph paragraph

VARCHAR This product works great…

Plain Text plain_text

VARCHAR This is a plain text des…

Sentence sentence

VARCHAR This is a complete sente…

Single Word word

VARCHAR hello