2021_05_27_103720_create_ownersundryfeedetails_table.php 941 B

12345678910111213141516171819202122232425262728
  1. <?php
  2. use Illuminate\Database\Schema\Blueprint;
  3. use Illuminate\Database\Migrations\Migration;
  4. use Illuminate\Support\Facades\Schema;
  5. class CreateOwnerSundryFeeDetailsTable extends Migration
  6. {
  7. public function up()
  8. {
  9. Schema::create('owner_sundry_fee_details', function(Blueprint $table) {
  10. $table->increments('id');
  11. $table->integer('owner_id')->comment('货主ID');
  12. $table->integer('type')->unsigned()->comment('作业类型');
  13. $table->string('fee_explain')->nullable()->comment('费用描述');
  14. $table->string('remark')->nullable()->comment('备注');
  15. $table->decimal('fee')->default(0)->comment('收费金额');
  16. $table->integer('changable')->unsigned()->default(1)->comment('冻结状态');
  17. $table->softDeletes();
  18. $table->timestamps();
  19. });
  20. }
  21. public function down()
  22. {
  23. Schema::drop('owner_sundry_fee_details');
  24. }
  25. }