ServiceNow to MySQL mapping

AutoSync maps ServiceNow object types to the following MySQL column types:


ServiceNow object type	MySQL column type
`audio`	`VARCHAR`
`basic image`	`VARCHAR`
`choice`	`VARCHAR`
`collection`	`JSON`
`color`	`VARCHAR`
`condition string`	`VARCHAR`
`conditions`	`VARCHAR`
`currency`	`DECIMAL`
`data structure`	`VARCHAR`
`date`	`DATE`
`date/time`	`DATETIME`
`decimal`	`DECIMAL`
`document id`	`VARCHAR`
`domain id`	`JSON`
`domain path`	`VARCHAR`
`due date`	`VARCHAR`
`duration`	`DECIMAL`
`encrypted text`	`VARCHAR`
`field name`	`VARCHAR`
`file attachment`	`VARCHAR`
`floating point number`	`FLOAT`
`fx currency`	`DECIMAL`
`html`	`VARCHAR`
`icon`	`VARCHAR`
`image`	`VARCHAR`
`integer`	`INT`
`ip address`	`VARCHAR`
`journal`	`VARCHAR`
`journal input`	`VARCHAR`
`journal list`	`VARCHAR`
`list`	`VARCHAR`
`long`	`BIGINT`
`name-value pairs`	`VARCHAR`
`password (1 way encrypted)`	`VARCHAR`
`password (2 way encrypted)`	`VARCHAR`
`percent complete`	`DECIMAL`
`phone number (e164)`	`VARCHAR`
`price`	`DECIMAL`
`reference`	`JSON`
`script`	`VARCHAR`
`script (plain)`	`VARCHAR`
`slush bucket`	`VARCHAR`
`string`	`VARCHAR`
`string (full utf-8)`	`VARCHAR`
`suggestion`	`VARCHAR`
`sys id (guid)`	`VARCHAR`
`table name`	`VARCHAR`
`template value`	`VARCHAR`
`time`	`TIME`
`translated html`	`VARCHAR`
`translated text`	`VARCHAR`
`true/false`	`BIT`
`user roles`	`VARCHAR`
`url`	`VARCHAR`
`video`	`VARCHAR`
`wiki`	`VARCHAR`
`workflow`	`VARCHAR`
`sl_timestamp`	`DATETIME`