2021_05_27_103720_create_ownersundryfeedetails_table.php 902 B

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