golang beego orm mysql sqlite3 postgresql 模型字段数据库类型对应关系

迷南。 2021-09-02 10:57 345阅读 0赞

**目录**

MySQL

Sqlite3

PostgreSQL

关系型字段

--------------------

在此列出 ORM 推荐的对应数据库类型，自动建表功能也会以此为标准。

默认所有的字段都是 NOT NULL

### MySQL ###

<table> 
 <tbody> 
  <tr> 
   <td>go</td> 
   <td>mysql</td> 
  </tr> 
 </tbody> 
 <tbody> 
  <tr> 
   <td>int, int32 - 设置 auto 或者名称为&nbsp;<code>Id</code>&nbsp;时</td> 
   <td>integer AUTO_INCREMENT</td> 
  </tr> 
  <tr> 
   <td>int64 - 设置 auto 或者名称为&nbsp;<code>Id</code>&nbsp;时</td> 
   <td>bigint AUTO_INCREMENT</td> 
  </tr> 
  <tr> 
   <td>uint, uint32 - 设置 auto 或者名称为&nbsp;<code>Id</code>&nbsp;时</td> 
   <td>integer unsigned AUTO_INCREMENT</td> 
  </tr> 
  <tr> 
   <td>uint64 - 设置 auto 或者名称为&nbsp;<code>Id</code>&nbsp;时</td> 
   <td>bigint unsigned AUTO_INCREMENT</td> 
  </tr> 
  <tr> 
   <td>bool</td> 
   <td>bool</td> 
  </tr> 
  <tr> 
   <td>string - 默认为 size 255</td> 
   <td>varchar(size)</td> 
  </tr> 
  <tr> 
   <td>string - 设置 type(text) 时</td> 
   <td>longtext</td> 
  </tr> 
  <tr> 
   <td>time.Time - 设置 type 为 date 时</td> 
   <td>date</td> 
  </tr> 
  <tr> 
   <td>time.Time</td> 
   <td>datetime</td> 
  </tr> 
  <tr> 
   <td>byte</td> 
   <td>tinyint unsigned</td> 
  </tr> 
  <tr> 
   <td>rune</td> 
   <td>integer</td> 
  </tr> 
  <tr> 
   <td>int</td> 
   <td>integer</td> 
  </tr> 
  <tr> 
   <td>int8</td> 
   <td>tinyint</td> 
  </tr> 
  <tr> 
   <td>int16</td> 
   <td>smallint</td> 
  </tr> 
  <tr> 
   <td>int32</td> 
   <td>integer</td> 
  </tr> 
  <tr> 
   <td>int64</td> 
   <td>bigint</td> 
  </tr> 
  <tr> 
   <td>uint</td> 
   <td>integer unsigned</td> 
  </tr> 
  <tr> 
   <td>uint8</td> 
   <td>tinyint unsigned</td> 
  </tr> 
  <tr> 
   <td>uint16</td> 
   <td>smallint unsigned</td> 
  </tr> 
  <tr> 
   <td>uint32</td> 
   <td>integer unsigned</td> 
  </tr> 
  <tr> 
   <td>uint64</td> 
   <td>bigint unsigned</td> 
  </tr> 
  <tr> 
   <td>float32</td> 
   <td>double precision</td> 
  </tr> 
  <tr> 
   <td>float64</td> 
   <td>double precision</td> 
  </tr> 
  <tr> 
   <td>float64 - 设置 digits, decimals 时</td> 
   <td>numeric(digits, decimals)</td> 
  </tr> 
 </tbody> 
</table>

### Sqlite3 ###

<table> 
 <tbody> 
  <tr> 
   <td>go</td> 
   <td>sqlite3</td> 
  </tr> 
 </tbody> 
 <tbody> 
  <tr> 
   <td>int, int32, int64, uint, uint32, uint64 - 设置 auto 或者名称为&nbsp;<code>Id</code>&nbsp;时</td> 
   <td>integer AUTOINCREMENT</td> 
  </tr> 
  <tr> 
   <td>bool</td> 
   <td>bool</td> 
  </tr> 
  <tr> 
   <td>string - 默认为 size 255</td> 
   <td>varchar(size)</td> 
  </tr> 
  <tr> 
   <td>string - 设置 type(text) 时</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>time.Time - 设置 type 为 date 时</td> 
   <td>date</td> 
  </tr> 
  <tr> 
   <td>time.Time</td> 
   <td>datetime</td> 
  </tr> 
  <tr> 
   <td>byte</td> 
   <td>tinyint unsigned</td> 
  </tr> 
  <tr> 
   <td>rune</td> 
   <td>integer</td> 
  </tr> 
  <tr> 
   <td>int</td> 
   <td>integer</td> 
  </tr> 
  <tr> 
   <td>int8</td> 
   <td>tinyint</td> 
  </tr> 
  <tr> 
   <td>int16</td> 
   <td>smallint</td> 
  </tr> 
  <tr> 
   <td>int32</td> 
   <td>integer</td> 
  </tr> 
  <tr> 
   <td>int64</td> 
   <td>bigint</td> 
  </tr> 
  <tr> 
   <td>uint</td> 
   <td>integer unsigned</td> 
  </tr> 
  <tr> 
   <td>uint8</td> 
   <td>tinyint unsigned</td> 
  </tr> 
  <tr> 
   <td>uint16</td> 
   <td>smallint unsigned</td> 
  </tr> 
  <tr> 
   <td>uint32</td> 
   <td>integer unsigned</td> 
  </tr> 
  <tr> 
   <td>uint64</td> 
   <td>bigint unsigned</td> 
  </tr> 
  <tr> 
   <td>float32</td> 
   <td>real</td> 
  </tr> 
  <tr> 
   <td>float64</td> 
   <td>real</td> 
  </tr> 
  <tr> 
   <td>float64 - 设置 digits, decimals 时</td> 
   <td>decimal</td> 
  </tr> 
 </tbody> 
</table>

### PostgreSQL ###

<table> 
 <tbody> 
  <tr> 
   <td>go</td> 
   <td>postgres</td> 
  </tr> 
 </tbody> 
 <tbody> 
  <tr> 
   <td>int, int32, int64, uint, uint32, uint64 - 设置 auto 或者名称为&nbsp;<code>Id</code>&nbsp;时</td> 
   <td>serial</td> 
  </tr> 
  <tr> 
   <td>bool</td> 
   <td>bool</td> 
  </tr> 
  <tr> 
   <td>string - 默认为 size 255</td> 
   <td>varchar(size)</td> 
  </tr> 
  <tr> 
   <td>string - 设置 type(text) 时</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>time.Time - 设置 type 为 date 时</td> 
   <td>date</td> 
  </tr> 
  <tr> 
   <td>time.Time</td> 
   <td>timestamp with time zone</td> 
  </tr> 
  <tr> 
   <td>byte</td> 
   <td>smallint CHECK(“column” &gt;= 0 AND “column” &lt;= 255)</td> 
  </tr> 
  <tr> 
   <td>rune</td> 
   <td>integer</td> 
  </tr> 
  <tr> 
   <td>int</td> 
   <td>integer</td> 
  </tr> 
  <tr> 
   <td>int8</td> 
   <td>smallint CHECK(“column” &gt;= -127 AND “column” &lt;= 128)</td> 
  </tr> 
  <tr> 
   <td>int16</td> 
   <td>smallint</td> 
  </tr> 
  <tr> 
   <td>int32</td> 
   <td>integer</td> 
  </tr> 
  <tr> 
   <td>int64</td> 
   <td>bigint</td> 
  </tr> 
  <tr> 
   <td>uint</td> 
   <td>bigint CHECK(“column” &gt;= 0)</td> 
  </tr> 
  <tr> 
   <td>uint8</td> 
   <td>smallint CHECK(“column” &gt;= 0 AND “column” &lt;= 255)</td> 
  </tr> 
  <tr> 
   <td>uint16</td> 
   <td>integer CHECK(“column” &gt;= 0)</td> 
  </tr> 
  <tr> 
   <td>uint32</td> 
   <td>bigint CHECK(“column” &gt;= 0)</td> 
  </tr> 
  <tr> 
   <td>uint64</td> 
   <td>bigint CHECK(“column” &gt;= 0)</td> 
  </tr> 
  <tr> 
   <td>float32</td> 
   <td>double precision</td> 
  </tr> 
  <tr> 
   <td>float64</td> 
   <td>double precision</td> 
  </tr> 
  <tr> 
   <td>float64 - 设置 digits, decimals 时</td> 
   <td>numeric(digits, decimals)</td> 
  </tr> 
 </tbody> 
</table>

### 关系型字段 ###

其字段类型取决于对应的主键。

*  RelForeignKey
 *  RelOneToOne
 *  RelManyToMany
 *  RelReverseOne
 *  RelReverseMany