File size: 1,376 Bytes
85b674d | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 | <?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
return new class extends Migration
{
/**
* Run the migrations.
*/
public function up(): void
{
Schema::create('users', function (Blueprint $table) {
$table->id();
// --- Data Akun (Default Laravel) ---
$table->string('name'); // Nama Lengkap
$table->string('email')->unique();
$table->timestamp('email_verified_at')->nullable();
$table->string('password');
$table->rememberToken();
// --- Data Profil Tambahan (RUJAK Specific) ---
$table->string('nip', 20)->unique()->nullable(); // Nomor Induk Pegawai
$table->string('jabatan')->nullable(); // Misal: Statistisi Muda, Pranata Komputer
$table->string('foto')->nullable(); // Kolom untuk path foto profil
$table->enum('role', ['pegawai', 'kortim', 'kepala_kantor'])->default('pegawai');
// --- Relasi ke Tabel tims ---
$table->foreignId('tim_id')->nullable()->constrained('tims')->onDelete('set null');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::dropIfExists('users');
}
};
|