SQL Column Types

MySQL/MariaDB

HCL	SQL	Attributes	Example
bigint	bigint	unsigned (bool) size (int)	`type = bigint(255)` `unsigned = true`
binary	binary	size (int)	`type = binary(255)`
bit	bit	size (int)	`type = bit(255)`
blob	blob	size (int)	`type = blob(255)`
bool	bool		`type = bool`
boolean	boolean		`type = boolean`
char	char	size (int)	`type = char(255)`
date	date	precision (int)	`type = date(10)`
datetime	datetime	precision (int)	`type = datetime(10)`
decimal	decimal	unsigned (bool) precision (int) scale (int)	`type = decimal(10,2)` `unsigned = true`
double	double	unsigned (bool) precision (int) scale (int)	`type = double(10,2)` `unsigned = true`
enum	enum	values (slice)	`type = enum("a","b")`
float	float	unsigned (bool) precision (int) scale (int)	`type = float(10,2)` `unsigned = true`
geometry	geometry		`type = geometry`
geometrycollection	geometrycollection		`type = geometrycollection`
int	int	unsigned (bool) size (int)	`type = int(255)` `unsigned = true`
json	json		`type = json`
linestring	linestring		`type = linestring`
longblob	longblob		`type = longblob`
longtext	longtext		`type = longtext`
mediumblob	mediumblob		`type = mediumblob`
mediumint	mediumint	unsigned (bool) size (int)	`type = mediumint(255)` `unsigned = true`
mediumtext	mediumtext		`type = mediumtext`
multilinestring	multilinestring		`type = multilinestring`
multipoint	multipoint		`type = multipoint`
multipolygon	multipolygon		`type = multipolygon`
numeric	numeric	unsigned (bool) precision (int) scale (int)	`type = numeric(10,2)` `unsigned = true`
point	point		`type = point`
polygon	polygon		`type = polygon`
real	real	unsigned (bool) precision (int) scale (int)	`type = real(10,2)` `unsigned = true`
set	set	values (slice)	`type = set("a","b")`
smallint	smallint	unsigned (bool) size (int)	`type = smallint(255)` `unsigned = true`
text	text	size (int)	`type = text(255)`
time	time	precision (int)	`type = time(10)`
timestamp	timestamp	precision (int)	`type = timestamp(10)`
tinyblob	tinyblob		`type = tinyblob`
tinyint	tinyint	unsigned (bool) size (int)	`type = tinyint(255)` `unsigned = true`
tinytext	tinytext		`type = tinytext`
varbinary	varbinary	size (int)	`type = varbinary(255)`
varchar	varchar	size (int)	`type = varchar(255)`
year	year	precision (int)	`type = year(10)`

Postgres

HCL	SQL	Attributes	Example
bigint	bigint		`type = bigint`
bigserial	bigserial		`type = bigserial`
bit	bit	len (int64)	`type = bit(255)`
bit_varying	bit varying	len (int64)	`type = bit_varying(255)`
bool	bool		`type = bool`
boolean	boolean		`type = boolean`
box	box		`type = box`
bytea	bytea		`type = bytea`
char	char	size (int)	`type = char(255)`
character	character	size (int)	`type = character(255)`
character_varying	character varying	size (int)	`type = character_varying(255)`
cidr	cidr		`type = cidr`
circle	circle		`type = circle`
date	date		`type = date`
decimal	decimal		`type = decimal`
double_precision	double precision		`type = double_precision`
enum	my_enum		`enum = enum.my_enum` In Postgres an enum type is created as a custom type and can then be referenced in a column definition. Therefore, you have to add an enum block to your HCL schema like below: `enum "my_enum" { values = ["on", "off"] }`
float4	float4		`type = float4`
float8	float8		`type = float8`
hstore	hstore		`type = hstore`
inet	inet		`type = inet`
int	int		`type = int`
int2	int2		`type = int2`
int4	int4		`type = int4`
int8	int8		`type = int8`
integer	integer		`type = integer`
json	json		`type = json`
jsonb	jsonb		`type = jsonb`
line	line		`type = line`
lseg	lseg		`type = lseg`
macaddr	macaddr		`type = macaddr`
macaddr8	macaddr8		`type = macaddr8`
money	money		`type = money`
numeric	numeric		`type = numeric`
path	path		`type = path`
point	point		`type = point`
real	real		`type = real`
serial	serial		`type = serial`
serial2	serial2		`type = serial2`
serial4	serial4		`type = serial4`
serial8	serial8		`type = serial8`
smallint	smallint		`type = smallint`
smallserial	smallserial		`type = smallserial`
sql	sql	def (string)	`type = sql("a")`
text	text		`type = text`
time	time	precision (int)	`type = time(10)`
timestamp	timestamp	precision (int)	`type = timestamp(10)`
timestamptz	timestamptz	precision (int)	`type = timestamptz(10)`
timetz	timetz	precision (int)	`type = timetz(10)`
uuid	uuid		`type = uuid`
varchar	varchar	size (int)	`type = varchar(255)`
xml	xml		`type = xml`

SQLite

HCL	SQL	Attributes	Example
bigint	bigint	size (int)	`type = bigint(255)`
blob	blob	size (int)	`type = blob(255)`
boolean	boolean		`type = boolean`
character	character	size (int)	`type = character(255)`
clob	clob	size (int)	`type = clob(255)`
date	date		`type = date`
datetime	datetime		`type = datetime`
decimal	decimal	precision (int) scale (int)	`type = decimal(10,2)`
double	double	size (int)	`type = double(255)`
double_precision	double precision	size (int)	`type = double_precision(255)`
float	float	size (int)	`type = float(255)`
int	int	size (int)	`type = int(255)`
int2	int2	size (int)	`type = int2(255)`
int8	int8	size (int)	`type = int8(255)`
integer	integer	size (int)	`type = integer(255)`
json	json		`type = json`
mediumint	mediumint	size (int)	`type = mediumint(255)`
native_character	native character	size (int)	`type = native_character(255)`
nchar	nchar	size (int)	`type = nchar(255)`
numeric	numeric	precision (int) scale (int)	`type = numeric(10,2)`
nvarchar	nvarchar	size (int)	`type = nvarchar(255)`
real	real	precision (int) scale (int)	`type = real(10,2)`
smallint	smallint	size (int)	`type = smallint(255)`
text	text	size (int)	`type = text(255)`
tinyint	tinyint	size (int)	`type = tinyint(255)`
unsigned_big_int	unsigned big int	size (int)	`type = unsigned_big_int(255)`
uuid	uuid		`type = uuid`
varchar	varchar	size (int)	`type = varchar(255)`
varying_character	varying character	size (int)	`type = varying_character(255)`

MySQL/MariaDB​

Postgres​

SQLite​

MySQL/MariaDB

Postgres

SQLite