Meridianmeridian
Type Registry

representation

Numbers, booleans, encodings, and scientific notation

32 types

boolean

3
Binary Boolean (0/1)binary
BOOLEAN0
Boolean Initials (T/F, Y/N)initials
BOOLEANT
Boolean Terms (True/False, Yes/No)terms
BOOLEANtrue

discrete

2
Categorical Valuecategorical
VARCHARactive
Ordinal Valueordinal
VARCHARhigh

file

4
Excel Number Format Stringexcel_format
VARCHAR#,##0.00
File Extensionextension
VARCHARtxt
File Sizefile_size
BIGINT1024
MIME Typemime_type
VARCHARtext/plain

format

2
Color (Hexadecimal)color_hex
VARCHAR#FF0000
Color (RGB)color_rgb
VARCHARrgb(255, 0, 0)

identifier

4
Alphanumeric Identifieralphanumeric_id
VARCHARSKU-12345
Increment / Counterincrement
BIGINT1
Numeric Codenumeric_code
VARCHAR840
UUIDuuid
UUID550e8400-e29b-41d4-a716-4466…

numeric

6
Decimal Numberdecimal_number
DOUBLE3.14
Decimal Number (EU Format)decimal_number_eu
DOUBLE1.234,56
Integer Numberinteger_number
BIGINT42
Percentagepercentage
DOUBLE50%
Scientific Notationscientific_notation
DOUBLE1.23e-4
SI-Prefix Numbersi_number
DOUBLE12.2K

scientific

5
DNA Sequencedna_sequence
VARCHARATGCAGC
Measurement Unitmeasurement_unit
VARCHARmeter
Metric Prefixmetric_prefix
VARCHARkilo
Protein Sequenceprotein_sequence
VARCHARMKVLLIVGS
RNA Sequencerna_sequence
VARCHARAUGCAGC

text

6
Emojiemoji
VARCHAR😀
Entity Nameentity_name
VARCHARThe Olive Garden
Paragraphparagraph
VARCHARThis product works great. I …
Plain Textplain_text
VARCHARThis is a plain text descrip…
Sentencesentence
VARCHARThis is a complete sentence.
Single Wordword
VARCHARhello