模型字段与数据库类型的对应
在此列出 ORM 推荐的对应数据库类型,自动建表功能也会以此为标准。
默认所有的字段都是 NOT NULL
MySQL
go | mysql |
---|
int, int32 - 设置 auto 或者名称为 Id 时 | integer AUTO_INCREMENT |
int64 - 设置 auto 或者名称为 Id 时 | bigint AUTO_INCREMENT |
uint, uint32 - 设置 auto 或者名称为 Id 时 | integer unsigned AUTO_INCREMENT |
uint64 - 设置 auto 或者名称为 Id 时 | bigint unsigned AUTO_INCREMENT |
bool | bool |
string - 默认为 size 255 | varchar(size) |
string - 设置 type(char) 时 | char(size) |
string - 设置 type(text) 时 | longtext |
time.Time - 设置 type 为 date 时 | date |
time.Time | datetime |
byte | tinyint unsigned |
rune | integer |
int | integer |
int8 | tinyint |
int16 | smallint |
int32 | integer |
int64 | bigint |
uint | integer unsigned |
uint8 | tinyint unsigned |
uint16 | smallint unsigned |
uint32 | integer unsigned |
uint64 | bigint unsigned |
float32 | double precision |
float64 | double precision |
float64 - 设置 digits, decimals 时 | numeric(digits, decimals) |
Sqlite3
go | sqlite3 |
---|
int, int32, int64, uint, uint32, uint64 - 设置 auto 或者名称为 Id 时 | integer AUTOINCREMENT |
bool | bool |
string - 默认为 size 255 | varchar(size) |
string - 设置 type(char) 时 | character(size) |
string - 设置 type(text) 时 | text |
time.Time - 设置 type 为 date 时 | date |
time.Time | datetime |
byte | tinyint unsigned |
rune | integer |
int | integer |
int8 | tinyint |
int16 | smallint |
int32 | integer |
int64 | bigint |
uint | integer unsigned |
uint8 | tinyint unsigned |
uint16 | smallint unsigned |
uint32 | integer unsigned |
uint64 | bigint unsigned |
float32 | real |
float64 | real |
float64 - 设置 digits, decimals 时 | decimal |
PostgreSQL
go | postgres |
---|
int, int32, int64, uint, uint32, uint64 - 设置 auto 或者名称为 Id 时 | serial |
bool | bool |
string - 若没有指定 size 默认为 text | varchar(size) |
string - 设置 type(char) 时 | char(size) |
string - 设置 type(text) 时 | text |
string - 设置 type(json) 时 | json |
string - 设置 type(jsonb) 时 | jsonb |
time.Time - 设置 type 为 date 时 | date |
time.Time | timestamp with time zone |
byte | smallint CHECK("column" >= 0 AND "column" <= 255) |
rune | integer |
int | integer |
int8 | smallint CHECK("column" >= -127 AND "column" <= 128) |
int16 | smallint |
int32 | integer |
int64 | bigint |
uint | bigint CHECK("column" >= 0) |
uint8 | smallint CHECK("column" >= 0 AND "column" <= 255) |
uint16 | integer CHECK("column" >= 0) |
uint32 | bigint CHECK("column" >= 0) |
uint64 | bigint CHECK("column" >= 0) |
float32 | double precision |
float64 | double precision |
float64 - 设置 digits, decimals 时 | numeric(digits, decimals) |