Payment Schematics

create_payments_table.php

<?php

Schema::create('payments', function (Blueprint $table) {
  $table->bigIncrements('id');
  $table->uuid('uuid')->unique();
  $table->uuid('member_id')->nullable(); // the person paying uuid
  $table->uuid('subscription_id')->nullable(); //if you have a subscription table else delete this line
  $table->uuid('transaction_id')->nullable();
  $table->float('amount', 10, 2)->nullable();
  $table->string('reference_id')->nullable(); //paystack or flutter reference
  $table->text('comments')->nullable(); //any comment relevant to the payment
  $table->boolean('success')->nullable();

  $table->timestamps();
  
  $table->foreign('transaction_id')->references('uuid')->on('transactions');
});

create_transactions_table.php

<?php

Schema::create('transactions', function (Blueprint $table) {
    $table->bigIncrements('id');
    $table->uuid('uuid')->unique();
    $table->string('txref')->nullable(); //transaction ref - both paystack or flutter has 
    $table->string('first_name')->nullable();
    $table->string('last_name')->nullable();
    $table->string('email')->nullable();
    $table->string('customer_id')->nullable();
    $table->string('phone')->nullable();
    $table->float('amount', 12, 2)->nullable();
    $table->string('status')->nullable(); //attempted , successful, failed
    $table->string('purpose')->nullable(); // reason of payment
    $table->boolean('completed')->nullable();
    $table->text('gateway_message')->nullable(); // gateway response
    $table->bigInteger('start')->nullable(); // time the payment was initiated (This is for unix timestamps, you can remove it)
    $table->bigInteger('ends')->nullable(); // time the payment was successful or not (This is for unix timestamps, you can remove it)
    $table->timestamps();
});