/** * Run the migrations. * * @return void */ public function up() { Schema::create('User', function (Blueprint $table) { $table->increments('id')->index(); $table->string('email')->unique(); $table->string('password', 60); $table->tinyInteger('isActive')->default(true); $table->rememberToken(); $table->timestamp('createdAt')->default(DB::raw('CURRENT_TIMESTAMP')); $table->timestamp('updatedAt')->default(DB::raw('CURRENT_TIMESTAMP' . MyMigrationHelper::getTimestampUpdateSetting())); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('Medicine', function (Blueprint $table) { $table->increments('id')->index(); $table->string('genericName'); $table->string('commercialName'); $table->string('brand'); $table->string('unitMeasure'); $table->text('defaultInstructions')->nullable(); $table->timestamp('createdAt')->default(DB::raw('CURRENT_TIMESTAMP')); $table->timestamp('updatedAt')->default(DB::raw('CURRENT_TIMESTAMP' . MyMigrationHelper::getTimestampUpdateSetting())); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('PatientHistory', function (Blueprint $table) { $table->increments('id')->index(); $table->unsignedInteger('FK_patientId'); $table->unsignedInteger('FK_doctorId')->nullable(); $table->unsignedInteger('FK_diseaseId')->nullable(); $table->date('checkupDate'); $table->time('checkupTime'); $table->text('diagnosis'); $table->timestamp('createdAt')->default(DB::raw('CURRENT_TIMESTAMP')); $table->timestamp('updatedAt')->default(DB::raw('CURRENT_TIMESTAMP' . MyMigrationHelper::getTimestampUpdateSetting())); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('Patient', function (Blueprint $table) { $table->increments('id')->index(); $table->string('firstName'); $table->string('middleName')->nullable(); $table->string('lastName'); $table->date('birthDate'); $table->text('address')->nullable(); $table->string('occupation')->nullable(); $table->enum('sex', ['Male', 'Female']); $table->integer('FK_raceId')->nullable(); $table->string('fatherName')->nullable(); $table->string('fatherOccupation')->nullable(); $table->string('motherName')->nullable(); $table->string('motherOccupation')->nullable(); $table->string('contactNumber')->nullable(); $table->integer('FK_clinicId')->nullable(); $table->timestamp('createdAt')->default(DB::raw('CURRENT_TIMESTAMP')); $table->timestamp('updatedAt')->default(DB::raw('CURRENT_TIMESTAMP' . MyMigrationHelper::getTimestampUpdateSetting())); }); }