8.3Liquibase映射类型一览表

Liquibase类型别名
boolean{“java.sql.Types.BOOLEAN”, “java.lang.Boolean”, “bit”, “bool”}
tinyintjava.sql.Types.TINYINT
smallint{“java.sql.Types.SMALLINT”, “int2”}
mediumint
int{ “integer”, “java.sql.Types.INTEGER”, “java.lang.Integer”, “serial”, “int4”, “serial4” }
bigint{“java.sql.Types.BIGINT”, “java.math.BigInteger”, “java.lang.Long”, “integer8”, “bigserial”, “serial8”, “int8”}
decimal{ “java.sql.Types.DECIMAL”, “java.math.BigDecimal” }
number{“numeric”, “java.sql.Types.NUMERIC”}
float{“java.sql.Types.FLOAT”, “java.lang.Float”, “real”, “java.sql.Types.REAL”}
double{“java.sql.Types.DOUBLE”, “java.lang.Double”}
currency{“money”, “smallmoney”}
nchar{ “java.sql.Types.NCHAR”, “nchar2”}
nvarchar{“java.sql.Types.NVARCHAR”, “nvarchar2”, “national”}
char{“java.sql.Types.CHAR”, “bpchar”}
varchar{“java.sql.Types.VARCHAR”, “java.lang.String”, “varchar2”, “character varying”}
clob{“longvarchar”, “text”, “longtext”, “java.sql.Types.LONGVARCHAR”, “java.sql.Types.CLOB”, “nclob”, “longnvarchar”, “ntext”, “java.sql.Types.LONGNVARCHAR”, “java.sql.Types.NCLOB”, “tinytext”, “mediumtext”}
blob{“longblob”, “longvarbinary”, “java.sql.Types.BLOB”, “java.sql.Types.LONGBLOB”, “java.sql.Types.LONGVARBINARY”, “java.sql.Types.VARBINARY”, “java.sql.Types.BINARY”, “varbinary”, “binary”, “image”, “tinyblob”, “mediumblob”}
date{“java.sql.Types.DATE”, “java.sql.Date”}
time{“java.sql.Types.TIME”, “java.sql.Time”, “timetz”}
datetime
timestamp{“java.sql.Types.TIMESTAMP”, “java.sql.Types.TIMESTAMP_WITH_TIMEZONE”, “java.sql.Timestamp”, “timestamptz”}
uuid{ “uniqueidentifier”, “java.util.UUID” }
xml{ “xmltype”, “java.sql.Types.SQLXML” }
functionliquibase.statement.DatabaseFunction

原创文章,作者:huoxiaoqiang,如若转载,请注明出处:https://www.huoxiaoqiang.com/back/java/8675.html

发表评论

登录后才能评论