Column data types mapping in MySQL, Postgres, SQLite and CUBRID

MySQL	Postgres	SQLite	CUBRID	Min	Max	Storage
TINYINT (3)	*	*	*	-128	127	1byte
tinyint unsigned	*	*	*	0	255	1byte
SMALLINT (5)	SMALLINT	*	SMALLINT	-32768	32767	2bytes
smallint unsigned	*	*	*	0	65535	2bytes
INT (10)	INT	INT	INT	-2147483648	2147483647	4bytes
int unsigned	*	*	*	0	4294967295	4bytes
BIGINT (20)	BIGINT	*	BIGINT	-9223372036854775808	9223372036854775807	8bytes
SERIAL	SERIAL	*	*	my:bigint unsigned not null unique	pg:int not null default nextval('tab_col_seq')
*	BIGSERIAL	*	*		bigint not null default nextval('tab_col_seq')	8bytes
FLOAT	NUMERIC	REAL	NUMERIC	my:-3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38 pg:131072-digit.16383-digit		4bytes
ENUM	*	*	*		max 65K val	2bytes
MySQL	Postgres	SQLite	CUBRID	Min	Max	Storage
DATE	DATE	*	DATE	my:1000-01-01 pg:4713-01-01 BC cb:0001-01-01	my:9999-12-31 pg:9999-12-31 :) cb:9999-12-31	3bytes 4bytes
TIME	TIME	*	TIME	00:00:00	23:59:59	3bytes
TIMESTAMP default now()	TIMESTAMP default now()	*	TIMESTAMP	my:1970-01-01 00:00:01 pg:4713-01-01 00:00:00 BC	my:2038-01-19 03:14:07 pg:9999-12-31 00:00:00	8bytes