MeridianMERIDIAN

representation

Numbers, booleans, encodings, and scientific notation

Type Registry

representation

Numbers, booleans, encodings, and scientific notation

36 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
ENUMactive
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

3
Color (Hexadecimal)color_hex
VARCHAR#FF0000
Color (HSL)color_hsl
VARCHARhsl(120, 100%, 50%)
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 (Comma Separator)decimal_number_comma
DOUBLE1.234,56
Integer Numberinteger_number
BIGINT42
Percentagepercentage
DOUBLE50%
Scientific Notationscientific_notation
DOUBLE1.23e-4
SI-Prefix Numbersi_number
DOUBLE12.2K

scientific

8
CAS Registry Numbercas_number
VARCHAR7732-18-5
DNA Sequencedna_sequence
VARCHARATGCAGC
InChI Identifierinchi
VARCHARInChI=1S/H2O/h1H2
Measurement Unitmeasurement_unit
VARCHARmeter
Metric Prefixmetric_prefix
VARCHARkilo
Protein Sequenceprotein_sequence
VARCHARMKVLLIVGS
RNA Sequencerna_sequence
VARCHARAUGCAGC
SMILES Notationsmiles
VARCHARO

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

Type Registry