rujak / database /migrations /2014_10_12_000000_create_users_table.php
mootalu's picture
Upload 229 files
85b674d verified
Raw
History Blame Contribute Delete
1.38 kB
<?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');
}
};