sys.db

..
RecordField

RecordInfos

RecordRelation

SBigId

big int with auto increment

SBigInt

SBinary

MediumBlob type (up to 24MB)

SBool

use tinyint(1) to distinguish with int

SBytes

same as binary(n)

SData

allow to store any value in serialized form

SDate

date only, use SDateTime for date+time

SDateTime

mysql DateTime

SEncoded

specify that the integer use custom encoding

SEnum

allow to store an enum value that does not have parameters as a simple int

SFlags

a set of bitflags of different enum values

SFloat

double precision float

SId

int with auto increment

SInt

SLongBinary

LongBlob type (up to 4GB)

SMediumInt

three bytes signed [-8388608...8388607]

SMediumUInt

three bytes [0...16777215]

SNekoSerialized

native neko serialized bytes

SNull

specify that this field is nullable

SSerialized

haxe Serialized string

SSingle

single precision float

SSmallBinary

Blob type (up to 64KB)

SSmallFlags

same as [SFlags] but will adapt the storage size to the number of flags

SSmallInt

two bytes signed [-32768...32767]

SSmallText

Text (up to 64KB)

SSmallUInt

two bytes [0...65535]

SString

same as varchar(n)

SText

MediumText (up to 24MB)

STimeStamp

mysql Timestamp

STinyInt

one byte signed [-128...127]

STinyText

TinyText (up to 255 bytes)

STinyUInt

one byte [0...255]

SUId

int unsigned with auto increment

SUInt