MeridianMERIDIAN
Type Registry

representation

Numbers, booleans, encodings, and scientific notation

8 categories · 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

1
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

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

text

4
Emojiemoji
VARCHAR😀
Entity Nameentity_name
VARCHARThe Olive Garden
Plain Textplain_text
VARCHARThis is a plain text descrip…
Single Wordword
VARCHARhello

Type Registry