| <?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('users', function (Blueprint $table) { |
| $table->id(); |
|
|
| |
| $table->string('name'); |
| $table->string('email')->unique(); |
| $table->timestamp('email_verified_at')->nullable(); |
| $table->string('password'); |
| $table->rememberToken(); |
|
|
| |
| $table->string('nip', 20)->unique()->nullable(); |
| $table->string('jabatan')->nullable(); |
| $table->string('foto')->nullable(); |
| $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'); |
| } |
| }; |
|
|