$table->bigIncrements('id'); |
遞增 ID（主鍵），相當(dāng)于「UNSIGNED BIG INTEGER」 |
$table->bigInteger('votes'); |
相當(dāng)于 BIGINT |
$table->binary('data'); |
相當(dāng)于 BLOB |
$table->boolean('confirmed'); |
相當(dāng)于 BOOLEAN |
$table->char('name', 100); |
相當(dāng)于帶有長度的 CHAR |
$table->date('created_at'); |
相當(dāng)于 DATE |
$table->dateTime('created_at'); |
相當(dāng)于 DATETIME |
$table->dateTimeTz('created_at'); |
相當(dāng)于帶時區(qū) DATETIME |
$table->decimal('amount', 8, 2); |
相當(dāng)于帶有精度與基數(shù) DECIMAL |
$table->double('amount', 8, 2); |
相當(dāng)于帶有精度與基數(shù) DOUBLE |
$table->enum('level', ['easy', 'hard']); |
相當(dāng)于 ENUM |
$table->float('amount', 8, 2); |
相當(dāng)于帶有精度與基數(shù) FLOAT |
$table->geometry('positions'); |
相當(dāng)于 GEOMETRY |
$table->geometryCollection('positions'); |
相當(dāng)于 GEOMETRYCOLLECTION |
$table->increments('id'); |
遞增的 ID (主鍵)，相當(dāng)于「UNSIGNED INTEGER」 |
$table->integer('votes'); |
相當(dāng)于 INTEGER |
$table->ipAddress('visitor'); |
相當(dāng)于 IP 地址 |
$table->json('options'); |
相當(dāng)于 JSON |
$table->jsonb('options'); |
相當(dāng)于 JSONB |
$table->lineString('positions'); |
相當(dāng)于 LINESTRING |
$table->longText('description'); |
相當(dāng)于 LONGTEXT |
$table->macAddress('device'); |
相當(dāng)于 MAC 地址 |
$table->mediumIncrements('id'); |
遞增 ID (主鍵) ，相當(dāng)于「UNSIGNED MEDIUM INTEGER」 |
$table->mediumInteger('votes'); |
相當(dāng)于 MEDIUMINT |
$table->mediumText('description'); |
相當(dāng)于 MEDIUMTEXT |
$table->morphs('taggable'); |
相當(dāng)于加入遞增的 taggable_id 與字符串 taggable_type
|
$table->multiLineString('positions'); |
相當(dāng)于 MULTILINESTRING |
$table->multiPoint('positions'); |
相當(dāng)于 MULTIPOINT |
$table->multiPolygon('positions'); |
相當(dāng)于 MULTIPOLYGON |
$table->nullableMorphs('taggable'); |
相當(dāng)于可空版本的 morphs() 字段 |
$table->nullableTimestamps(); |
相當(dāng)于可空版本的 timestamps() 字段 |
$table->point('position'); |
相當(dāng)于 POINT |
$table->polygon('positions'); |
相當(dāng)于 POLYGON |
$table->rememberToken(); |
相當(dāng)于可空版本的 VARCHAR(100) 的 remember_token 字段 |
$table->smallIncrements('id'); |
遞增 ID (主鍵) ，相當(dāng)于「UNSIGNED SMALL INTEGER」 |
$table->smallInteger('votes'); |
相當(dāng)于 SMALLINT |
$table->softDeletes(); |
相當(dāng)于為軟刪除添加一個可空的 deleted_at 字段 |
$table->softDeletesTz(); |
相當(dāng)于為軟刪除添加一個可空的 帶時區(qū)的 deleted_at 字段 |
$table->string('name', 100); |
相當(dāng)于帶長度的 VARCHAR |
$table->text('description'); |
相當(dāng)于 TEXT |
$table->time('sunrise'); |
相當(dāng)于 TIME |
$table->timeTz('sunrise'); |
相當(dāng)于帶時區(qū)的 TIME |
$table->timestamp('added_on'); |
相當(dāng)于 TIMESTAMP |
$table->timestampTz('added_on'); |
相當(dāng)于帶時區(qū)的 TIMESTAMP |
$table->timestamps(); |
相當(dāng)于可空的 created_at 和 updated_at TIMESTAMP |
$table->timestampsTz(); |
相當(dāng)于可空且?guī)r區(qū)的 created_at 和 updated_atTIMESTAMP |
$table->tinyIncrements('id'); |
相當(dāng)于自動遞增 UNSIGNED TINYINT |
$table->tinyInteger('votes'); |
相當(dāng)于 TINYINT |
$table->unsignedBigInteger('votes'); |
相當(dāng)于 Unsigned BIGINT |
$table->unsignedDecimal('amount', 8, 2); |
相當(dāng)于帶有精度和基數(shù)的 UNSIGNED DECIMAL |
$table->unsignedInteger('votes'); |
相當(dāng)于 Unsigned INT |
$table->unsignedMediumInteger('votes'); |
相當(dāng)于 Unsigned MEDIUMINT |
$table->unsignedSmallInteger('votes'); |
相當(dāng)于 Unsigned SMALLINT |
$table->unsignedTinyInteger('votes'); |
相當(dāng)于 Unsigned TINYINT |
$table->uuid('id'); |
相當(dāng)于 UUID |
$table->year('birth_year'); |
相當(dāng)于 YEAR |
