<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCarouselsTable extends Migration
{
  /**
   * Run the migrations.
   *
   * @return void
   */
  public function up()
  {
    Schema::create('carousels', function (Blueprint $table) {
      $table->id();
      $table->string('name', 20);
      $table->string('image', 200);
      $table->string('desc', 50);
      $table->bigInteger('hospital')->index();
      $table->tinyInteger('type')->comment('1-轮播图 2-广告')->index();
      $table->tinyInteger('jump_type')->comment('1-无跳转 2-小程序跳转 3-H5跳转');
      $table->string('jump_path', 200);
      $table->tinyInteger('login_type')->comment('1-需要 2-不需要');
      $table->dateTime('start_time');
      $table->dateTime('end_time');
      $table->tinyInteger('status');
      $table->timestamps();
    });
  }

  /**
   * Reverse the migrations.
   *
   * @return void
   */
  public function down()
  {
    Schema::dropIfExists('carousels');
  }
}