bantenprov / retribusi-pelayanan-kesehatan

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

class CreateItemsTable extends Migration {

	public function up()

	{

		Schema::create('items', function(Blueprint $table) {

			$table->increments('id');

			$table->uuid('uuid', 191)->unique();

			$table->string('keterangan', 191)->nullable();

			$table->double('tarif');

			$table->integer('jumlah');

			$table->double('subtotal');

			$table->integer('transaksi_id')->unsigned()->nullable()->index();

			$table->integer('tarif_id')->unsigned()->nullable()->index();

			$table->integer('rekening_id')->unsigned()->nullable()->index();

			$table->uuid('transaksi_uuid', 191)->index();

			$table->uuid('tarif_uuid', 191)->index();

			$table->uuid('rekening_uuid', 191)->index();

			$table->timestamps();

			$table->softDeletes();

		});

	}

	public function down()

	{

		Schema::drop('items');

	}

}

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

class CreateTransaksiesTable extends Migration {

	public function up()

	{

		Schema::create('transaksies', function(Blueprint $table) {

			$table->increments('id');

			$table->uuid('uuid', 191)->unique();

			$table->string('nomor', 191)->unique();

			$table->double('total');

			$table->double('grandtotal')->nullable();

			$table->double('denda')->default('0.00');

			$table->double('potongan');

			$table->integer('admin_id')->unsigned()->nullable()->index();

			$table->integer('customer_transaksi_id')->unsigned()->nullable()->index();

			$table->integer('tarif_id')->unsigned()->nullable();

			$table->uuid('admin_uuid', 191)->index();

			$table->uuid('customer_transaksi_uuid', 191)->index();

			$table->uuid('tarif_uuid')->index();

			$table->timestamps();

			$table->softDeletes();

		});

	}

	public function down()

	{

		Schema::drop('transaksies');

	}

}