관리-도구

편집 파일: 2024_09_12_120434_create_purchase_details_table.php

<?php

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

return new class extends Migration
{
    public function up(): void
    {
        Schema::create(
            'purchase_details',
            function (Blueprint $table) {
                $table->id();
                $table->string('purchase_number');
                $table->foreignId('purchase_id')->reference('id')->on('purchases');
                $table->unsignedBigInteger('course_id')->nullable();
                $table->unsignedBigInteger('bundle_id')->nullable();
                $table->foreignId('user_id')->reference('id')->on('users');
                $table->decimal('price')->nullable();
                $table->json('details');
                $table->enum('type', ['enrolled', 'purchase']);
                $table->enum('purchase_type', ['bundle', 'course'])->nullable();
                $table->enum('status', ['processing', 'completed', 'pending'])->default('processing');
                $table->timestamps();
                $table->foreign('course_id')->references('id')->on('courses');
                $table->foreign('bundle_id')->references('id')->on('course_bundles');
                $table->softDeletes();
            }
        );
    }
    public function down(): void
    {
        Schema::dropIfExists('purchase_details');
    }
};

Edulab LMS