/**
* 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()));
});
}
